differences compare

Hi, I have the below drug list shared by insurance companies each Monday, this list always varies with multiple fields such as drugs added/removed, drugs shifted to tier 2 from tier 3 or vise versa, unit price increase.. and all the the fields. example February 21 sheet lets call it sheet 1...

Hello folks, I am not an expert at excel, so not sure how to resolve this issue. I have two excel worksheets: File 1: Subset: This file has a subset of employees with various details including training status such as in-progress, completed, etc. File 2: Full-Pop: This file has a complete...

Hi guys this is my first post in this forum and I am new to macros, so please any feed back would help a lot :) I have a couple questions trying to program this, but let me ask them one at a time now. First, I am trying to do a file comparison macros on excel and highlight differences, however...

This feels like a "Track changes" sort of situation, but I can't nail down which way to go here (MATCH, VLOOKUP, etc.). I essentially have four columns of data: > Workbook 1 - an item reference number - a detail amount > Workbook 2 - an item reference number - a detail amount We looked at the...

<TBODY> I have hundreds of data points, I manually go through each week from testing and type it in correctly. It may be an easy fix but I have gone way too deep in the rabbit hole on this one. I have totally confused myself. It looked easy at first. Is B6 more negative than A6 and by how...

Hey all, I'm new to the forums here, but I'm trying hard to get a project done and can't quite figure out how to do this macro... Problem: I have two excel workbooks. I want to write a macro that, once clicked, asks me which workbooks I would like to compare. Then, the macro compares column A...