Compare 2 worksheets and update one of them
Closed
kurtwm
Posts
1
Registration date
Saturday March 12, 2016
Status
Member
Last seen
March 12, 2016
-
Mar 12, 2016 at 09:23 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 14, 2016 at 12:57 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 14, 2016 at 12:57 PM
Related:
- Compare 2 worksheets and update one of them
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Macro to compare 2 sheets and copy differences ✓ - Excel Forum
- Plants vs zombies 2 pc download - Download - Strategy
- Psp update - Guide
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Mar 14, 2016 at 12:57 PM
Mar 14, 2016 at 12:57 PM
Hi Kurtwm,
To count the number of times you scanned a barcode, you can use the COUNTIF formula.
To compare column D with E and highlight differences, you can use Conditional Formatting.
Copy column D to G is a copy/paste action.
Give it a try and let us know if/where you get stuck.
Best regards,
Trowa
To count the number of times you scanned a barcode, you can use the COUNTIF formula.
To compare column D with E and highlight differences, you can use Conditional Formatting.
Copy column D to G is a copy/paste action.
Give it a try and let us know if/where you get stuck.
Best regards,
Trowa