Hello,
I need a somewhat complicated excel macro to be made. I have a list of year ranges (example: 01 02 03), and 2 lists of categories. The macro will need to go to our website (bodykitsuperstore dot com), navigate to the correct category, and retrieve the correct category depending on the year range.
In column A, I have a list of titles. The titles end with the year category (formatted like 01 02 03 04 05). In column B, there are the corresponding first categories. In column C, there are the corresponding second categories. The macro should visit the website:
bodykitsuperstore dot com
For each product (each row), it should visit the correct first category (follow the links on the left). It should then visit the second category. Then, it should figure out which year category it belongs in. To do this, it should look at the title, in column A. It should extract the years from the title, and compare it to the category. It should then copy/paste that category to column D. Although, it may fit into multiple year categories. If it fits into more than one year category, subsequent categories should go in columns E, F, etc.
Here are some examples for Acura CL:
bodykitsuperstore dot com/acura-cl-c-8_9.html
“96 97” should retrieve “Acura CL 96-99”
“99 00 01” should retrieve “Acura CL 96-99” AND “Acura CL 00-03”
“95 96 97” means a new category will have to be made, and should be noted in column D. Then, in column E, it should retrieve “Acura CL 96-99”
Let me know if anything is unclear.
Thanks!
I need a somewhat complicated excel macro to be made. I have a list of year ranges (example: 01 02 03), and 2 lists of categories. The macro will need to go to our website (bodykitsuperstore dot com), navigate to the correct category, and retrieve the correct category depending on the year range.
In column A, I have a list of titles. The titles end with the year category (formatted like 01 02 03 04 05). In column B, there are the corresponding first categories. In column C, there are the corresponding second categories. The macro should visit the website:
bodykitsuperstore dot com
For each product (each row), it should visit the correct first category (follow the links on the left). It should then visit the second category. Then, it should figure out which year category it belongs in. To do this, it should look at the title, in column A. It should extract the years from the title, and compare it to the category. It should then copy/paste that category to column D. Although, it may fit into multiple year categories. If it fits into more than one year category, subsequent categories should go in columns E, F, etc.
Here are some examples for Acura CL:
bodykitsuperstore dot com/acura-cl-c-8_9.html
“96 97” should retrieve “Acura CL 96-99”
“99 00 01” should retrieve “Acura CL 96-99” AND “Acura CL 00-03”
“95 96 97” means a new category will have to be made, and should be noted in column D. Then, in column E, it should retrieve “Acura CL 96-99”
Let me know if anything is unclear.
Thanks!
Last edited by a moderator:
