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
Related:
Excel - Copying from one sheet and writing to another file.