Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine/merge 2 worksheet (tabs) into 1 work sheet
Hi, after reading countless forum discussions, i am still very confused for
something that should be fairly simple! i have a workbook file with several work sheets (tab) that have data comparing two year revenue income. And now we need to compare them side by side vertically. I tried consolidation but it doesn't work. VB is too hard. I can't imagine doing cut and paste for 40 tabs. worksheet (tab1) shows year, number and ratio 2010 $8,782 811% 2009 $964 worksheet (tab2) shows 2010 $3,425 -33% 2008 $5,112 what i would like to see is 2010 $8,782 811% 2009 $964 2010 $3,425 -33% 2008 $5,112 Any feedback is greatly appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine/merge 2 worksheet (tabs) into 1 work sheet
Check out the topic 'Copy from row 2 till the last row with data' at the
below link by Ron de Bruin http://www.rondebruin.nl/copy2.htm -- Jacob "liberty_adm2" wrote: Hi, after reading countless forum discussions, i am still very confused for something that should be fairly simple! i have a workbook file with several work sheets (tab) that have data comparing two year revenue income. And now we need to compare them side by side vertically. I tried consolidation but it doesn't work. VB is too hard. I can't imagine doing cut and paste for 40 tabs. worksheet (tab1) shows year, number and ratio 2010 $8,782 811% 2009 $964 worksheet (tab2) shows 2010 $3,425 -33% 2008 $5,112 what i would like to see is 2010 $8,782 811% 2009 $964 2010 $3,425 -33% 2008 $5,112 Any feedback is greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple work sheet merge | Excel Discussion (Misc queries) | |||
no sheet tabs on work sheets | Excel Discussion (Misc queries) | |||
How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS | Excel Worksheet Functions | |||
Mail merge with specific work sheet | Excel Discussion (Misc queries) | |||
How do I work with the "dialogs" I can insert as worksheet tabs? | Excel Worksheet Functions |