Hi All
I'm looking for some help with a couple of spreadsheets I have - I know what I want to do, just don't know how to do it!
I have a spreadsheet which is a download from a mainframe this is linked to another spreadsheet using vlookups to pull through the information based on a unique ID - works fine.
What I now need is to copy the values from the middle spreadsheet, which is in one workbook to a new worksheet in another workbook based on a unique identifity. I guess i need something like this but in code, they want to be able to run it from a button on the middle sheet?
VLOOKUP/MATCH Unique ID - if match then
If cell <> then copy cell from middle file, then mark cell A1 * (denotes change) then more to next cell in record then move to the next record all by the touch of a button"
So I thinking something along the lines of a vlookup code then an IF statement looping to next
Any pointers would be great as I'm completely lost on where to start.
Thanks in advance
NJ
I'm looking for some help with a couple of spreadsheets I have - I know what I want to do, just don't know how to do it!
I have a spreadsheet which is a download from a mainframe this is linked to another spreadsheet using vlookups to pull through the information based on a unique ID - works fine.
What I now need is to copy the values from the middle spreadsheet, which is in one workbook to a new worksheet in another workbook based on a unique identifity. I guess i need something like this but in code, they want to be able to run it from a button on the middle sheet?
VLOOKUP/MATCH Unique ID - if match then
If cell <> then copy cell from middle file, then mark cell A1 * (denotes change) then more to next cell in record then move to the next record all by the touch of a button"
So I thinking something along the lines of a vlookup code then an IF statement looping to next
Any pointers would be great as I'm completely lost on where to start.
Thanks in advance
NJ