compairing worksheets

Hello - I have a code to populate a userform of all the sheets: Private Sub UserForm_Activate() Application.ScreenUpdating = False Dim r, NumShts As Long Dim i As Integer NumShts = ThisWorkbook.Worksheets.count With UserForm2 i = 0 .ListBox2.Clear 'clear all existing list box items...

Hello I would like to compare two sheets. The sheets have item numbers that differentiate the rows. What I want to do is first find if the item number exists on both sheets and if it does compare a quantity, not the item number. If the quantity matches do nothing is it does not match I would...

Hello All, this is my first post, so apologies if I come across noob-ish! What I am trying to do is compare 'Prices' between different 'Providers' for 'Trips' that they all run/operate - Public Transport for instance. The raw data might look something like this if simplified: <tbody> Provider...

So every quarter at my store I get a list of discounts from our vendors. Some items don't change some are changed and new items are added. the vendor has a 4 digit vendor number. What I am looking to do is upload these into 1 excel file the old deals being on sheet 1 and the new list in sheet...