Previous Topic Next Topic

Summary of two or more excel sheets

Closed
ramesh1974 Posts 5 Registration date Tuesday 26 February 2013 Status Member Last seen 1 March 2013 - 28 Feb 2013 à 04:59
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 - 11 Mar 2013 à 16:35
Hello,

i want to do summary of two or more worksheets in a single worksheet to review the data and anlysis. is there any method to do this.

please help me in this.

thanks

ramesh

5 responses

Réponse 1 / 5
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 69
28 Feb 2013 à 07:43
Hi ramesh1974,

A good way of summarizing your work in different worksheets of a Microsoft Excel Document is to use PivotTable. You can consolidate multiple worksheets into one PivotTable report. Please check the below mentioned link for details on how to do this:

https://support.microsoft.com/en-us/office/consolidate-multiple-worksheets-into-one-pivottable-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5?ocmsassetid=ha010226585&correlationid=7757f519-9c40-4da9-916b-1f12075034b4&ui=en-us&rs=en-us&ad=us

Please revert for clarification.
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
2 Mar 2013 à 11:47
Nice Zohaib. I never knew that Pivot table can go across multiple sheets. Thanks for the tip
Réponse 2 / 5
ramesh1974 Posts 5 Registration date Tuesday 26 February 2013 Status Member Last seen 1 March 2013
1 Mar 2013 à 13:53
Thanks a lot Saab,

I am not software person. I will do sales. To review my sales team, I need summarised data which are in different worksheets.

could you please help me in to do cross-tab format data consolidattion


thanks...
Réponse 3 / 5
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 69
4 Mar 2013 à 13:38
Hi ramesh1974,

A little clarification will help me figure out as to what are your needs. Please reply explaining what is meant by "cross-tab format data consolidation". A gist of what Rows and Columns are present in your sheets and also the format of consolidated report will be helpful.

Please do write back to us.
Réponse 4 / 5
ramesh
8 Mar 2013 à 05:34
hi zohaib,

daily I am tracking with sales executives in 3 parameters like retail sales, chemist sales and launch sales daily. to open the 3 files and review with them, it takes a lot of time and tedious job. I want to see all these in one sheet like the following

ME Name UPL sales chemist sales launch balance

could you please suggest me how to do this type of report to review the sales excutives
Réponse 5 / 5
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 69
11 Mar 2013 à 16:35
Hi ramesh,

You can link the cells or tables in your final report to your three excel files. For step by step instructions on how to do this, please check the below mentioned link:

http://office.microsoft.com/en-in/excel-help/create-a-link-to-another-cell-workbook-or-program-HP005199514.aspx

Please revert for clarification.

Thanks & Regards
Zohaib R
#iworkfordell