Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Problem
Hi Folks,
I have a bunch of data in columns D & E on a sheet named "Compare". Column D is full of VLOOKUP formulas some of which result in a #N/A error. I would like to copy and paste the contents columns D & E for any row where column D's formula results in #N/A. My list runs from row 6 to row 300 and I only want to return the offending #N/A rows and paste their contents from columns D & E to columns A & B on a sheet named "Results". Can this be done in a macro? Thanks in Advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with copy and paste | Excel Discussion (Misc queries) | |||
Copy Paste problem | Excel Discussion (Misc queries) | |||
copy paste problem? | Excel Discussion (Misc queries) | |||
VBA Copy Paste Problem | Excel Programming | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |