nwentling5
New Member
- Joined
- Jul 26, 2011
- Messages
- 16
Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
I have read over numerous threads on how to do this, but I am still not able to piece together the correct code to make it work.<o
></o
>
What I am trying to do is write some VBA code to run through a master part list, add up the duplicated part's quantity values and then delete the duplicated rows that housed the duplicated cells. <o
></o
>
<o
></o
>
Essentially, what I have is and what I need it to do is:
<o
></o
>
<o
></o
>
*After being populated by other work sheets within the workbook
Part Name: Quantity Required:<o
></o
>
Knob 6<o
></o
>
Wheel 4<o
></o
>
Hub 3<o
></o
>
Knob 5<o
></o
>
Wheel 3<o
></o
>
<o
></o
>
*Click Update Button
<o
></o
>
Part Name: Quantity Required:<o
></o
>
Knob 11<o
></o
>
Wheel 7<o
></o
>
Hub 3
<o
></o
>
<o
></o
>
I must note that I am using 2007 Excel and the loops need to be able to work dynamically since the master list will be updated regularly from other worksheets.
<o
></o
>
<o
></o
>
Also I have looked at pivot tables and I have messed around with them, but I wasn't able to create exactly what I was looking for.
<o
></o
>
<o
></o
>
If anyone can provide me a direction or some basic code on achieving this it would be greatly appreciated! I feel like it is probably something easy to code in VBA, but I have worked myself into a confused & lost state<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600">
<v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v
ath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></v
ath><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype>.<o
></o
>
<o
></o
>
Thanks!<o
></o
>
<o
I have read over numerous threads on how to do this, but I am still not able to piece together the correct code to make it work.<o
What I am trying to do is write some VBA code to run through a master part list, add up the duplicated part's quantity values and then delete the duplicated rows that housed the duplicated cells. <o
<o
Essentially, what I have is and what I need it to do is:
<o
<o
*After being populated by other work sheets within the workbook
Part Name: Quantity Required:<o
Knob 6<o
Wheel 4<o
Hub 3<o
Knob 5<o
Wheel 3<o
<o
*Click Update Button
<o
Part Name: Quantity Required:<o
Knob 11<o
Wheel 7<o
Hub 3
<o
<o
I must note that I am using 2007 Excel and the loops need to be able to work dynamically since the master list will be updated regularly from other worksheets.
<o
<o
Also I have looked at pivot tables and I have messed around with them, but I wasn't able to create exactly what I was looking for.
<o
<o
If anyone can provide me a direction or some basic code on achieving this it would be greatly appreciated! I feel like it is probably something easy to code in VBA, but I have worked myself into a confused & lost state<?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
<o
Thanks!<o