Macro to copy data from a externalworkbook based on cell data

Registration date
Saturday August 27, 2016
Last seen
August 27, 2016
- Aug 27, 2016 at 07:35 AM
Hi everyone! I'm new here and have a question. I've been away from macros for 10 years and seem to have forgotten most of what I thought I knew. I need a macro to search a external workbook at another location, then look for data (any data type) in cells in a particular column on sheet 1, copy the entire row(s) and paste them into the open workbook that contains the macro, sheet 1. I know this may be asking a lot but any suggestions would be appreciated.