View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JackSpam JackSpam is offline
external usenet poster
 
Posts: 2
Default Selecting data from 1 workbook to copy and paste to a 2nd workbook

I'm not sure if this will require VB or not as I've only done very basic
macro recording before.
I have 2 workbooks where the first 3 columns of each row (after a title row)
consist of an ID number, a North coordinate and an East Coordinate. Workbook
A is complete in that every ID for our system is included along with the
coresponding North and East coords.
Workbook B includes a subset of the IDs and only some of the IDs have their
coords in columns B and C. How do I import the coords into Workbook B
without having to copy/paste a thousand or more times. Thanks in advance for
any help.