I have form with check boxes - it's current area. I fill the form and I want to save the values (let's say it is A1:P50) to store!A1:P:50 the same workbook - storage area.
Is it possible to use target addressing in the cell?
I see this like that:
1. I fill the form, it is the ticking check boxes and automated change of values in the area current!A1:P50
2. write address in the cell current!R1. The address is store!A1:P:50 at this time
3. execute a macro. Macro makes copy values from current!A1:P50 to store!A1:P:50 using value of current!R1 as target address.
How to use cell value in the macro?
Bookmarks