How to copy data from one spreadsheet to all others

Closed
LEJN Posts 3 Registration date Thursday November 27, 2014 Status Member Last seen November 28, 2014 - Nov 28, 2014 at 01:20 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 6, 2014 at 10:23 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Nov 28, 2014 at 09:56 AM
you can create that macro quite easily yourself by using macro recorder
0
LEJN Posts 3 Registration date Thursday November 27, 2014 Status Member Last seen November 28, 2014
Nov 28, 2014 at 11:32 PM
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
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Dec 6, 2014 at 10:23 AM
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