| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move data from mulitple tabs to one sheet
I have about 60 tabs that have the item UPC, dollars, and units for 60
different vendors. Is there a way to move the data from these tabs onto one sheet without copying and pasting from each tab? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move data from mulitple tabs to one sheet
See Ron de Bruin's site to copy data from multiple worksheets within a
single workbook to a single sheet. http://www.rondebruin.nl/copy2.htm See also his add-in for moving data from multiple workbooks in case you ever needed that function. http://www.rondebruin.nl/merge.htm Gord Dibben MS Excel MVP On Tue, 17 Nov 2009 13:12:01 -0800, Supe wrote: I have about 60 tabs that have the item UPC, dollars, and units for 60 different vendors. Is there a way to move the data from these tabs onto one sheet without copying and pasting from each tab? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move data from mulitple tabs to one sheet
Excel 2007
Consolidate Tables on multiple tabs to generate PivotTable. Generic data in no particular order. http://www.mediafire.com/file/jmj2ogyrzet/11_17_09.xlsm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move the sheet tabs | Excel Discussion (Misc queries) | |||
| How to I sum data from one sheet based off mulitple variables? | Excel Worksheet Functions | |||
| how to move sheet tabs to the side of the worksheet in excel 2003 | Excel Discussion (Misc queries) | |||
| can we move the sheet tabs in Excel to the top of window? | Setting up and Configuration of Excel | |||
| Lookup mulitple tabs | Excel Worksheet Functions | |||
Linear Mode
