View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt
 
Posts: n/a
Default Merge and sort pages of data

Tell us what you've done and where you are stuck. Give some specific
examples of what is in the cells if possible.

"RD Wirr" wrote in message
...
I have an earlier post on this but no solution and trying again.
I have two pages with tables of data with column headings of dates I need
to
merge the data from these two pages into a third page in the chronological
order of the date headings and carry along the columns of data below the
date
headings. It would be a simple thing to just copy and paste but there is a
lot of back and forth date adjusting necessary so I need to have this
third
page update live when I make changes to the dates on the first two pages.
I
suppose I can use an HLOOKUP to carry the columns of data under the date
headings but my problem is finding a way to merge and order the date
headings
off the two pages. Anyone have an idea how to do this?
Thanks
RD Wirr