In Progress

Populate Excel spreadsheet from another spreadsheet

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"

Flow:

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.

Regards!

Skills: Excel

See more: populate excel spreadsheet, excel populate file, populate spreadsheets, formula populate spreadsheet, find flow, excel work freelancers, excel word freelancers, excel 16, excel spreadsheet formula, find professional freelancers, xlsx, populate, excel working freelancers, excel type work, excel formulas, excel formula, create spreadsheet, b blue, another, spreadsheet columns, highlighted map, excel cell, excel minute, pick excel, excel find select

About the Employer:
( 1 review ) Lahore, Pakistan

Project ID: #1249437

Awarded to:

ethicalboy

I can do it, its very easy, lets go:)

$8 USD / hour
(23 Reviews)
4.5

4 freelancers are bidding on average $12/hour for this job

abhiyendrak

"Eformula

$15 USD / hour
(0 Reviews)
0.0
josephrowan

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

$15 USD / hour
(0 Reviews)
0.0
manoharm

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.

$10 USD / hour
(0 Reviews)
0.0