Hi to all freelancers.
Its a very easy task for the person who have good knowledge of excel formulas.
I have two spreadsheets named [url removed, login to view] and b.xlsx. I want that when I enter name of spreadsheet "[url removed, login to view]" in [url removed, login to view] in a blue highlighted cell it will automatically populate the respective columns (not all columns, so column needs to be mapped accordingly) from first file to another.
Also i need to map only those rows whose type = "single"
It first find the file by name lookup then > select respective columns (may be need to mentioned in formula to pick which columns) then > select only those rows whose type is "Single" (all rules in one formula)
Please create working formula in attached files, and then you have to tell me how can i edit the formula if i need to maped more columns from a.xlsx.
The work is simple, need a single working formula, i can Pay10$ for working formula. Not more than a 20 minute work for professional.
Please start your bid with the word "Eformula" so that i can find legitimate bids.
4 freelancers are bidding on average $12/hour for this job
Ok...I have this done. I work with Excel every day and know this process mapping spreadsheets. Certainly I can give you the formula and instructions for updates. Thank you for your consideration. joe
i am an engineer having a good experience in developing excel based programs. your work seems very easy. i am interested to take this job. mail me if interested.