Update one workbook based on another workbook from a part number?

  • Thread starter Thread starter CAM
  • Start date Start date
C

CAM

Hello,

I have a Excel workbook call "Parts Catalog" that shows the following
example:

Description Part# Amount
Book 1458 23.00
Pen 3459 125.00
Note Pad 8943 35.00

I have another Excel workbook that will contain amounts that have changed,
the description and part# will be the same. This workbook is call "Updates".
Since there is about over 500 rows and not all the rows will need to be
updated. I manually update the "Parts Catalog" per week about 30 to 35
items. Is there a way that I can have the "Parts Catalog" amount updated
(automatically) based on the Part# from the "Update" workbook? Any tips
will be appreciated. Thank you in advance/

Cheers
 
| Hello,
|
| I have a Excel workbook call "Parts Catalog" that shows the
following
| example:
|
| Description Part# Amount
| Book 1458 23.00
| Pen 3459 125.00
| Note Pad 8943 35.00
|
| I have another Excel workbook that will contain amounts that have
changed,
| the description and part# will be the same. This workbook is call
"Updates".
| Since there is about over 500 rows and not all the rows will need to
be
| updated. I manually update the "Parts Catalog" per week about 30 to
35
| items. Is there a way that I can have the "Parts Catalog" amount
updated
| (automatically) based on the Part# from the "Update" workbook? Any
tips
| will be appreciated. Thank you in advance/
|
| Cheers

I have a couple of ideas milling around. Let's see what the Excel
gurus come up with and maybe a collaboration is in order.

--
Steve Spence
Independent AMSOIL Dealer
AMSOIL - The "Once A Year" Oil Change
Unemployed Car Guy - Trying To Earn A Living
35 Years of G.M. Parts Experience
URL: http://synthetic-oil-tech.com/1690163
Email: (e-mail address removed)
|
 
| Hello,
|
| I have a Excel workbook call "Parts Catalog" that shows the
following
| example:
|
| Description Part# Amount
| Book 1458 23.00
| Pen 3459 125.00
| Note Pad 8943 35.00
|
| I have another Excel workbook that will contain amounts that have
changed,
| the description and part# will be the same. This workbook is call
"Updates".
| Since there is about over 500 rows and not all the rows will need to
be
| updated. I manually update the "Parts Catalog" per week about 30 to
35
| items. Is there a way that I can have the "Parts Catalog" amount
updated
| (automatically) based on the Part# from the "Update" workbook? Any
tips
| will be appreciated. Thank you in advance/
|
| Cheers

Alex:
It's been a couple of days and I see that no one else has responded.
Are these separate Excel books or are they different sheets in the
same book?

I have a solution for you. Are you Excel friendly?

Just email me directly if you want my help and we'll take the
discussion private. It's going to get involved.

--
Steve Spence
Independent AMSOIL Dealer
AMSOIL - The "Once A Year" Oil Change
Unemployed Car Guy - Trying To Earn A Living
35 Years of G.M. Parts Experience
URL: http://synthetic-oil-tech.com/1690163
Email: (e-mail address removed)
|
 
Back
Top