ExcelBanter - Data Lookup - Copy and Paste

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Lookup - Copy and Paste (https://www.excelbanter.com/excel-discussion-misc-queries/449162-data-lookup-copy-paste.html)

ROBERT0803

Data Lookup - Copy and Paste

Need a macro to search Column B for values of (INE,SNE,ENE,WNE) and copy data in column A to another sheet.

Claus Busch

Data Lookup - Copy and Paste

Hi Robert,

Am Thu, 15 Aug 2013 17:15:54 +0100 schrieb ROBERT0803:

Need a macro to search Column B for values of (INE,SNE,ENE,WNE) and copy
data in column A to another sheet.

on which sheet is your table? Are INE,SNE etc. substrings? Which columns
should be copied?

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

All times are GMT +1. The time now is 10:23 PM.