mklindquist0815
Board Regular
- Joined
- Jul 5, 2015
- Messages
- 63
I'm wondering if anyone has VBA to compare data within two worksheets and then output the row with the difference to a new sheet. Also I would like the headers to go to the new worksheet.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Compare two worksheets and send the row that contain the difference to a new sheet
- Thread starter mklindquist0815
- Start date
-
- Tags
- compare difference row sheet worksheets
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,540
- Office Version
- 365
- Platform
- Windows
Re: Comparison of two sheets
@mklindquist0815
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules (rule 12 here: Forum Rules)
@mklindquist0815
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules (rule 12 here: Forum Rules)
Upvote
0
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Similar threads
- Question
- Question
- Question
