Fairly new to Macro's so I need some help with the following:
I have a tab called 'data' that has between 200-500 rows and the count of rows changes depending on another export file. I have 10 other tabs named '1', '2', '3'....up to '10'. What i need is a macro that will evenly distribute rows from the 'data' tab to the numbered tabs
see if this works for you. This assumes a header row 1 in all sheets, If not then change the 2 to 1 and remove the (- 1) and change Range("A2") to Range("A1").
Please Login or Register to view this content.
Last edited by JLGWhiz; 04-24-2018 at 12:03 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks