PDA

View Full Version : macro code to switch worksheets?



hrakowski
07-05-2009, 06:46 PM
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