Hi, I am working on a code that will pull data from the web based on a specific cell in excel. I am very new to excel so I haven't gotten very far so any help is greatly appreciated!
Gist of what I would like it to do:
1. Review each line on the "Summary" tab in the attached excel
2. Based on If statement:
Scenario 1:
If column B equals, "R", then add line to next available line in the "Pricing" tab.
Line to consist of:
Column A = next number (starting with 1 then the next part will be labeled 2)
Column C= part # from "Summary" tab
Column D= description from "Summary" tab
Column E= qty from "Summary" tab
Column F= Go to "Ryobi" tab, search for part and get price and paste to "Pricing" tab
Column G= Column E*F= total
Column H= If Column B = M then will equal Milwaukee.. if R then equal Ryobi
Column I= Insert date and time pulled (including time zone)
Scenario 2:
If column B equals, "M", then go to website ("Part Number Lookup and Parts Pricing Calculator") and then click on "here" and download
After clicking on it, I would like to download and save a new workbook in the same folder as the Price List workbook as "Milwaukee Price". After saving, I would like to open it and extract the price for the parts that are labeled "M".
Line to consist of:
Column A = next number (starting with 1 then the next part will be labeled 2)
Column C= part # from "Summary" tab
Column D= description from "Summary" tab
Column E= qty from "Summary" tab
Column F= Get from "Milwaukee Price" workbook after saved. (Search for exact PN and get price)
Column G= Column E*F= total
Column H= If Column B = M then will equal Milwaukee.. if R then equal Ryobi
Column I= Insert date and time pulled (including time zone)
Price List Workbook (has 3 sheets)
1. Summary
2. Pricing
3. Ryobi
Gist of what I would like it to do:
1. Review each line on the "Summary" tab in the attached excel
2. Based on If statement:
Scenario 1:
If column B equals, "R", then add line to next available line in the "Pricing" tab.
Line to consist of:
Column A = next number (starting with 1 then the next part will be labeled 2)
Column C= part # from "Summary" tab
Column D= description from "Summary" tab
Column E= qty from "Summary" tab
Column F= Go to "Ryobi" tab, search for part and get price and paste to "Pricing" tab
Column G= Column E*F= total
Column H= If Column B = M then will equal Milwaukee.. if R then equal Ryobi
Column I= Insert date and time pulled (including time zone)
Scenario 2:
If column B equals, "M", then go to website ("Part Number Lookup and Parts Pricing Calculator") and then click on "here" and download
After clicking on it, I would like to download and save a new workbook in the same folder as the Price List workbook as "Milwaukee Price". After saving, I would like to open it and extract the price for the parts that are labeled "M".
Line to consist of:
Column A = next number (starting with 1 then the next part will be labeled 2)
Column C= part # from "Summary" tab
Column D= description from "Summary" tab
Column E= qty from "Summary" tab
Column F= Get from "Milwaukee Price" workbook after saved. (Search for exact PN and get price)
Column G= Column E*F= total
Column H= If Column B = M then will equal Milwaukee.. if R then equal Ryobi
Column I= Insert date and time pulled (including time zone)
Price List Workbook (has 3 sheets)
1. Summary
2. Pricing
3. Ryobi