Custom Made Reporting

R

ramakrishnan_1731

Board Regular
Joined
Jun 11, 2007
Messages
73
Dear Experts.

I am using a report format on a daily basis. IT is having group total of rows, group total of colums etc. There will be a data dump which i receive and i make pivot out of it then plot the same into the stantard report format.

My question : Is there any way by which in a template is made for the report in the required format and linked with PIVOT table so that when ever data is changed automatically the report will update.

I dont know macro & VB so request to help me with any inbuilt wizard in excel or with any external addin / report template available.

Thanks in advance
R.Ramakrishnan
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
You must log in or register to reply here.

Similar threads

B
  • Question
VBA to create dashboard report for multiple employees from template
Replies
0
Views
2K
BillGinSC
B
H
  • Question
Not even sure what I need here.
Replies
2
Views
652
hmlitke
H
H
  • Locked
  • Question
Not even sure what I need here - trying again.
Replies
1
Views
535
Fluff
Fluff
B
  • Question
Report Inventory needs to support customer order with flow through assembly tree when in excess of parent part stock available.
Replies
0
Views
668
bjuntz
B
S
  • Question
Want to create Monthly Performance Report of my department
Replies
1
Views
251
oldbrewer
O

Forum statistics

Threads
1,215,035
Messages
6,122,791
Members
449,095
Latest member
m_smith_solihull

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top