L
LoboNetwork
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
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