I have one spreadsheet that is pulling data using a vlookup. If the data is not available, it results as #N/A. I am attempting to have the information from the spreadsheet mentioned above pulled into a new spreadsheet that will delete the lines if they return "N/A" in the original spreadsheet. Any ideas?
For example,
Cells with values
A1
A2
A3
A8
A9
A10
A11
Cells returning "#N/A"
A4
A5
A6
A7
A12
A13
I need to have the following information displayed in the new worksheet
A1
A2
A3
Empty row
A8
A9
A10
A11
Bookmarks