Custom formula to count rows in columns a find the difference

[catharsis50]

My goal is to insert a dynamic amount of rows to a table. The number of rows I need to insert will be the difference of rows from columnA on sheet1 to the number of rows in columnA on sheet2. I am assuming creating a function within my macro will be the best way to go about this.

I appreciate any help or suggestions on this.

 

[catharsis50]

I figured out a way for it to work in my case, hopefully it will help someone else.

Dim row1 As Long, row2 As Long, rrow2 As Long, diff As Long
row1 = Sheets("Deduped Campaign Data").Cells(Rows.Count, "A").End(xlUp).Row
row2 = Sheets("Dashboard").Cells(Rows.Count, "A").End(xlUp).Row
diff = row1 - row2

Sheets("Dashboard").Select
Range("A2").End(xlDown).Select
ActiveCell.Offset(1, 0).Select
ActiveCell.EntireRow.Resize(diff).Insert