Macro code for Paste Special Value

Hey everyone,

Really looking for some help. I need the value in C5 to be copied over to another tab and have a paste special value for that cell hard code the # in. I have the code / formulas in the macro to bring the value over, but I'm having difficultyconfused identifying the code that hard codes that # in and allows me to answer the remaining questions. I attached the spreadsheet I;m currently working with. In the end all the cells C2:F32 on the Scoring tab should be filled in with a # 1-5

It is not clear what you are looking for, but if you want to copy values only

Please Login or Register  to view this content.

Thanks for the response.

The code does a good job at bringing over the value, but when you go back to the 1rst tab and select another question and then hit the Log Data Object it only logs the 2nd question, and the score to the 1rst question is no longer there. In the event cells C2:F32 should be completely filled.

I want to find a way that when you click the Log Data Object it keeps the score (paste special value) as you answer the other questions. Cell C3 on the 1rst tab contains a drop down list that would include 32 different questions to respond to.

Maybe this might help clarify...

As part of this code what can I add so it only copy's and paste the formula ONLY if the cell is empty. If the cell has a # (1-5) leave as is.

Sheets("Scoring (2)").Range("C2:F32").Copy