abstraktus
New Member
- Joined
- Apr 17, 2010
- Messages
- 4
Hi all,
I'm stucked with my project. I need a macro to transfer numeric value to an array depending which one of two checkboxes are checked. Then the value has to be locked to a date and the product, as array is not static (project is based on =TODAY() function, so all arrays are rolling every day). The workbook is attached.
More info about workbook:
Value to be transfered is "No. of batches" (coloured in red). Target array depends on which checkbox is checked on the top left corner. Arrays are in the sheets "U2 BATCHES" and "U3 BATCHES" respectively. Assign macro to the "UPLOAD" button.
It will be the BIG day for me if you guys will help me to solve my problem.
Thanks a ton!
Oooopss! Why doesn't it let me to post attachments?
I'm stucked with my project. I need a macro to transfer numeric value to an array depending which one of two checkboxes are checked. Then the value has to be locked to a date and the product, as array is not static (project is based on =TODAY() function, so all arrays are rolling every day). The workbook is attached.
More info about workbook:
Value to be transfered is "No. of batches" (coloured in red). Target array depends on which checkbox is checked on the top left corner. Arrays are in the sheets "U2 BATCHES" and "U3 BATCHES" respectively. Assign macro to the "UPLOAD" button.
It will be the BIG day for me if you guys will help me to solve my problem.
Thanks a ton!
Oooopss! Why doesn't it let me to post attachments?
