combine/merge 2 worksheet (tabs) into 1 work sheet

L

liberty_adm2

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top