Summary of two or more excel sheets
Closed
ramesh1974
Zohaib R
- Posts
- 6
- Registration date
- Tuesday February 26, 2013
- Status
- Member
- Last seen
- March 1, 2013
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- Summary of two or more excel sheets
- How to screenshot excel sheet - Guide
- How to copy data from one excel sheet to another - Guide
- How to change language in excel sheet shortcut key - Guide
- Macro to compare two excel sheets ✓ - Forum - Excel
- Unit conversion excel sheet free download - Download
5 replies
Zohaib R
Feb 28, 2013 at 07:43 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Feb 28, 2013 at 07:43 AM
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.
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.
ramesh1974
Mar 1, 2013 at 01:53 PM
- Posts
- 6
- Registration date
- Tuesday February 26, 2013
- Status
- Member
- Last seen
- March 1, 2013
Mar 1, 2013 at 01:53 PM
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...
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...
Zohaib R
Mar 4, 2013 at 01:38 PM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Mar 4, 2013 at 01:38 PM
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.
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.
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
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
Didn't find the answer you are looking for?
Ask a question
Zohaib R
Mar 11, 2013 at 04:35 PM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Mar 11, 2013 at 04:35 PM
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
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
Mar 2, 2013 at 11:47 AM