compare 2 worksheets

Good morning, I have two excel workbooks formatted exactly the same. Is there a way that I can compare the two documents and highlight the cells with changes throughout the entire workbook?

Hello Everyone, I am very to new to VBA and have run into some difficulties early on. Currently I have a tabs "IDB_CapEx", "IDB_OpEx", and "RCM". The RCM contains a variable number of columns with the row information as follows: Row 2: Project Name Row 3: Project Number Row 4: Project Manager...

I'm not an excel power user by any means, so i'm having trouble getting a column in one worksheet to compare against the same column in another worksheet. I have two different worksheets in the same workbook each sheet contains a different data with the exception of one column. The columns...

Typically by the time I come to the forums I can ask you specifically "how to", however I don't know where to begin because I'm not familar with Vlookup I have 2 spreadsheets 1. is a list of EE's who took the test either, failed, passed, or incomplete 2. is a list of ALL employees who SHOULD...

Hello all, I have two worksheets in the same workbook. The first worksheet contains last periods score matrix, the second worksheet contains this periods score matrix. I am struggling to find a away to highlight those cells in this periods worksheet that are different from last periods...

Hi guys, I needed some help in updating a VBA code for carrying out the task mentioned above. The only issue I have is how the info. is represented in the exceptions sheet. I want to show only the data labels that have changed and also lists before and after. Also it would be helpful if the...

Hi. I'm having a problem that I need help with. Here it is. I have two columns of data. Each contains a 1 to 3 digit code. I need to compare column A to column B and if a code in A = a code in B, I need the entire row that intersects the cell in column A to be removed. Let me give the...

Hi, I have data on two sheets. The first column of both sheets has a product reference. The data has not been sorted by this reference but can be if needed. Sheet2 has 14,000 rows and a column with a remark "x" that I want to display in sheet1 if the product reference matches. I've tried...

Hi all I've two excel sheets in one work book, Sheet 1 contains A - S No B - Mandal Name C - DISE Code (Numbers are stored in this column) D - Name of the School E - Account No (This column is empty, we need to fill this column by the formula) Sheet 2 contains A - S No B - Mandal Name C -...

Hi Folks, Apologies is this is the wrong forum for this type of question. Moving fast to a deadline and am in random orbit. Not an Excel guru, not even a novice. Just get thrust into it as the occassion requires. I have the need to compare two spreadsheets for a matching string. I am...

Need help! I have two tables with 5 columns each. The first two columns in both tables contain ID#s and Names. The third column contain job titles in both tables. Table 2 has many more records that table1 - in other words table 1 is a subset of table 2. I want to compare these titles in the two...

I'm in desperate need of help for a formula in xls that can do the following. Suppose I have two price lists containing part numbers (column A) and prices (column B). Price list X and Price list Y. Price list X has say 500 rows (part numbers which may be repeated) and prices for each part...

Hello All, I have spent a few days looking around the internet for an answer to my question, but no luck. I am trying to compare sheet 'Base_Mach' to 'Comp_Mach' and create a new sheet with the results. I have found threads on how to do this, but there is another twist to what I am trying to...

Hi, I want to look at our shop vs website sales and see if we have any products that sell in store and not online. I've seperated the sales into two different sheets (one shop, one web) with the same format as pasted below. Can I use a formula to compare the volume of products that appear in...

Hi, This works but can anyone think of a way to make it faster? It needs to look through over 15,000 rows. Set Sh_1 = ActiveWorkbook.Sheets("NFC Allocations") Set Sh_2 = ActiveWorkbook.Sheets("RSL") For r = 2 To Sh_1.UsedRange.Rows.Count For s = 2 To...

Hi, I would like to look at ID numbers in two worksheets, (sheet1 and sheet2) and if the number (in column A) occurs in both, to put a marker on one of them, called lets say (INDV). I have tried a couple of ways, but I am making a mistake somewhere. Any advice? Daniel

i have to compare election results for same consituancy area for different elections held,which means i have to compare for each polling booth.i have my data in different sheets like this <table width="1236" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:101pt" span="2"...

Hello, I am working on this spreadsheet for a while and can't get it working...any help is appreciated On the first worksheet "transactions" a row contains a financial transaction. With another macro new transactions are imported when available in another file. For a new transaction on a row...

Hi, I have two spreadsheets. The spreadsheets have the same information, the only difference is that one spreadsheet contains "previous months" records, while the other contains "new months" records. I am attempting to find only the new entries in the "new months" records. There are 11...

I've searched the various posts and can't find anything similar or close. If there is, I apologize for this post. I have to compare each week's employee listing to the previous week. In the comparison, I have to find any employee that has dropped off the sheet, new to the sheet and on top of...