How to copy data from one spreadsheet to all others
Closed
LEJN
Posts
2
Registration date
Thursday November 27, 2014
Status
Member
Last seen
November 28, 2014
-
Nov 28, 2014 at 01:20 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 6, 2014 at 10:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 6, 2014 at 10:23 AM
Related:
- How to copy data from one spreadsheet to all others
- Transfer data from one excel worksheet to another automatically - Guide
- Google spreadsheet right to left - Guide
- Tmobile data check - Guide
- Spreadsheet function - Guide
- Display two columns in data validation list but return only one - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 28, 2014 at 09:56 AM
Nov 28, 2014 at 09:56 AM
you can create that macro quite easily yourself by using macro recorder
LEJN
Posts
2
Registration date
Thursday November 27, 2014
Status
Member
Last seen
November 28, 2014
Nov 28, 2014 at 11:32 PM
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
Kind regards,
LEJN
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 6, 2014 at 10:23 AM
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"
you can then modify that to suit your need.
you can loop thru each sheet and call that "modified macro"
