Excel macro to summarize data according to a specified format

I have a excel files with data in 11 columns. Each row describes a particular service offered to a client (columns contain client info, product description, delivery date, cost). For a billing summary, we need to aggregate by service category and client. The catch is that the client has provided a sample excel layout which we must copy exactly, so we can't just do a pivot table or move everything over to access or filemaker. What I want is to have a macro in excel that will simply create a new worksheet in the same workbook where I have my data laid out in a table--just do a hotkey and voila. The new worksheet will have the billing summary. I am attaching an [url removed, login to view] format has to be exactly as in the attached, colors and merged cells and everything.

Evner: Excel, Visual Basic

Se mere: summarize data excel macro, cost format, excel macro summarize data, what is macro in excel, summarize, pivot table excel, hotkey, filemaker 14, Excel to Access, excel service, excel PIVOT, excel pivot table, create excel worksheet, according to the, macro pivot, access pivot table, excel access table, pivot table access, excel macro row, sample visual basic excel, move data excel, specified, create workbook, filemaker data, layout worksheet

Om arbejdsgiveren:
( 8 bedømmelser ) United States

Projekt ID: #4053612

Tildelt til:


Looking forward to working with you...

$250 USD in 2 dage
(56 bedømmelser)

5 freelancere byder i gennemsnit $350 på dette job


Consider it done. Check your PM for my bid details.

$250 USD in 2 dage
(51 bedømmelser)

I am an Excel macro expert and can take on the job. Had a look at the output sheet and shall ensure the formatting is intact. Let me know.

$300 USD in 2 dage
(79 bedømmelser)

Top 1% in VBA on Freelancer and lot of experience in this field, please check PM.

$250 USD in 2 dage
(12 bedømmelser)

Dear Sir or Madam, I'm a PhD in large scale data analysis with lots of experience in using Excel. I'm sure I can deliver exactly the layout you need in a short timeframe. Kindly let me know if you need additional info Flere

$700 USD in 2 dage
(0 bedømmelser)