sort two columns, one from each of two sheets

MrDB4Excel

Board Regular
Joined
Jan 29, 2004
Messages
81
I have looked and do not find a solution to acquire one column's data, insert it into a new sheet. Then acquire another column's data from a different sheet and enter that into the same column that the first column's data was inserted. This way the data from two columns, each from a different sheet, is pasted into a separate sheet in one column thus allowing data sort on all in one column. Somehow I suspect tables and pivot tables is the answer. Any suggestions would be greatly appreciated.
The following diagram may help.

1st Sheet 2nd Sheet
Column A Column A

3rd Sheet
Column includes all entries from Sheet 1, Col A & Sheet 2, Col A

I should mention I actually need several columns to sort pas follows:
First sheet:
51 > 19FdO-1 Wed 02/Oct/2019 @ 20:10
54 > 19FdO-2 Thu 03/Oct/2019 @ 09:16
57 > 19FdO-3 Fri 04/Oct/2019 @ 06:44
Second sheet:
52 > 19TdO-1 Wed 02/Oct/2019 @ 16:01
53 > 19TdO-2 Wed 02/Oct/2019 @ 22:46
55 > 19TdO-3 Thu 03/Oct/2019 @ 11:34

In addition I actually have 6 sheets with a total of 98 entries (rows) across all six sheets that all need to be sorted.
In case you may ask; I need to do this to check the date & time in chronological order against the numbered column, in this case what you see here designated by 51, 54, 57, 52, 53, & 55.
 
Last edited:

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Just turn on your macro recorder ... and go once through your process ...

You will get a good starting point ...

Hope this will help
 

MrDB4Excel

Board Regular
Joined
Jan 29, 2004
Messages
81
Just turn on your macro recorder ... and go once through your process ...

You will get a good starting point ...

Hope this will help
Sorry, but this is above my pay grade. Process? What process?
I do not even know where to begin.
 

Forum statistics

Threads
1,085,311
Messages
5,382,897
Members
401,808
Latest member
huyennhiteen9xx

Some videos you may like

This Week's Hot Topics

Top