#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Hi
in your summary sheet in A1 enter Code:
=INDIRECT("Sheet"&COLUMN()&"!A"&ROW())
__________________
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
worksheet linking in VB | tadleymansions | Excel Programming | 3 | 08-18-2012 11:19 PM |
"Auto-populating" data-worksheet to worksheet. | meggenm | Excel | 4 | 02-04-2012 02:04 AM |
Detatch table from worksheet? | MrCrum | Excel | 2 | 12-07-2011 12:13 PM |
Can I use a formula to name a worksheet? | nolesca | Excel | 3 | 06-07-2010 04:02 PM |
Worksheet copying? | markg2 | Excel | 4 | 01-07-2010 10:08 AM |