Sedang Disiapkan

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.

Kemahiran: Excel, Visual Basic

Lihat lebih lanjut: 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

Tentang Majikan:
( 8 ulasan ) United States

ID Projek: #4053612

Dianugerahkan kepada:

ZeusMan

Looking forward to working with you...

$250 USD dalam 2 hari
(56 Ulasan)
5.6

5 pekerja bebas membida secara purata $350 untuk pekerjaan ini

Teloquence

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

$250 USD dalam 2 hari
(51 Ulasan)
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 dalam 2 hari
(79 Ulasan)
5.1
adim

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

$250 USD dalam 2 hari
(12 Ulasan)
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 Lagi

$700 USD dalam 2 hari
(0 Ulasan)
0.0