Export data from worksheet to another Excel file

Closed
tamiwsw Posts 2 Registration date Monday December 28, 2015 Status Member Last seen December 29, 2015 - Dec 29, 2015 at 12:21 AM
tamiwsw Posts 2 Registration date Monday December 28, 2015 Status Member Last seen December 29, 2015 - Dec 29, 2015 at 05:23 PM
Hi

I would like a macro that cam help me export data to another file.

I have an Excel form which I would like to move the entries into another spreadsheet saved in a shared drive. The file on the shared drive will be the master spreadsheet of all entries keyed into the form. After exporting the form details, the information in the form is cleared.

Can someone please help me with a macro that would save data and add to the list each time i transfer (ie I dont want it to create multiple sheets).

Many thanks

Tami

1 response

askforme123 Posts 17 Registration date Monday December 28, 2015 Status Member Last seen December 29, 2015 7
Dec 29, 2015 at 03:46 PM
Greetings Tami , this is what you should do ....

On the very top of your keyboard you should see keys saying F1, F2 until F12 . the one next to the F12 says PrtSc (Print Screen). Then on your keyboard near the bottom left you should find a button saying Fn (Function) keep holding 'Fn' and 'PrtSc' at the same time . And then right click on wherever you want to place it and click paste and it should come up (the whole screen)
tamiwsw Posts 2 Registration date Monday December 28, 2015 Status Member Last seen December 29, 2015
Dec 29, 2015 at 05:23 PM
Thanks for your response and assistance.

Im not after a picture. I need a macro that will do what I need

Cheers

Tami