Help with code to creat Reset button to clear cells and copy back the original formula

[rv02]

Hi All

I urgently need help with the follwoing:

I have a spreadsheet which lets a user to input values in a range of cells (d10:d100) to see what happens to the overall scores will be depending on the user input.

Currently D10:D100 conatins VLOOKUP formulas which takes the current scores from the sheet. What I need to do is allow users to input what they need in D10:d100 and after they finish looking at various possible scores then they hit on a command button which clears the contents of the d10:d100 and have the original formula (vlookup) copied in the same range i.e. user sees the original scores before any modifications.

I have attcahed a simple spreadsheet to demonstrate what I need to do. in Sheet 2 the vlaues are copied from Sheet1. User can only input data which they wnat in cells C5:C9 to see what score they would have achieved if the Actual Scores were different.

The I want to crate a Command Button to clear the contents of c5:c9 and have the original values (recopy the original formula i.i. the vlookup formulas to obtain the scores from sheet1) back in the cells.

In the actual spreadsheet every other column is locked so user can only change the actual scores in clolumn C.

I really need this urgently before Tuesday and any help is much appreciate it


Any urgent help is apprecaite it.

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[rv02]

This works perfectlty. Is it possible to let the code know to only copy the formula down to the last cell which contains data in B column , i.e. whenever it see total in Column B then only copy the formula upto that point in col c. This is because I have varuois sheets with various column lenghts.

therwise this is brilliant and thank you for your help

[rv02]

ALternativel when I add the following

Please Login or Register  to view this content.

I get the follwoing error
Run Time 1004 Application error or Object Defined Error

Any suggestions?

[YasserKhalil]

Try this

Please Login or Register  to view this content.

[rv02]

Brillaint , it works great.

Thank you so much

[YasserKhalil]

You're welcome. Glad I can help
Thanks for the feedback.
Regards