| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move data from multiple tabs into one worksheet
I have a file that has 60 different tabs that shows the vendors UPC, Dollars,
and units for their items. Is there a way to move all of those into one worksheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move data from multiple tabs into one worksheet
Hi,
yes you can, look into Ron web http://www.rondebruin.nl/copy2.htm If this helps please clici yes thanks "Supe" wrote: I have a file that has 60 different tabs that shows the vendors UPC, Dollars, and units for their items. Is there a way to move all of those into one worksheet? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Move data from multiple tabs into one worksheet
Re-post of my reply to your same post of yesterday.
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 Are you not seeing replies? Gord Dibben MS Excel MVP On Wed, 18 Nov 2009 09:10:02 -0800, Supe wrote: I have a file that has 60 different tabs that shows the vendors UPC, Dollars, and units for their items. Is there a way to move all of those into one worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I move multiple tabs in multiple workbooks to a master? | Excel Worksheet Functions | |||
| how to move sheet tabs to the side of the worksheet in excel 2003 | Excel Discussion (Misc queries) | |||
| Move sorted data from one worksheet to multiple worksheets? | Excel Worksheet Functions | |||
| How do I move the worksheet tabs to the top of the workbook? | Excel Discussion (Misc queries) | |||
| move the worksheet tabs in a workbook to left | Excel Discussion (Misc queries) | |||
Linear Mode
