Do I understand you correct that after it copy the data to a sheet you want to name
the sheet as the value in F2 ?
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"David" wrote in message ...
Hi Ron,
I used the code which copies the data in a different sheet, it worked great,
thank you, however one little change that i cant make, i want the macro to
name the sheets based on data on Col F2, how can i modify the code?
thanks
david
"Ron de Bruin" wrote:
Hi Troy
See
http://www.rondebruin.nl/copy5.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Troy" wrote in message ...
I'm using excel 2003.
I have a worksheet full of maintenance data. Each row on this sheet has a
machine number, date, repair information, etc.
I'm trying to make a marco to search thur the list for a specific machine
number copy all the data from that row and paste it on a different sheet.
All of the entries for that machine number would then be copied to that new
sheet.
Does anyone know how to do this?