Open a new workbook and populate form

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
well the code that updates you data, you can add a new line to open a new workbook right ?