I have sheet1 with about 500 rows of data and 10 tabs that I would like to create a button (macro), so I can click it and 50 rows of data from sheet 1 copy and paste into each tab.
I have sheet1 with about 500 rows of data and 10 tabs that I would like to create a button (macro), so I can click it and 50 rows of data from sheet 1 copy and paste into each tab.
Hi sasquatch2014
This should do the trick assuming that the other sheets are already available i.e sheets 1 to 11 with sheet1 containing the information.
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thanks for the reply. The macro only copies column A. Also, I failed to mention that I would like the field names from sheet 1 copied onto each tab as well.
Maybe this modification to Sintek's code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks