UNION VBA
I have 2 worksheets which I would like to UNION on excel but do not know how.
Sheet1: Call Schedule - Contains list of customer which I plan to visit - contains 77 recordds
Sheet2: Call Extract - Contains list of customer calls which have been executed - may be executed with the customers in "Sheet 1: Call Schedule" or could be with new customers which did not exist in call schedule. contains 105 Records
What I am trying to do is to combine the 2 files to show
1) the 105 records in "Call Extract"
2) Customers in "Call Schedule" which have not been executed and hence does not exist on "Call Extract" - created 4 dummy records for this
3) In total the UNION file should have 109 records.
I had this work with an SQL query - by using a LEFT JOIN -- UNION -- RIGHT JOIN
Can I replicate this in excel?
Attachment | Size |
---|---|
MergeTest2.xlsx | 15.07 KB |
Recent comments
5 years 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago