Hello everyone,

I am producing a workbook, where sheet one is the master sheet which includes details of all of our ongoing work on it.

Due to issues we have recently had with people filtering out data and then duplicating it and messing it up, I was looking at creating more worksheets, which organises the data by the store.

So for example, sheet 2 is store 3601. So I have added a formula into the cells in this sheet to copy across data from the main sheet which involves store 3601 (=IF(FIND("3601",Sheet1!A2)<>0,Sheet1!A3,"")

The formula searches the main worksheet for 3601 in the first column, then returns the value from cell a3 and put it in the cell the formula is in. When this is copied across into each cell I get the full row copied across.

The main problem is that I have a lot of #VALUE! cells returned from the rows where 3601 is not present, but the rest of the row on my new sheet is copied across.

Basically is there any way that I can get it to only copy across the relevant data, so I dont get the #VALUE! bits?


Cheers