• 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.

Recent content by smc001

  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...
Back
Top