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

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

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

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