I have multiple excel files that I need to pull data from and put into a new excel document.
For example - One doc may have '123456' in a field. In doc 2, that line may read 61C123456. I need to be able to pull the information in doc 1 (123456) find the line item in doc 2 that ends in (123456), and put it in the new doc to read 61C123456 (with all of the rest of the information from doc 1).
This is one example of what I am looking for. There are a few more items, just like it.
93 freelancere byder i gennemsnit $957 på dette job
Dear Sir/Ma'am, I can pull data from and put into a new excel document. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
I believe that you can accomplish what you want with lookups and a few formulas. I have 19 years experience in excel. I have taken all classes 07 to 13. beginner to expert.