I would like to input formulae in column B after filtering column D with criteria mentioned in screenshot 2. The formulae in column B should be dragged until last visible row. Please advise a best VBA code.
My spreadsheet without filter
Filtered Column D with "LJ"
Need formula in column B until end of the row adjacent to B(drag formulae to Visible cells only)
My spreadsheet without filter
Filtered Column D with "LJ"
Need formula in column B until end of the row adjacent to B(drag formulae to Visible cells only)