ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   take all data from several worksheets to one main worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/233474-take-all-data-several-worksheets-one-main-worksheet.html)

Kat

take all data from several worksheets to one main worksheet?
 
Is there a way for me to create a summary sheet from several worksheets to
one main worksheet directory. I have multiple POC list worksheets and need
to have them roll up into one worksheet as they are updated on their tab.
this will help save my team membes from having to enter the data twice. so
that when something changes on one it will automatically update?

Jacob Skaria

take all data from several worksheets to one main worksheet?
 
Refer the below link

http://msdn.microsoft.com/en-us/library/cc793964.aspx

If this post helps click Yes
---------------
Jacob Skaria


"Kat" wrote:

Is there a way for me to create a summary sheet from several worksheets to
one main worksheet directory. I have multiple POC list worksheets and need
to have them roll up into one worksheet as they are updated on their tab.
this will help save my team membes from having to enter the data twice. so
that when something changes on one it will automatically update?



All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com