wibbers2000
08-03-2008, 07:31 PM
I would be greatful if anyone can assist
I have a spreadsheet that uses named ranges, however these ranges (cell references) change weekly so have to manually change the named ranges to suit.
Excel sheet attached.
What I would like to do is look at column A as the deciding factor.
So in this case I would like the first 6 row to determine the first namimg range. to offset by 3 columns and call this range casingcode, then offset by 1 column and call this range casingdesc, then offset by 1 column and call this range casingcost
then back to column A to pick up a new code of CPU and again raise 3 named ranges cpucode, cpudesc, cpucost
etc etc down column a until all products are done. However column A is dynamic in the fact the next week there may only be 5 rows for casing.
Can this sort of dynamic naming be done?
If so could some please point me in the right direction.
ps the sheet is a very small sample I have approx 1400 rows with maybe 25 different ref in column A
I have a spreadsheet that uses named ranges, however these ranges (cell references) change weekly so have to manually change the named ranges to suit.
Excel sheet attached.
What I would like to do is look at column A as the deciding factor.
So in this case I would like the first 6 row to determine the first namimg range. to offset by 3 columns and call this range casingcode, then offset by 1 column and call this range casingdesc, then offset by 1 column and call this range casingcost
then back to column A to pick up a new code of CPU and again raise 3 named ranges cpucode, cpudesc, cpucost
etc etc down column a until all products are done. However column A is dynamic in the fact the next week there may only be 5 rows for casing.
Can this sort of dynamic naming be done?
If so could some please point me in the right direction.
ps the sheet is a very small sample I have approx 1400 rows with maybe 25 different ref in column A