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