Unload Data into another Workbook.

[ben78]

Hello,

I'm hoping this is an easy coding issue.

I have a input sheet (not user form) for data entry and the data is entered in to another tab via a macro on completion.

I would like to have the data entered in to different workbook.

Can you tell me if this is possiable and if so what would I need to do to change the 'Worksheets("DATA")' part?

Please Login or Register  to view this content.

Thanks in advance

Ben

[Domski]

Something like this:

Please Login or Register  to view this content.

Dom

[ben78]

Hi Dom

Sorry for the delay in getting back to you.

I've copied the code into my module, created the workbook I'm to use, re-named a tab to "DATA" and changed the code to this workbook.

when I run the macro it opens the workbook ok but then I get a runtime error 9 starting on the line

Please Login or Register  to view this content.

.

Full module is as follows,

Please Login or Register  to view this content.

Do I need to reference the worksheets("INPUT PAGE") as an active workbook?

Any help apreticated (I'm very wet behind the ears regarding VBA)

Ben

[Domski]

Try this:

Please Login or Register  to view this content.

Dom

[ben78]

Dom

Made a slight change to tell it which tab to copy to.

Please Login or Register  to view this content.

It now works to prefection.

Thanks Again,

Ben

[Domski]

Dom

Made a slight change to tell it which tab to copy to.

Please Login or Register  to view this content.

It now works to prefection.

Thanks Again,

Ben

Aye, I didn't test it but should have spotted that little omission.

Dom