Use Recorded Macro in other Worksheets

[ARamos2]

Hi. I am still fairly new with Macros and VBA, and I’ve come across an issue with a using recorded Macros across different worksheets in a workbook. I have attached an example for reference. I have a filtered table in my “All” ws. My recorded macros takes that data and inputs at the end of the table in “Test2” ws. I then filter the data so it’s in order and ensure it looks like the rest of the table. I want to be able to use the Macro in “test1” and “test3”. My real Workbook has close to 29 different sheets I need to enter data into with a range of different names.

[JLGWhiz]

This is to get you started. It eliminates the specific reference to the active sheet name and just deals with the 'ActiveSheet' constant. However, your 'FillDown' statements need some attention. When you use FillDown, you need to include the complete range refence that you want filled, including the range holding the data to be filled in. i.e. If data is in cell A10 and you want to fill the next 4 cells Then

Please Login or Register  to view this content.

Or you can use the copy method like you did for cell A34.

Please Login or Register  to view this content.

[ARamos2]

Thanks JLGWhiz for the quick response. Unfortunately when testing this code on "Test1", I run into a "Run-time error'438': Object doesn't support this property or method" at " .ListObject.ListRows.Add AlwaysInsert:=False"

[JLGWhiz]

Please Login or Register  to view this content.

Maybe like this. I was not sure what the 'Selection' was in the original code, plus I do not normally work with tables. I am learning as I go here.