Open a new workbook and populate form

Closed
jman - Dec 4, 2011 at 08:33 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 5, 2011 at 11:46 AM
Hello,

I have a "data" sheet with customer information that is updated automatically all day. When a new line of data is downloaded to my "data" sheet I would like to have a new workbook open up and copy the data from the first new row into the new book and name the workbook the value of one of the cells, (say a3) and automatically save and close the new workbook.

Thanks,


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 5, 2011 at 11:46 AM
well the code that updates you data, you can add a new line to open a new workbook right ?
0