On sheet1, I have a 5 column table whose first cell is B1. I need to copy that table to sheet2 so that I can apply a filter to it. I need to be able to do this without copy/paste as the first table will change from time to time.
On advice from one of the boards, on sheet2 I used =IF(sheet1!B1,C10,"") where C10 is the first cell in the table.
This doesn't work as it returns #VALUE!
Can somebody help me?!?
Thanks in advance.
On advice from one of the boards, on sheet2 I used =IF(sheet1!B1,C10,"") where C10 is the first cell in the table.
This doesn't work as it returns #VALUE!
Can somebody help me?!?
Thanks in advance.