Hi,
first - I have names in A column and dates in B column
from A5:B10
second - names in D column and dates in E column
from D5:E30
I can sort them independently and then copy upper of the second to the bottom of the first
but I need to sort them as one, upper values of second columns to be
appended on empty rows on A5:B10 (if any) and rest to be sorted in D5:E30
Need them sorted by dates
B5:B10
and
E5:E30
is there a way to do this?
first - I have names in A column and dates in B column
from A5:B10
second - names in D column and dates in E column
from D5:E30
I can sort them independently and then copy upper of the second to the bottom of the first
but I need to sort them as one, upper values of second columns to be
appended on empty rows on A5:B10 (if any) and rest to be sorted in D5:E30
Need them sorted by dates
B5:B10
and
E5:E30
is there a way to do this?