This should get you on the right track;
http://www.ozgrid.com/VBA/item-worksheets.htm
--
Regards
Dave Hawley
www.ozgrid.com
"Joy" wrote in message
...
I have a master sheet with details of quotations for different clients. Is
there anyway to copy the rows of information for each different clients'
name
onto seperate worksheets, and then as more quotations are entered onto the
master these would then be automatically placed into the relevant
worksheet
for that client.
Hope you understand what I am trying to do. Many thanks for any response.
Joy