Recent content by header777

Not sure why it's not allowing me to add 2 stars - but you truly do deserve it.

Thanks Bob! Sorry for the delay in responding. You left out two minor items which really made me work thru this code example (and hence fully understand it - sincere thanks). It needed ".Row" after the intLastRow definition and was missing a paranethesis after isempty clause. This works...

That is certainly more than fair. file1.columnT has the following formula: if file2.columnA has data in it continue, else "Data n/a" if file1.columnA = file2.columnB continue, else "Different Reviewer" if file1.columnN = file2.columnE "OK", else display the valude of file2.columnE this...

thanks for the quick response and alternative suggestion bong - however I am not sure how to implement this. What I am trying to do is 1st check for data in file2 (cell 1), then compare names (cell 2) and if both those hold true then i compare a 3rd set of cells to ensure a match. This formula...

Using Excel 2003, I am trying to record a macro in file1 that will compare the values in a certain cell with the values in a cell in another workbook (file2). I want the user to be prompted to select the file to compare. The following code will prompt for a file but then the subsequent formula...

Thanks John (anotherhiggins)! That did the trick and will be very useful in future macros. Just curious - why is it unadviseable to use selection and activate?

thanks for the quick reply bong. unfortunately - it doesn't change anything. all columns in sheet1 are still referencing R4C5 (cell $E$4) instead of incrementing the row number.

I am using MS Office Excel 2003. I want to compare the values in sheet1.cell N4 with sheet2.cell E4 using an if function in sheet1. I then want to autofill the remaining rows with the formula. I am able to do this but as the formula is carried down sheet1 in continues to reference sheet2.E4...