VBA - Excel - Count cells in Column A - Add rows in separate sheet

[alw99]

Hello all,

I am working on creating a file that has 2 tabs. One sheet = "BIT" and the other "TRS". What I would like to do is, count the number of filled cells in column A (starting at cell A4), then switch over to tab "TRS", and insert that number of rows - 3, starting at row 8. Count of column A in "BIT" can be variable.

Ex. - If there are 6 cells with values from cell A4 and below, in "BIT" , then insert 3 cells in "TRS" starting at row 8

I have attached an example.

Your help is appreciated!

AW

[stnkynts]

Try:

Please Login or Register  to view this content.

[alw99]

Try:

Please Login or Register  to view this content.

Thank you so much for your promp response and solution. I did have to make a tiny modification to the code as it inserted cells, and not rows.

Original line
Sheets("TRS").Range("A8").Resize(lCount - 3).Insert Shift:=xlDown

Modified
Sheets("TRS").Range("8:8").Resize(lCount - 3).Insert Shift:=xlDown

Thanks again,

AW