Copy to filtered blank rows from another spreadsheet
 

Hi,

I have a spreadsheet that it's filtered to show blanks items in column J,
I want to copy into this column J data from another spreadsheet's Column J.
is there an easy way to do? Basically, need to copy from spreadsheet 2
column J
into the filtered blank rows in Spreadsheet 1 column J .

Any help would be greatly appreciated.

Thank you