combining many reports into same excel

so my task is simple and complicated at the same time. i dont care what software i end up using but i want the report to look the same as if i manually put it in.

i create a monthly sales report that also has open orders. and is setup to generate information from the sheet and another tab as well.

the project excel sheet is the sheet i manually created.

the end game here is that i dont have to manually input each item

now i use a system that generates reports so i can then input them into that excel sheet.

i can generate the reports into csv, pcr, htm, txt or xls i will attach xls's

File attached named open i deleted the names of the second half of the customers just because you should be able to understand from the first half.

now where it gets a little complicated.

the system generates different names for all different types of reasons billing shipping routing....

my excel sheet has the names of those customers how i want to see it.

also my excel sheet only focuses on the core customers and the extra customers get combined into 1

the way i breakdown the data before moving it over to my main excel sheet with all my info is as follows

i copy and paste special value in a new tab.

i then go ahead and delete all unnecessary columns and leave the customer and total $

i then create headers in the first 2 cells saying customer and dollar

i then highlight everything and sort by customer

then i go ahead and make every customer that is not part of the main customers and i change the name to z

then the customers that have more than 1 cell because they have 2 separate billing names in the system i convert to be the same.

then i make a pivot table i change the value field settings to sum and then i input to the main excel accordingly

i do very much the same with the invoiced sales. i changed the customer names here to numbers.

i attached one of those as well.

i want a program that would do it for me and i wont have to copy paste into my main excel

Skills: Excel

See more: how to get into sales, excel special, dollar everything, do it for a dollar, care core, my reports, sort excel, same, sales excel, reports in excel, pivot table excel, excel reports, excel PIVOT, excel pivot table, core value, copy paste names in excel, generate reports excel, sales project report excel, create sales system table, copy paste simple game, txt convert excel, cell names, excel sales monthly report, excel csv tab, excel can open file

About the Employer:
( 1 review ) new york, United States

Project ID: #2642017

Awarded to:


As discussed...

$35 USD in 0 days
(6 Reviews)

2 freelancers are bidding on average $118 for this job


i can do this job

$200 USD in 1 day
(0 Reviews)