Log In
Register
Home
Dashboards
Power Query
November 6, 2019
Offline
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 ?
See Answer
July 16, 2010
Offline
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
Answers Post
Dashboards
Power Query
November 6, 2019
Offline
Thought as much.was hoping a non VBA way due to organisations that tend to block macro and vba.
July 16, 2010
Offline
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.
1 Guest(s)
