I have two workbooks that reference one another in which the cells are equal to each other.
These are the workbook names:
Baseline.xls
Database.xls
If I use the filter on the Baseline workbook, it still automatically fills the Database workbook with all of the cells. I would like for the Database workbook to only grab the visible cells from the Baseline workbook when I filter the Baseline. Is this possible?
Here is the code I am working with:
Sub FillDate()
Windows("Baseline.xls").Activate
Dim Rng As Long, Rng1 As Range
Rng = Sheets("Current").Range("BJ" & Rows.Count).End(xlUp).Row
Windows("Database.xls").Activate
Range("A4").FormulaR1C1 = "='[Baseline.xls]Current'!R[7]C[61]"
With Sheets("Replacement")
.Range("A4:A" & Rng).FillDown
End With
End Sub
Bookmarks