EXCEL WORKSHEET

[KDTaylor]

Hello, I need assistance with an excel spreadsheet. I would like to make each cell within a column have a value of 0.5 that is hidden from anyone using the spreadsheet. Once they select/check/enter cells in the column it will automatically give a sum at the bottom of cells. That's the best I can do the

explaining. Thanks for any assistance.

[#2]

@KDTaylor 

Could you explain why you need it like that? there is something not clear.

[#3]

@KDTaylor 

As Mr. ramizassaf has already told you ...


It can help us all if you upload an Excel file (without sensitive data), no picture. So you could get a precise solution much faster. This would also be a blessing for us, as we can understand the problem much better, a win-win situation for everyone.

I can only guess that there is no Excel file (and I'm not good at that). Suspect because the translation of your request sometimes also plays a role.

In your case there could be a lot that might need a macro or a formula, just indicated as an example.

I would therefore be happy to be able to help you if you would provide us with the worksheet (without sensitive data).

Nikolino

I know I don't know anything (Socrates)