| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you copy items from many worksheets to one?
I have over 100 worksheets in an excel file I am working with. It is a
database of people profiles for alumni of my fraternity. Each worksheet has the exact same formatting with the same type of information in corresponding cells (i.e. B2 contains the person's name in each sheet). I'm trying to set up a master sheet I can use as a database for mail merges in word. Is there anyway I can copy the information to one sheet without going into each sheet individually and copying and pasting? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheets from one Workbook to Another | Excel Worksheet Functions | |||
| Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
| How do I copy a worksheet's print parameters to other worksheets? | Excel Worksheet Functions | |||
| Run a macro to copy selective items | Excel Discussion (Misc queries) | |||
| how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) | |||
Threaded Mode
