Thread: Help with copy entire row in a new workbook using a specific value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Help with copy entire row in a new workbook using a specific value
Hi Jen

Maybe this will help
http://www.rondebruin.nl/copy5.htm

Try this example
http://www.rondebruin.nl/copy5.htm#workbook

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jen" wrote in message ...
Hi,

I have a list with values and i need to create a new workbook based on the
different values of one of these columns and also copy the entire range based
on that value.
For ex:

Name desc File name
Jenifer test File1
Robert test File2
Dawn test File3
Pedro test File4
Dean test File5

Using File name for the specific value. Create 5 different workbooks and
copy the entire row with it.

Thanks

Reply With QuoteReply With Quote