I want to copy entire row from one sheet to second sheet automatically using a formula/function not VBA when a certain cell in that row is blank. I am attaching the sample file. Sheet 1 is the source sheet and i want the result on sheet 2 (as I mentioned) if J8 & J11 in sheet 1 is blank and so on. if i enter a number in J8 or J11 then in sheet 2 the row sould not appear.
Bookmarks