I am having three sheets in one excel file. what i need to get the output as,
From the first sheet i'm having 3 checkboxes, When i check the fist checkbox it need to copy the first 25 rows from the sheet2 and paste it into sheet3 with the same alignment. When i unchecked the checkbox the third sheet should be empty.
When i check the 2nd checkbox it needs to copy next 10 rows from sheet2 and paste it into sheet3. The same unchecked function should work here like checkbox1.
When i check the both (checkbox1 & 2) it should populate mixed row values with order on sheet3.
Kindly suggest me to achieve this criteria in excel using VBA or Macro and other functions.
Thanks in Advance!!!
Can you attach an example workbook
Here i attached the Sample document!
Not sure if this is what you are trying to do, I have moved the checkboxes to sheet 3 to make it easier to see what happens but you can move them back. The macros are in module 1
Thanks for your Help!!!