Consolidate sheets
 

Dear All

I am working with XP edition and i want to consolidate two sheets to a
third one.

Both sheets have a first column with code, a second column with a sort code,
a third column with a description and another 12 columns, one for each month.
i want to create a third sheet which will bring all the data from the other
two sheets.
There is any posibility to use a formula, for sort code (column b) in order
to pull all the data to one sheet and at the same time for each sort code to
have all aditional information?

I can bring all the data by using vlookup. But how can i bring all the sort
codes to the third sheet ?

Any good ideas?

Thanks in advance

Would you not just use lookup for that too?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Manos" wrote in message
...
Dear All

I am working with XP edition and i want to consolidate two sheets to a
third one.

Both sheets have a first column with code, a second column with a sort
code,
a third column with a description and another 12 columns, one for each
month.
i want to create a third sheet which will bring all the data from the
other
two sheets.
There is any posibility to use a formula, for sort code (column b) in
order
to pull all the data to one sheet and at the same time for each sort code
to
have all aditional information?

I can bring all the data by using vlookup. But how can i bring all the
sort
codes to the third sheet ?

Any good ideas?

Thanks in advance

I am not sure

I want a function to bring me all the valus from both sheets sortly asceding
and do not have the duplicates Imagine to areas to be matched and bring them
as one.

I am not sure how to use match function and the appropriate ranges

"Bob Phillips" wrote in message
...
Would you not just use lookup for that too?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Manos" wrote in message
...
Dear All

I am working with XP edition and i want to consolidate two sheets to a
third one.

Both sheets have a first column with code, a second column with a sort
code,
a third column with a description and another 12 columns, one for each
month.
i want to create a third sheet which will bring all the data from the
other
two sheets.
There is any posibility to use a formula, for sort code (column b) in
order
to pull all the data to one sheet and at the same time for each sort
code
to
have all aditional information?

I can bring all the data by using vlookup. But how can i bring all the
sort
codes to the third sheet ?

Any good ideas?

Thanks in advance