Combining data

S

surveyorinva

Any help with this would be great (and will save some of my hair from not being pulled out)
I have a workbook with mulitple tabs that seperate data out.
Tab one will have in column A1-Ainfinite a point range (maybe not consecutive) I have Tab 2 will have in column A1-Ainfinite a point range (also maybe not consecutive)
I have a third table that I want to combine the data together.
So
Tab 1 Tab 2 (what I want to achieve) -> Tab 3
A A A
1 2000 1 2002 1 2000
2 2001 2 2003 2 2001
3 2004 3 3 2002
4 4 4 2003
5 5 5 2004

I know that in Tab 3 I want an IF statement, but that is as far as I can get. Any help would be great and very much appreciated!
C. Fillmore
 
F

Frank Kabel

Hi
dou you really need a dynamic solution?. Otherwise simply copy the data
and sort the data
 
S

surveyorinva

If at all possible I would like to make it as automated as possible. If it were just me using the worksheet, that would be simple and would not have all these questions, but I am implementing this to individuals that are not very computer savy....trying to make it as simple as possible for them.
Frank is it possible to do what I am asking?
Thanks for all your help!
 
F

Frank Kabel

Hi
try the following:
1. Download the free Addin MOREFUNC-DLL: http://longre.free.fr/english/
2. Assumptions:
- your data is in column A for all tabs
- it contains only numbers
3. Use the following formula in cell A1 on sheet 3:
=SMALL(THREED('sheet1:sheet2'!$A$1:$A$100),ROW(1:1))
and copy this down
 
Top