Move data from mulitple tabs to one sheet

  • Follow


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? 
0
Reply Utf 11/17/2009 9:12:01 PM

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 <Supe@discussions.microsoft.com>
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? 

0
Reply Gord 11/17/2009 10:04:25 PM


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
0
Reply Herbert 11/17/2009 10:33:55 PM

2 Replies
498 Views

(page loaded in 0.052 seconds)

Similiar Articles:
















7/20/2012 4:32:16 PM


Reply: