nothinkingbehind
New Member
- Joined
- Jan 19, 2008
- Messages
- 22
I have a workbook template that uses imported data and then analyses that data on a dozen or so sheets. My client now wants to use named ranges or labels instead of cell references for clarity reasons. I have no problem with it, but I haven't done much with names or labels and I'm not sure what the best option is. I tried some named ranges, but because I have headers and titles on all of the sheets, it is pulling from the wrong cells in the raw data sheet. IE, my sheet of results begins at cell A3 and so the first row of data contains data from row 3 of my raw data instead of row 2 as it should. I have a feeling I'm making this far more compicated than it should be..... any help would be appreciated!
Example:
Raw Data Sheet:
Machine Allowance Price per page
Machine 1 1000 .02
Different sheet in workbook:
Machine Service total (allow X PPP)
Machine 1 $20.00
Also, there are some very complex formulas here (which is why it makes sense to go to names) but this is a simple example of what I am trying to do.
Thanks
Example:
Raw Data Sheet:
Machine Allowance Price per page
Machine 1 1000 .02
Different sheet in workbook:
Machine Service total (allow X PPP)
Machine 1 $20.00
Also, there are some very complex formulas here (which is why it makes sense to go to names) but this is a simple example of what I am trying to do.
Thanks