Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
First Sheet,First column as template
Hi gurus,
I have a unique requirement. I need to have my first sheet first column as a template. In other words, whenever i add a new sheet, the first column of that sheet should be automatically populated by first sheet first column. Is there any code to do that? Also if i insert a new row to first sheet, the rest of the sheets should automatically adjust to it. If i delete or update also, the rest of the sheets should reflect it. Can anybody help me out please? thank you P.S. The rest of the columns will have different values in all the other sheets. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
First Sheet,First column as template
Instead of adding a new blank sheet, just copy the worksheet.
Edit|move or copy sheet then clean up the columns you don't want (B:IV???) And when you want to insert/delete a row, group the worksheets before you do it. rightclick on a worksheet tab and choose Select All Sheets. Then do the insert/delete. Remember to ungroup them when you're done. Any change done to one will be done to all in grouped mode. "marxbalz <" wrote: Hi gurus, I have a unique requirement. I need to have my first sheet first column as a template. In other words, whenever i add a new sheet, the first column of that sheet should be automatically populated by first sheet first column. Is there any code to do that? Also if i insert a new row to first sheet, the rest of the sheets should automatically adjust to it. If i delete or update also, the rest of the sheets should reflect it. Can anybody help me out please? thank you P.S. The rest of the columns will have different values in all the other sheets. --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare sheet 1 column A numbers with sheet 2 column A number | Excel Worksheet Functions | |||
How to re-size a Balance Sheet template?? | New Users to Excel | |||
Template for Balance sheet | New Users to Excel | |||
How to merge data in Excel - one sheet to template sheet? | Excel Worksheet Functions | |||
time sheet template available | Excel Discussion (Misc queries) |