| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy text from same cell on every sheet to title sheet?
Hi,
hope someone can help on this. What I have is a document which contains 101 separate worksheets. The first sheet is a summary page and there are 100 other sheets which are identical. What I need is for the same cell on each of the 100 sheets to be copied into the summary sheet, but moving down 1 row each time. EG: I want Cell A1 from sheet 1 to appear in cell A1 on the summary page. I want cell A1 from sheet 2 to appear in cell B1 on the summary page. I want cell A1 from sheet 3 to appear in cell C1 on the summary page etc Can excel do this automatically? -- www.unlockingshop.co.uk change 'spam' to 'info' to email Motorola V3 Razr unlocking by post - £15 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
| Find all text instances in a sheet and add one number from each row | Excel Discussion (Misc queries) | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| how to hyperlink text to a cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
