Macro Importing customer form data into an exisiting list on a different folder.

[outlawdevil]

Hi,

I have a data entry form that I want to create a macro that I can import these data into an existing list on a folder.

1) find the last available row in the list in Column A
2) I want to dictate which field goes to which column (they should be on the same row).

let's say there are 100rows already.

these should be in A101 C101 F101 E 101, I want to customize so I can change which field goes where.

Thanks. I have attached example. thanks.

customer form.xlsx
	A	B
1
2	Customer ID	JohnDOWUS001
3
4	Name	John Dow
5
6	Address	American Ave
7
8	SS#	123456789
Customer info