Hi, is there a way to set a range, ranges or column data (numbers) to blank ready for new data input. I put temp numbers in for testing and wanted to zero them out with a click. On the flip side is it possible to generate data at set values and refill ?
Hi Mike,
You'd need to use a macro/VBA for this. You could try recording a macro and then assigning it to a button. If you get stuck, please post your question in the VBA forum.
Mynda
Thought as much.was hoping a non VBA way due to organisations that tend to block macro and vba.
I suppose you could use an IF formula that populates the cells based on a certain condition. e.g. you could have a check box (see session 5 of the Dashboard course) that the user checks if they want the cells to display blanks, vs a predetermined value, vs their own values. The cells will never actually be empty because they'll contain the IF formula, but you can have the IF formula return blanks.
Check out session 5.02 Check Boxes for a better idea of what I mean.
