Remove cell value based in another cell

[keithcun]

I am trying to produce a worksheet for keeping track of my cheque and cash income and expenditure for a three month period.

I have entered a maximum of 4 pages on the worksheet and at the end of each page i have 6 cells for the totals of that page.

My problem is if I use more than one page I want to delete these totals on the pages of the previous pages.

I have inserted the following which solves the problem with the first page, (When I input a value in the first cell of the second page (D49 the totals in the previous page (F39,F40,F41,P39,P40,P41) change to N/A)

Please Login or Register  to view this content.

My problem is:- how can I do the same for totals in pages 2 & 3 if my cheque transactions require 2,3,or 4 pages :- ie. enter a value on sheet 3 and 4 (D89 & D127) which will mean totals on page 2 (F79,F80,F81,P79,P80,P81) and page 3 (F119,F120,F121,P119,P120,P121) will change to N/A.

I have very little experience in Vba and would like to know if and how I can amend the above to include the other pages.

I have tried copying the above project replacing with new values and adding them on to the end ( just after End If) but this does not work.

Hope someone can help

[pike]

you could use the worksheet name

for example

Please Login or Register  to view this content.

[keithcun]

many thanks for your swift response pike

Your resolution solves the the problem for cell D49 but not the other cells I wish to change.

I dont think I explained my problem very clearly but basically what I would like to do would be to combine the following three changes in one worksheet as I am led to believe (from other forum messages) that it is only possible to make 1 change to a worksheet:-

Please Login or Register  to view this content.

Thanks Keith

[pike]

It would perhaps be an idea to post a sample of your data - obviously dummy values that are confidential but ensure that your sample is an accurate reflection of what you're working with.