Need code to get data from an open workbook

[thedon_1]

Here is my situation. I have a work book that i'm working with. I have a sheet, let's say Data_Old. I want code that will delete data from cell A3 to the last used cell (e.g B50).

I then want the macro to look through my open woorkbooks and find a worksheet sheet called Data_new. I then want it to copy the data from A3 to the last item(e.g B60) and then paste it into Data_old.

If someone could give me some code on how to do that, it would be great. I would then be able to minipulate it for similar situations.

Thanks

[timbo1957]

Try this. I don't know the names of your workbooks so have used the same as the worksheets.

Please Login or Register  to view this content.

[thedon_1]

Thanks for that.

What if I don't have the name of the workbook with the new data? This will be a workbook outputed from another program and will use a random name. Can this code be ammended to search for the "Data_new" sheet in all the open worksheets?

Thanks

[Kyle123]

it's a bit tricky without seeing your data, but something like:

Please Login or Register  to view this content.