Compile Data In Excel Files

Completed Posted Sep 5, 2011 Paid on delivery
Completed Paid on delivery

We have several excel files from a furniture manufacturer. We need all the information compiled into 1 master spreadsheet because we plan to import everything into a website to sell online.

The files list all their furniture. We want ONLY the items listed under the "Bedroom" category in each spreadsheet. (ignore entertainment, dining, organizational, sections etc.)

Each spreadsheet represents a product series. Products are grouped by sets. For example, each furniture set may contain 3 or 4 products. We want 1 comprehensive table with all the individual items from each set and another table to list each set.

We've created a screenshot of a sample spreadsheet and how the data should be complied. We've also attached a .zip with all the product spreadsheets and a .zip with 2 sample tables of how we want the data compiled.

## Deliverables

Data from all spreadsheets must be compiled in the format in the example tables.

See attached picture describing what needs to be done.

Files have been attached as well for you to evaluate.

Data Entry Excel Microsoft Access Microsoft Exchange Odd Jobs Powerpoint Word

Project ID: #3554363

About the project

26 proposals Remote project Active Sep 6, 2011

Awarded to:

gribfritz

See private message.

$42.5 USD in 14 days
(361 Reviews)
7.4

26 freelancers are bidding on average $47 for this job

dpune

See private message.

$75 USD in 14 days
(95 Reviews)
5.7
BrothersTeam

See private message.

$70 USD in 14 days
(140 Reviews)
5.7
amcsummers

See private message.

$100 USD in 14 days
(50 Reviews)
5.5
sammahmud

See private message.

$15 USD in 14 days
(90 Reviews)
5.5
vnb400sl

See private message.

$50 USD in 14 days
(82 Reviews)
5.4
quickprogexpert

See private message.

$50 USD in 14 days
(51 Reviews)
5.3
ragastens

See private message.

$80 USD in 14 days
(75 Reviews)
5.2
amirn2011

See private message.

$45 USD in 14 days
(64 Reviews)
5.1
Lotusdeveloper

See private message.

$80 USD in 14 days
(64 Reviews)
5.0
simona2002

See private message.

$42 USD in 14 days
(86 Reviews)
4.6
Asprovider

See private message.

$15.99 USD in 14 days
(40 Reviews)
4.5
vette95

See private message.

$40 USD in 14 days
(11 Reviews)
3.7
dreamtosucceed

See private message.

$20 USD in 14 days
(10 Reviews)
3.3
0emu0

See private message.

$15 USD in 14 days
(31 Reviews)
3.2
Ararin

See private message.

$10 USD in 14 days
(5 Reviews)
2.6
ProudIndian

See private message.

$25 USD in 14 days
(8 Reviews)
2.5
SOFTCODERR

See private message.

$56 USD in 14 days
(11 Reviews)
2.4
funtoox

See private message.

$40 USD in 14 days
(13 Reviews)
2.4
rbobiedovw

See private message.

$95 USD in 14 days
(2 Reviews)
0.0
room84studious

See private message.

$40 USD in 14 days
(0 Reviews)
0.0