ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Create an Excel file using a macro (https://www.excelbanter.com/excel-discussion-misc-queries/64018-create-excel-file-using-macro.html)

Cillian

Create an Excel file using a macro
 
Hi,

I have a tempalte file to which some data needs to be entered. The data
comes in a big list of about 200 rows, with five columns - so five cells have
to be copied from each row into the template and saved seperately.

What I would like to do is to create a macro that will copy the cells from
each row into the template and save the template with the file name equal to
the value of the first two cells.

Can any one help?
--
Cillian


All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com