| 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! |
| 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 | |||
Threaded Mode
