Can anyone tell me what is wrong with this code? Please!!
Here is what I'm trying to do. Column A, B, C has the correct data
I’m trying to have Excel look at the contents in Cell E (Account #2) and match it with A,B,C and extract to another column (say G). B cell goes to 427,776 rows and E cell goes to 1,406. The end goal is to get the Salesforce ID & Company name lined up with the accounts in Account #2. I’ve got to load the data into SF for Column E with the SF ID. Salesforce will not recognize internal Account ID so the SF ID has to be aligned with the proper company for the accounts in Account #2. A sampling below
I would greatly appreciate any help that can be offered.
Company SF ID Account # Account # 2
Mag Hotels/Midvale 0017000000ekiOb 5970 3267750
Deve Kennedy 0017000000n1d7n 12864550 1644820
Oglethoe Motel 0017000000jpNT3 6091099 6186657
I don't know what I'm doing wrong but keep getting a compile error. I have tried different values for the "Do" command line, all to no avail.
Here is the code:
Bookmarks