Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2012, 06:06 AM
samkiewhock samkiewhock is offline How to summarise different worksheet to a summary worksheet Windows 7 64bit How to summarise different worksheet to a summary worksheet Office 2007
Novice
How to summarise different worksheet to a summary worksheet
 
Join Date: Sep 2012
Posts: 1
samkiewhock is on a distinguished road
Default How to summarise different worksheet to a summary worksheet

1. I have 10 worksheet
2.All data in column A .
3. I want to pull all data in column A of each individual worksheet to be display in a summary sheet.

4. Means in the summary worksheet :
Column A all data is link to Sheet 1 Column A


Column B all data is link to Sheet 2 Column A
Column C all data is link to Sheet 3 Column A
Column D all data is link to Sheet 4 Column A
......
......
5. I do not need a Macro or VBA but just simple as Excel formula.
Reply With Quote
  #2  
Old 09-06-2012, 03:34 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to summarise different worksheet to a summary worksheet Windows 7 64bit How to summarise different worksheet to a summary worksheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi

in your summary sheet in A1 enter
Code:
=INDIRECT("Sheet"&COLUMN()&"!A"&ROW())
then pull down and across as needed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to summarise different worksheet to a summary worksheet worksheet linking in VB tadleymansions Excel Programming 3 08-18-2012 11:19 PM
How to summarise different worksheet to a summary worksheet "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM
How to summarise different worksheet to a summary worksheet Detatch table from worksheet? MrCrum Excel 2 12-07-2011 12:13 PM
How to summarise different worksheet to a summary worksheet Can I use a formula to name a worksheet? nolesca Excel 3 06-07-2010 04:02 PM
How to summarise different worksheet to a summary worksheet Worksheet copying? markg2 Excel 4 01-07-2010 10:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft