Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: header777
  • Content: Threads
  • Order by date
  1. header777

    Comparing fields in two Excel workbooks - #Ref errors

    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...
  2. header777

    Defining Relative Reference in separate Excel worksheet

    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...

Part and Inventory Search

Back
Top