Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Columns Based on List
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting a number from a particular cell based on if/thens | Excel Discussion (Misc queries) | |||
lock a total row below a list & allow inserting in the list? | Excel Worksheet Functions | |||
Inserting picture into excel based on # in the another cell | Excel Worksheet Functions | |||
inserting new columns | Excel Discussion (Misc queries) | |||
inserting a row based on a condition. | Excel Worksheet Functions |