-
macro code to switch worksheets?
I'm working on a very basic simple macro in an excel 2007 document. I recorded the macro to take the data from one row in one tab and insert it into another cell in a different tab. Now I am looking for the code to get the macro to run from row 1 data in tab "a" to switch to row 2 data in the next tab "b" and so on.
I'm pulling data from tab "students" which has 200 unique rows. I have created a tab with each student's name and now I need to merge the data from row 1 into student1's tab, and row 2 into student2's tab, and row 3 into student3's tab, etc, etc.
Thanks for any help in advance.
-Hadley
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules