Inserting Row in Multiple Worksheets

  • Thread starter Thread starter Michael Ryba
  • Start date Start date
M

Michael Ryba

I have a workbook with multiple worksheets in it. Each
worksheet contains the same data, the only difference is
how it is sorted. I would like to be able to add a row to
the initial workheet and have that row populate
automatically to the other worksheets but, I do not know
how to perform that function. I know that I could add the
row to the first sheet and then cut and paste to the
others but, that would be time consuming. The automated
solution is really what I am looking for. Any help would
be appreciated.
Thanks.
 
Wow what timing. "grouping" is something we just talked about the other day.
Go to any sheet, hold CTRL and click on the other sheets (or you can use
shift to select a range of sheets). then add your row in one of them, and it
will be done to all. You can then ungroup them.
 
Back
Top