Copying and pasting data from one spreadsheet to another

[paulandrews]

Hi All,

I need to create a macro to which copy and pastes data from workbook one to workbook 2, while also ensuring that the pasted data reforms to workbook 2's formulas. I would like to be able to hit a "Submit" button which would copy and paste the data from workbook 1 to workbook 2. I am using Excel 2007.

I'd appreciate any help you have... I have a deadline and I'm terrible at excel!!!!

Thanks and Regards,
Paul

 

[paulandrews]

Thanks for that! But it seems it's still not working. It doesn't seem to like this line here:

    LastCol = Sheets(ts).Cells(2, Sheets(ts).Columns.Count).End(xlToLeft).Column

I really appreciate all your help with this, by the way.

 

[Datsmart]

In post #6 I asked you if you had a sheet called "Sheet5".
In post #7 you said...

No, it's called utilization data. I updated the code to reflect this and on running the macro the same error appears with the same line of code indicated and causing the error.

Then in post #9 you posted your code that used the sheetname "Sheet5".
If you are using "utilization data" rather than "Sheet5", change the assignment of the "Target Sheet" variable from this...

    ts = "Sheet5"

To this...

    ts = "utilization data"