mwedikumenyanga
New Member
- Joined
- Jun 19, 2007
- Messages
- 15
I need to create a macro which will select a named range depending on value in a named cell.
Cells A1:D10 contain data which can be 1 to 10 items.
Cells E1:E10 will change on each row from 0 to 1 when any of the cells in columns A1:D10 is not =0
Cell E11 contains total of E1:E10 and is named ItemTot
Cells A1:D10 is named Items10 and will be selected if ItemTot = 10
Cells A1:D1 is named Items1 and will be selected if ItemTot = 1
Cells A1:D2 is named items2 and will be selected if ItemTot = 2 etc
A solution to this problem will make my day.
Thank you
Cells A1:D10 contain data which can be 1 to 10 items.
Cells E1:E10 will change on each row from 0 to 1 when any of the cells in columns A1:D10 is not =0
Cell E11 contains total of E1:E10 and is named ItemTot
Cells A1:D10 is named Items10 and will be selected if ItemTot = 10
Cells A1:D1 is named Items1 and will be selected if ItemTot = 1
Cells A1:D2 is named items2 and will be selected if ItemTot = 2 etc
A solution to this problem will make my day.
Thank you