I am pulling data from one workbook and inputting it into a second, and returning calculations from the seond to the first workbook. I was wondering is it possible to write and If funtion within my sub, so that when a cell I pull from the first workbook goes below a certain value it automatically inputs a certain number
Application.Goto Workbooks("Paul_Nicholson.xlsm").Sheets("Discharging").Range("Q17")
formTemp = Range("Q17").Value 'strings of data from the second workbook
Range("Q17").Select 'puts temp into refprop
Selection.Copy
Application.Goto Workbooks("Refprop.xls").Sheets("Examples").Range("A37")
If(formTemp>=810.77,formTemp,810.77)=Range("A37")
Want something like this however this does not work
Bookmarks