Hi,

I am new to using Macros - very simple ones at that. I want to know if something is possible to do. I have a report of around 100 - 200 lines which for each line I need a new spreadsheet with information from certain cells copied into specific cells in the new spreadsheet. So for example I would have a new spreadsheet for row 1, with data from C1 pasted into cell M4 on the new spreadsheet, data from cell D1 pasted into cell E20 etc with a new spreadsheet for each row.

I sthis possible & if so I do I go about doing it?

Thanks