Complex Excel Macro
$30-250 AUD
Paid on delivery
We need to create a macro to carry out the following rules on the attached sheet.
We need to have it setup well so that every day I can change the first two sheets with todays stock and run the macro.
ALL RULES SHOULD NOT BE CASE SENSITIVE
Step 1
If model contains "Used as Demo"
Then
Add "(B-)" into Filter Grade column
and Add "(B+) into "IF NOT THEN THIS GRADE"
If model contains "As new"
Then
Add "(A)" into Filter Grade column
and Add "(A) into "IF NOT THEN THIS GRADE"
Step 2
On "Rules model" sheet run through all rows
(We will add more and more rules as we go along for this sheet)
On Rules model copy the value from column A and if found on Quote form paste the value in column B (of rules model) into the "Filters Model" column on Quote form
Once the script finds the first result go to step 3 (does not need to look for more results per row)
Step 3
On "Rules GB" sheet run through all rows
(We will add more and more rules as we go along for this sheet)
On Rules GB copy the value from column A and if found on Quote form paste the value in column B (of rules gb) into the "Filters GB" column on Quote form
Once the script finds the first result go to step 4 (does not need to look for more results per row)
Step 4
On "Rules Color" sheet run through all rows
(We will add more and more rules as we go along for this sheet)
On Rules Color copy the value from column A and if found on Quote form paste the value in column B (of rules color) into the "Filters GB" column on Quote form
Once the script finds the first result go to step 4 (does not need to look for more results per row)
I have filled in the first row as a sample
Continue this for each row on Quote form
*****PART 2****
Part 2 we want to again find results for every row on Quote form
For each row do the following
On the sheet "Renewable Stock on hand" make a filter to find the results
Filter Product
contains [Filter Grade]
and
contains [Filters Model]
and
contains [Filters GB]
and
contains [Filters Color]
IF no result found then try the below filter
Filter Product
Contains [IF NOT THEN THIS GRADE]
and
contains [Filters Model]
and
contains [Filters GB]
and
contains [Filters Color]
If still no result found leave blank and move to next row
IF result is found then copy the SKU, PRODUCT, QTY, PRICE into the Quote form
Project ID: #27910128
About the project
Awarded to:
Hi there - Thanks for the heads-up and the sheet. I am available now and I can right the macros right away. Please reply, we can discuss further and hopefully get it started soon. Thank you!
8 freelancers are bidding on average $135 for this job
Hi I can Create every type of Macros, and after reading your requirements I think I can do this too. There are some things which i need to discuss and clarify after that we are good to go. This Macro contain many rules More
Hi Dear, I read your description carefully. I understood what you require me to do and I am filled with confidence that I can complete your project wonderfully. I have experience over 5+ years with Data Typing, Data En More
Hi I see your attached file I understand your work properly I will do this work easily I am expert in excel VBA and Macros please give me a chance to get best work your work accuracy is my responsibility please contac More
Hi, I would like to extend my expertise on this project using Microsoft Excel/Excel VBA/Macro. I am just beginning my freelancing here but I can assure you that if you work with me once, you will always work with me More
I am professional data entry you know that I have been working with group activities and fastest growing your business thanks for cancted with me