copy one row at a time to different worksheets

R

Roxie720

I have a master list with 40 rows of information and need to copy one row at
a time to 40 different worksheets. For example Row 24 needs to be placed in
worksheet 1; Row 25 to worksheet 2; Row 26 to worksheet 3, etc.

I know how to copy/paste but is there a formula or macro to that I can use
so I am not copying/pasting for a life time?

Thank you
 
O

Otto Moehrbach

You would use a macro for that. What is the logic that this row goes into
that sheet? Is there information of some kind in some column that dictates
the destination sheet of that row? HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top