Thread: Comparing Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tanya Tanya is offline
external usenet poster
 
Posts: 155
Default Comparing Data

Henriques,
select any cell in the range you want to sort and then go to the menu bar -
From the menu bar select 'Data' then 'Sort'

Then:
From the sort dialogue box, under 'My data range..' make a selection from
with/without header row.

cheers
Tanya


"henriques" wrote:

I have data for 2 different months.
I need a formula or macro that creates a column with all data included in
both months sorted by column A.
See example

A B C D E F
Jan Feb. All
code value code value code value
a1 3 a1 5 a1 5
a2 5 a3 12 a2 5
a3 9 a4 6 a3 12
a5 2 a7 2 a4 6
a6 3 a8 10 a5 2
a8 6 a6 3
a7 2
a8 10

How to manage this
Thanks a lot
António