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!!!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!