Compare 2 Spreadsheets and Highlight. Please Help! URGENT

C

CherryxDarling

New Member
Joined
Mar 30, 2011
Messages
39
Ok so I have 2 spreadsheets:
  • RFP-R11(1)
  • RFP-R11(2)
The first one was my original spreadsheet and the second is the customers. The two are pretty much the same but they have made some changes. It's a very big spreadsheet and I would like to see what changes were made. How can I make it so that it will highlight the differences between the two spreadsheets?

*Please do step-by-step instructions if using VBA and macros because I am very new to macros. I've tried using codes that other people have posted and I just don't know how to enter the codes. Well, I know that you right click on the tab and click on "VIEW CODE" and then you can paste the code in there, but that's about as far as I've gotten. I don't know if you have to just click X or save or :confused: I just don't know!
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Add a third worksheet and use this formula in cell A1.

Code: 
=IF('RFP-R11(1)'!A1='RFP-R11(2)'!A1,"","Changed")

Copy the formula down and over to cover the appropriate range.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Comparing 2 worksheets with different rows with conditions
Replies
9
Views
357
Country_Calc_2
C
J
  • Solved
Calculate sums based on values
Replies
3
Views
253
NateSC
NateSC
L
  • Solved
Lookup and retrieve value based on table code (2)
Replies
3
Views
387
Peter_SSs
Peter_SSs
M
  • Question Question
Excel Debugger Extremely Slow
2
Replies
13
Views
385
missingsc
M
T
  • Question Question
HELP, PLEASE?!
2
Replies
12
Views
378
Anthony47
A

Forum statistics

Threads
1,223,236
Messages
6,170,917
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top