How to copy data from one spreadsheet to all others

Closed
Report
Posts
3
Registration date
Thursday November 27, 2014
Status
Member
Last seen
November 28, 2014
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Please, does anyone have a macro to copy data from a specific range on a standard sheet (ideally with formatting) to all but one other sheet active in the workbook?

Your assistance would be much appreciated.

3 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can create that macro quite easily yourself by using macro recorder
0
Posts
3
Registration date
Thursday November 27, 2014
Status
Member
Last seen
November 28, 2014

Dear Rizvisa1, I will certainly do that and it will work when the number of sheets is known. How about when the number of sheets and the names are not known?

Kind regards,
LEJN
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
recorded marco for most case is a first step only
you can then modify that to suit your need.

you can loop thru each sheet and call that "modified macro"
0