S
SixBowls
I have a list of tasks on a sheet1 (b14:b43). There can be one to thirty
tasks on the list. On a sheet two, I use the tasks as column headers
(h7:ak7). I have formulas that feed the column heading - cell h7 on sheet2
has the formula ='sheet1'!$b$14. Sheet2 Rows 8 thorugh 57 require data entry
and rows 62 through 111 are static formulas based on the data entry. Ex.
cell h62 = h8*d8*$b$2, cell h63=h9*d9*$b$2. I also have totals in column AL.
More often than not, I have far less than 30 tasks and have to hide the
unused columns. Is there a way I can create columns starting with the first
task on sheet1 and moving down until I hit a blank row on sheet1. I would
like to insert the columns onto sheet2 so the formulas and totals column do
not need to be redone each time.
tasks on the list. On a sheet two, I use the tasks as column headers
(h7:ak7). I have formulas that feed the column heading - cell h7 on sheet2
has the formula ='sheet1'!$b$14. Sheet2 Rows 8 thorugh 57 require data entry
and rows 62 through 111 are static formulas based on the data entry. Ex.
cell h62 = h8*d8*$b$2, cell h63=h9*d9*$b$2. I also have totals in column AL.
More often than not, I have far less than 30 tasks and have to hide the
unused columns. Is there a way I can create columns starting with the first
task on sheet1 and moving down until I hit a blank row on sheet1. I would
like to insert the columns onto sheet2 so the formulas and totals column do
not need to be redone each time.