Hi all
Wonder if someone more clued up with Excel can help me please?
I've got a spreadsheet that has 2 worksheets (Requests and Quantity). In the Quantity sheet, I've got the following formula in cell d12
=C12-Requests!C11
This takes a stock level figure from c12 and minuses it from cell c11 in the Requests tab. Then in cell e12, I've got the following:
=D12-Requests!D11
This then runs on for a few more rows. Is there a way in the Requests tab, I can get the cells c12, d12 and so on to be blank and not show the result from the previous cell?
Many thanks
Bookmarks