N
no_rhythm
I have a workbook with a series of worksheets (more than 25). I need to do
the following:
For each worksheet 2 through 'n'
Sort/Filter on column M "Impact" for Impact = Global
Copy all data (about 15 columns) for each row with Impact = Global and paste
rows into Worksheet1 starting with Cell B24 down
So, for the next worksheet (i.e. Worksheet 3), the paste function should
remember the last row written and begin pasting from the next row.
Please let me know how to do this. I have limited knowledge of Macros /
Pivot Tables and Programming using VB
the following:
For each worksheet 2 through 'n'
Sort/Filter on column M "Impact" for Impact = Global
Copy all data (about 15 columns) for each row with Impact = Global and paste
rows into Worksheet1 starting with Cell B24 down
So, for the next worksheet (i.e. Worksheet 3), the paste function should
remember the last row written and begin pasting from the next row.
Please let me know how to do this. I have limited knowledge of Macros /
Pivot Tables and Programming using VB