Excel - Copying from one sheet and writing to another file. [Closed]

Report
Posts
1
Registration date
Friday May 22, 2015
Status
Member
Last seen
May 22, 2015
-
I have a form created in excel where the user enters customer information such as Name, Address, Phone #, etc.

I need the info to be copied and written to a separate excel file, on the next available blank row. Also does the file being written to need to be open at the time?

I have no experience with VBA, looking for some code that I can use and modify.

Thanks,
Dave

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!