I'd like to build a macro that will take all the information from four
different columns (out of about 10 columns) from workbook A and put them into
workbook B in columns A,B,C,D. I want to do this so if I add new rows of
information into workbook A, I'd be able to run a macro in workbook B and
that information would be there. The link between the workbooks will always
be connected.. Its across a network here at my company, so I don't think any
linking issues should be a problem... Any help would be appretiated.. Thanks!

Rather than a macro you could utilise the "Vlookup"function from worksheet B,
you enter the data that identifies the info to be retreived and within the
lookup formula you identify the data you want transferred to worksheet B.
This has the abilty to retreive data enen after new data has been entered
into worksheet A provided the range specified stretches as far as the data
extends in A.

"ZBelden" wrote:

I'd like to build a macro that will take all the information from four
different columns (out of about 10 columns) from workbook A and put them into
workbook B in columns A,B,C,D. I want to do this so if I add new rows of
information into workbook A, I'd be able to run a macro in workbook B and
that information would be there. The link between the workbooks will always
be connected.. Its across a network here at my company, so I don't think any
linking issues should be a problem... Any help would be appretiated.. Thanks!

I don't know how to use the Vlookup function, do you know the equation I
would use? I've been looking in excel help and the directions read more like
stereo instructions...

"Malcolm McMaster" wrote:

Rather than a macro you could utilise the "Vlookup"function from worksheet B,
you enter the data that identifies the info to be retreived and within the
lookup formula you identify the data you want transferred to worksheet B.
This has the abilty to retreive data enen after new data has been entered
into worksheet A provided the range specified stretches as far as the data
extends in A.

"ZBelden" wrote:

I'd like to build a macro that will take all the information from four
different columns (out of about 10 columns) from workbook A and put them into
workbook B in columns A,B,C,D. I want to do this so if I add new rows of
information into workbook A, I'd be able to run a macro in workbook B and
that information would be there. The link between the workbooks will always
be connected.. Its across a network here at my company, so I don't think any
linking issues should be a problem... Any help would be appretiated.. Thanks!