Help with copy entire row in a new workbook using a specific value
 

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

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

Help with copy entire row in a new workbook using a specific v
 

Thank you so much!!! This was very helpful!!

"Ron de Bruin" wrote:

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