plucking data from one workbook to another
 

Hello all,

I'm creating a new workbook based on data from an old workbook.
OR i can create a new worksheet in the same workbook. I need some help with
VB programming as I'm not great at it.... I can understand code but always
have trouble starting it up.

Here is the problem specification:

I have a workbook with about 1200 entries. Data starts from Row 3 in both
this spreadsheet and the new one I am going to create (the first two rows are
title and column headings). In column L, there is a "Component Part
number". Component numbers may be repeated many times. I want to filter
for each component number and then do the following:

- Copy the data entry from Workbook1 Row3 Column L and paste it into
Workbook 2 Row X (initially 3, but keeps going down a row after each filter)
Column B.
- For the same filtered component in Workbook1, copy the data entry from row
3 column P into workbook2, Row3 (initially 3, but keeps going down a row
after each filter) , column D.
- Also in the same filtered component, copy from Workbook1, row 1201, column
S (this is a sum-count of all the components)... into row 3 (initially 3, but
keeps going down a row after each filter) , column C.

and finally... Extract from workbook1 Row 3, column J and column F... and
paste the following into Workbook2, row3 (initially 3, but keeps going down a
row after each filter), column E. What should be pasted here is << column J
+ " for " + column F + " Valve".

Basically I want it to keep doing down the list of components so taht each
unique component is captured in the new workbook under their own row.

I hope my description is accurate...

It would save me a lot of time to have a program than to go through each
entry manually.. Any help on this would be greatly appreciated.

Terrel

plucking data from one workbook to another
 

Hi LoboNetwork

Start with this
http://www.rondebruin.nl/copy5.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"LoboNetwork" wrote in message ...
Hello all,

I'm creating a new workbook based on data from an old workbook.
OR i can create a new worksheet in the same workbook. I need some help with
VB programming as I'm not great at it.... I can understand code but always
have trouble starting it up.

Here is the problem specification:

I have a workbook with about 1200 entries. Data starts from Row 3 in both
this spreadsheet and the new one I am going to create (the first two rows are
title and column headings). In column L, there is a "Component Part
number". Component numbers may be repeated many times. I want to filter
for each component number and then do the following:

- Copy the data entry from Workbook1 Row3 Column L and paste it into
Workbook 2 Row X (initially 3, but keeps going down a row after each filter)
Column B.
- For the same filtered component in Workbook1, copy the data entry from row
3 column P into workbook2, Row3 (initially 3, but keeps going down a row
after each filter) , column D.
- Also in the same filtered component, copy from Workbook1, row 1201, column
S (this is a sum-count of all the components)... into row 3 (initially 3, but
keeps going down a row after each filter) , column C.

and finally... Extract from workbook1 Row 3, column J and column F... and
paste the following into Workbook2, row3 (initially 3, but keeps going down a
row after each filter), column E. What should be pasted here is << column J
+ " for " + column F + " Valve".

Basically I want it to keep doing down the list of components so taht each
unique component is captured in the new workbook under their own row.

I hope my description is accurate...

It would save me a lot of time to have a program than to go through each
entry manually.. Any help on this would be greatly appreciated.

Terrel

plucking data from one workbook to another
 

Hmm.. I tried some of these and it creates new work books for each entry or
new work sheets.. I want them all to go in the same new-workbook or
new-worksheet.... i am slightly confused...


"Ron de Bruin" wrote:

Hi LoboNetwork

Start with this
http://www.rondebruin.nl/copy5.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"LoboNetwork" wrote in message ...
Hello all,

I'm creating a new workbook based on data from an old workbook.
OR i can create a new worksheet in the same workbook. I need some help with
VB programming as I'm not great at it.... I can understand code but always
have trouble starting it up.

Here is the problem specification:

I have a workbook with about 1200 entries. Data starts from Row 3 in both
this spreadsheet and the new one I am going to create (the first two rows are
title and column headings). In column L, there is a "Component Part
number". Component numbers may be repeated many times. I want to filter
for each component number and then do the following:

- Copy the data entry from Workbook1 Row3 Column L and paste it into
Workbook 2 Row X (initially 3, but keeps going down a row after each filter)
Column B.
- For the same filtered component in Workbook1, copy the data entry from row
3 column P into workbook2, Row3 (initially 3, but keeps going down a row
after each filter) , column D.
- Also in the same filtered component, copy from Workbook1, row 1201, column
S (this is a sum-count of all the components)... into row 3 (initially 3, but
keeps going down a row after each filter) , column C.

and finally... Extract from workbook1 Row 3, column J and column F... and
paste the following into Workbook2, row3 (initially 3, but keeps going down a
row after each filter), column E. What should be pasted here is << column J
+ " for " + column F + " Valve".

Basically I want it to keep doing down the list of components so taht each
unique component is captured in the new workbook under their own row.

I hope my description is accurate...

It would save me a lot of time to have a program than to go through each
entry manually.. Any help on this would be greatly appreciated.

Terrel

plucking data from one workbook to another
 

Anyone have any additional help please?

"Ron de Bruin" wrote:

Hi LoboNetwork

Start with this
http://www.rondebruin.nl/copy5.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"LoboNetwork" wrote in message ...
Hello all,

I'm creating a new workbook based on data from an old workbook.
OR i can create a new worksheet in the same workbook. I need some help with
VB programming as I'm not great at it.... I can understand code but always
have trouble starting it up.

Here is the problem specification:

I have a workbook with about 1200 entries. Data starts from Row 3 in both
this spreadsheet and the new one I am going to create (the first two rows are
title and column headings). In column L, there is a "Component Part
number". Component numbers may be repeated many times. I want to filter
for each component number and then do the following:

- Copy the data entry from Workbook1 Row3 Column L and paste it into
Workbook 2 Row X (initially 3, but keeps going down a row after each filter)
Column B.
- For the same filtered component in Workbook1, copy the data entry from row
3 column P into workbook2, Row3 (initially 3, but keeps going down a row
after each filter) , column D.
- Also in the same filtered component, copy from Workbook1, row 1201, column
S (this is a sum-count of all the components)... into row 3 (initially 3, but
keeps going down a row after each filter) , column C.

and finally... Extract from workbook1 Row 3, column J and column F... and
paste the following into Workbook2, row3 (initially 3, but keeps going down a
row after each filter), column E. What should be pasted here is << column J
+ " for " + column F + " Valve".

Basically I want it to keep doing down the list of components so taht each
unique component is captured in the new workbook under their own row.

I hope my description is accurate...

It would save me a lot of time to have a program than to go through each
entry manually.. Any help on this would be greatly appreciated.

Terrel