First Sheet,First column as template

  • Thread starter Thread starter marxbalz
  • Start date Start date
M

marxbalz

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.
 
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.
 
Back
Top