I gang

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.

Færdigheder: Excel, Visual Basic

Se mere: summarize data excel macro, cost format, excel macro summarize data, summarize, pivot table excel, hotkey, filemaker 14, excel service, excel pivot, excel pivot table, create excel worksheet, 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, excel macro pivot table, simply data excel, format provided

Om arbejdsgiveren:
( 8 bedømmelser ) United States

Projekt-ID: #4053612

Tildelt til:

ZeusMan

Looking forward to working with you...

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

5 freelancere byder i gennemsnit $350 for dette job

Teloquence

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

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

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)
5.1
adim

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

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

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 Mere

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