Creating Named Ranges or Labels for existing workbook

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
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,191,204
Messages
5,985,270
Members
439,953
Latest member
suchitha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top