It is a macro. Read this and modify to suit. If all else fails send to me
and I'll look later.
If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Parker Jones" wrote in message
...
Thanks Don, I was just wondering where to put that formula.

My master list is on Sheet 2 and I need the value in column H (3-12) to
transfer its row (ex: A5-J5) to the sheet corresponding to H (3-12).

So if H5 reads 7 then A5:J5 have to move to the next available row on
sheet
seven.

Thank you for all of your help so far.