Ok heres the situation. I have 2 spreadsheets open with an amount column in one and the same in the other. I need to run a program to match the amount in one column to the other. As well as making sure the ID is LIKE the ID in the otehr spreadsheet (in case of typos etc) If they do match, I would need to change another cell to a value. I have an idea of what kind of code to write, I just don't know how to get started using VBA