Need a pro to make a template - have donation for them or their choice cause

[innovativesmoking]

I am decent with excel but i need something kind of fast and dont have the time to do the job. I dont know the functions fluently enough to do it inthe time i need it. Here is what I need and Im willing to compensate whoever does it $50 via paypal.


I have 2 sheets of data. Both are a list of customer names and then different data after it. One has name, address, tele, email, total items purchased. The other has name, name, address, tele, last visit to store. I need to merge this info together so it combines the extra colums from each sheet into one.

I want it to be a template that I can plug in the 2 sheets on sheet 2 and 3 then on sheet 1 it has the combined data. You cant just do a simple copy and past as the sorting is not exactly the same and some lists have more than the other. I just need to be sure to merge the duplicate info.

I will supply you both lists. it will be raw data that i want a nice merged finished product. I need it done in 12 hours. Anyone with time looking for a donation?

[royUK]

I've moved this to the Commercial Services Forum

Attach example workbook

[innovativesmoking]

I want to merge the data from both sheets. I need a template that i can just run these same reports and put into the template and it would spit out a nice 1 page list of all the customers with the info I want. These are 2 separate reports and i need some info from each all together on one report. notice the lists are not exact so need to search by last and first name and then combine all the data. Input one report on sheet 2 and the other on sheet 3, sheet one would have the merged and neatly formatted merge of the data from both lists.