(Solved) – How to copy a range of cells in a single row to a range of cells spanning over many rows in the next worksheet in Excel using macros?

(solved)-–-how-to-copy-a-range-of-cells-in-a-single-row-to-a-range-of-cells-spanning-over-many-rows-in-the-next-worksheet-in-excel-using-macros?

I have a few formulas typed into 4 different cells in a same row in my 1st worksheet(WS.). I want to copy these formulas to the next (2nd WS.) after filtering the data to a specific type. I also want to extend these formulas to the last row with data in the column to its left. I want to repeat this over 25 worksheets in the same Excel Workbook.
I tried recording macros. In my first try, it did not paste on the sheet it was used on (3rd WS.). Instead it filtered the data and then pasted it on the 2nd WS.
In my second try at recording the macro, it did paste on the sheet the macro was used on(3rd WS.), but it did not paste till the last row with data in the column to its left.
Please help.

Leave a Reply

Your email address will not be published. Required fields are marked *