Hey all,
Not very familiar with deploying macros, so was hoping for some help here.
I need to create a macro button such that every time I click it, it grabs the first 25 cells (from an already filtered list) in all the existing columns from my source sheet and copies it to a destination sheet. When I click the button again, I need it to repeat the same process for the next 25 cells, so and so forth.
Am attaching a sample file as an example
I need the filtered data from columns a, b and c to be copied from the source sheet to another sheet in batches of 25 every time I execute the macro.
* EDIT *: I want to make sure that the destination sheet retains all the iterations (Of all the 25 cell batches I have pulled from the source sheet)
Thank you so much for you help
A
Not very familiar with deploying macros, so was hoping for some help here.
I need to create a macro button such that every time I click it, it grabs the first 25 cells (from an already filtered list) in all the existing columns from my source sheet and copies it to a destination sheet. When I click the button again, I need it to repeat the same process for the next 25 cells, so and so forth.
Am attaching a sample file as an example
I need the filtered data from columns a, b and c to be copied from the source sheet to another sheet in batches of 25 every time I execute the macro.
* EDIT *: I want to make sure that the destination sheet retains all the iterations (Of all the 25 cell batches I have pulled from the source sheet)
Thank you so much for you help
A
Last edited: