dropkickweasel
Board Regular
- Joined
- Feb 2, 2014
- Messages
- 70
Hi,
I hope this is a quick fix for someone with any level of VBA experience.
I have a macro that outputs the active cell reference to cell AM8.
I have formulae that populate a 5x5 grid in cells AY2:BC6 with printed cell references based on the active cell information from cell AM8.
I have another 5x5 grid in cells AS2:AW6 with 0s and 1s.
What I want to have a macro assigned to a button that when clicked would take the 0s and 1s from the cells and AS2:AW6 and populate the target cells referenced in cells AY2:BC6.
A single cell example:
AS2 has "1" in it. AS3 has "0" in it.
AY2 has "$B$2" in it. AY3 has "$B$3" in it.
When I click the button, the macro writes a 1 into cell B2 and a 0 into cell B3.
Thank you in advance to anyone who can help with this.
I hope this is a quick fix for someone with any level of VBA experience.
I have a macro that outputs the active cell reference to cell AM8.
I have formulae that populate a 5x5 grid in cells AY2:BC6 with printed cell references based on the active cell information from cell AM8.
I have another 5x5 grid in cells AS2:AW6 with 0s and 1s.
What I want to have a macro assigned to a button that when clicked would take the 0s and 1s from the cells and AS2:AW6 and populate the target cells referenced in cells AY2:BC6.
A single cell example:
AS2 has "1" in it. AS3 has "0" in it.
AY2 has "$B$2" in it. AY3 has "$B$3" in it.
When I click the button, the macro writes a 1 into cell B2 and a 0 into cell B3.
Thank you in advance to anyone who can help with this.