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.

Hi JackSpam,

You can do this manually and very rapidly.

Select all the coordinate blanks in WB B:

Select the one coord column | F5 | Alt-S | k | ok

With the cells selected enter an apporiate VLookup formula | Ctrl-Enter

Repeat for the 2nd coordinates column.

If necessary, see Excel help on VLookup function.

You can hardcode the results with Copy PasteSpecial Values.

Rather than selecting the blank missing values, you may wish to select all
co-ord values - slightly quicker and you verify current data.

The job will be finished before you know it.

---
Regards,
Norman



"JackSpam" <JackSpam@discussions.microsoft.com> wrote in message
news:784E3ABD-3183-4D62-B885-6FCA6E41749E@microsoft.com...
> 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.

Thank you, thank you. In hind sight it was so simple. I ended up expanding
the vlookup function to integrate 3 columns and still had time for a morning
bike ride before temps hit 100. My boss thanks you too.


"Norman Jones" wrote:

> Hi JackSpam,
>
> You can do this manually and very rapidly.
>
> Select all the coordinate blanks in WB B:
>
> Select the one coord column | F5 | Alt-S | k | ok
>
> With the cells selected enter an apporiate VLookup formula | Ctrl-Enter
>
> Repeat for the 2nd coordinates column.
>
> If necessary, see Excel help on VLookup function.
>
> You can hardcode the results with Copy PasteSpecial Values.
>
> Rather than selecting the blank missing values, you may wish to select all
> co-ord values - slightly quicker and you verify current data.
>
> The job will be finished before you know it.
>
> ---
> Regards,
> Norman
>
>
>
> "JackSpam" <JackSpam@discussions.microsoft.com> wrote in message
> news:784E3ABD-3183-4D62-B885-6FCA6E41749E@microsoft.com...
> > 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.
>
>
>