• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Life is a precious gift that must be cherished and embraced by doing our part through positive...

    Life is a precious gift that must be cherished and embraced by doing our part through positive contribution...
  2. S

    Find average on a row spanning many columns?

    I sent it to you at your gmail account via email... Thank You!
  3. S

    Find average on a row spanning many columns?

    Ate you wanting me to test accessibility? It should open for you...Let me know if not I can send via email... ;)
  4. S

    Find average on a row spanning many columns?

    I tried the formula and have DIV# errors... I have uploaded the sample doc as per requested HUI...Heres the link to my sample in drop box.... http://dl.dropbox.com/u/15655422/Sample.xlsx Thank you!!!!! (any other suggestions are eagerly welcomed!!!
  5. S

    Find average on a row spanning many columns?

    HELP!!!!! Any Ideas!!!!
  6. S

    Find average on a row spanning many columns?

    Row1-row500: Product Names, Store A - Column2: # of products in inventory... sometimes zero Store A - Column3: Cost of Products...sometimes zero (if price has not been key'd) Store B - Column4: # of products in inventory... sometimes zero Store B - Column5: Cost of Products...sometimes...
  7. S

    Find average on a row spanning many columns?

    I have large spreadsheet with many rows and columns... Each row is a product. the columns adjacent list., column 1:location, column2:# products in stock . column3:cost of product... Im trying to find the average product cost which is gathered from all the locations total spanning all locations...
  8. S

    Extrapolate Totals from chosen Groups

    Hello Chaos is back... It's Been awhile. Looking for best approach. I have Specific Names (Job Titles) that are listed in 1st column one. There are adjacent columns providing Names of 20 Locations (Site 1-20) with # of positions, and Annual Salary of position for dept within site (so they...
  9. S

    How can you automatically add rows from a source report data to a linked report?

    Happy New Year!!! Did you get a chance to review... Thanks...
  10. S

    How can you automatically add rows from a source report data to a linked report?

    Okay... Heres the link... THANK YOU!!! https://skydrive.live.com/redir.aspx?cid=8c4598bed3ef132a&resid=8C4598BED3EF132A!118&parid=8C4598BED3EF132A!108&authkey=!APbwTT7JCa7_nJc I have given instruction in the report as too how the master report is feed by the field reports... Keep in mind I...
  11. S

    How can I keep a Prior Total Value and Allow for a New Total Value to update?

    I have made the CMDUPDATE changes and everything per your instruction. One thought about the cell M21 wks1 and E32 and E34. Are each of those cell to be blank? Of course thers'a sum formula in M21 because it's summing a total column.. As for the E32 its a link from M21...As for E34 that is...
  12. S

    How can I keep a Prior Total Value and Allow for a New Total Value to update?

    Rats! I got the button to look like it works... It does not pop up anything like your example...as well it's kind of random when I think it's work, but it really isnt' working well..... These are the reference info... maybe you can make it work this way... I put the button on the Base report...
  13. S

    How to make the user to enable macros and Enter the mandatory fields

    okay... I am not sure where I found it I have been collecting for a couple of years randomly... As for adding for a reference doc... I did not even know if it was functional so that's why I put it out there for Experts hands to figure out... Thank you for your guidance... Once I know something...
  14. S

    How can you automatically add rows from a source report data to a linked report?

    Well I have within each report (15 or so Sections of categories) So each category holds 8-10 rows or in some cases I had knowledge of a category needed 40 rows so accomadated... I had did a grouped additional 50 rows per category on each ans started running in to memory issues... The...
  15. S

    How can I keep a Prior Total Value and Allow for a New Total Value to update?

    Thank You! Thank You! for the Details!!! NOW I AM OFFICIALLY DANGEROUS!!! Kid in a Candy Store and Licenses to Drive! I will let you know if I can make this work. Keep your Fingers Crossed!
  16. S

    How do you Match 2 Columns Criteria and Populate the values associated?

    Structure...hmmmmm of course.... This is what it looks like now... Source Report Random Auto Generated Information (Columns A-AA), Source Report: Columns which we are Scanning for a match: E2 (USER NAMES) G2 (TASKS) J2 (DEPARTMENT ASSIGNED) K2 (DESCRIPTIONS) O2 (DOLLAR VALUE) S2...
  17. S

    How to make the user to enable macros and Enter the mandatory fields

    I found a code that will force users to enable macros to access a document if they don't accept enable macro's this would give them no choice in the matter and it won't allow access to the complete document. I am not sure what the protocol is for offering advice, since I have never had...
  18. S

    How do you Match 2 Columns Criteria and Populate the values associated?

    Can this setup apply if I have to search for categories specific total values? Lets say all travel and obtain total dollar value... Then I need to find all communications total dollar value... Then I need to find all Hardware total dollar value.... I was looking at the following formula and...
  19. S

    What Formula is the Best Approach to this Problem

    No Worries! God Bless and thank you for all your assistance!!! Happy Holidays and May the New Year bring Great Prosper and blessings to Us all!
  20. S

    How can you automatically add rows from a source report data to a linked report?

    I need the code to only insert row when required in specific worksheets... My report is setup as such...I have multiple catogories that have 8 rows (5 columns) to hold it's data. These rows and columns are all linked to the source report.. Category: Column1 | Column2 | Column3 |...
  21. S

    How can I keep a Prior Total Value and Allow for a New Total Value to update?

    WONDERFUL!!!!! It works like Magic! Now how do I add this (button-magic) to my other reports... I see you can go to developer tab, view code...Under the VBAProject report Test Total, sheet1 I see code is placed...Can I copy this code and do the same thing for the other reports? Is that the...
  22. S

    How can I keep a Prior Total Value and Allow for a New Total Value to update?

    Scratch the last link this one should work: https://skydrive.live.com/redir.aspx?cid=8c4598bed3ef132a&resid=8C4598BED3EF132A!117&parid=8C4598BED3EF132A!108&authkey=!ADGhnH76-yJ_0_s thanks
  23. S

    How can I keep a Prior Total Value and Allow for a New Total Value to update?

    Okay! I will need good directions on how to do this myself...I have other reports I need to do the samething with... Quit a few other eports infact... :) Here's the link... to the report... What you see in red on the worksheets are linked areas of report... Here's the link...
Back
Top