Hi,
I know how to set up a command button (the easy bit) my problem is:
I have a row of cells which have information inside them, all of which I would like the formatting to remain the same and in one instance the numbers to reset to 0%.
So basically I want to clear cells A1, B1, C1, D1, E1 (to litteraly be blank) and have cells F1, G1, H1 to reset to 0% from what ever value was in them previously. The only problem may, or may no be, is that cells C1 and D1 are filled with Yes or No depending on the answer from a drop box.
Any help would be appreciated
I know how to set up a command button (the easy bit) my problem is:
I have a row of cells which have information inside them, all of which I would like the formatting to remain the same and in one instance the numbers to reset to 0%.
So basically I want to clear cells A1, B1, C1, D1, E1 (to litteraly be blank) and have cells F1, G1, H1 to reset to 0% from what ever value was in them previously. The only problem may, or may no be, is that cells C1 and D1 are filled with Yes or No depending on the answer from a drop box.
Any help would be appreciated