Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking Cells from Multiple Sheets
Hello
I have a workbook with 95 sheets containing information for different customers and I would like to extract information from 3 cells in each sheet to a 96th sheet to use this for a mailmerge document. Basically I want the information in B1 of all the sheets to copy to A2-A96 of the new sheet, i.e. Sheet 1 B1 Baker Sheet 2 B1 Toms Sheet 3 B1 Peters and what I would like on sheet 96 is A2 Baker A3 Toms A4 Peters etc I have tried to use indirect formulae but I cannot get it to work. Please can anyone point me in the right direction. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking cells on between multiple sheets | Excel Discussion (Misc queries) | |||
LINKING MAIN SHEET WITH MULTIPLE SUMMARY SHEETS | New Users to Excel | |||
Linking multiple sheets | Excel Discussion (Misc queries) | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |