ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 Macro question (https://www.excelbanter.com/excel-discussion-misc-queries/177635-excel-2007-macro-question.html)

Tangohammerli

Excel 2007 Macro question
 
I have a parts list that I want to write a macro for that will populate the
price for each entry/part. I know VLookup will work but I dont want to have a
separate master list.
I want the macro to loop through the data and apply the corrcet price(based
on description) to all parts. There are olny 37 parts with a few blank spaces
to be concerned with but there are duplicate entries for some parts.
I am new to Excel and dont know macros at all. I cant even remeber how to
start the data entry part of writing. BUT this project must be done this way.
I have it on Vlookup but that was unexceptable ..
Thanks in advance...
--
Jim


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com