Hi everyone,
I'm currently working on an excel spreadsheet that allows a user to paste pre-generated values in, sorts the values through a macro and then paste a specific column to a new sheet. This new sheet then uses if statements to draw further information. It was working fine, however I need the user to able to use the spreadsheet with any set of data, not just the original data I inputted. I have been trying to use the following statement to read off the original sheet, and judging on the value, output a specific answer:
=IF('Record Entry Number'!$C3=INDIRECT(Transactions!$G3),IF(INDIRECT(Transactions!$J3<0),INDIRECT(Transactions!$J3,0)),"")
However, I am just coming up with #REF! whenever I run the macro. Does anybody know why my formuals are not reading and if so, how to fix them?
Thanks!
GotJ
Bookmarks