Complex Excel Macro

Completed Posted 3 years ago Paid on delivery
Completed 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

Excel Visual Basic Data Processing Visual Basic for Apps Software Architecture

Project ID: #27910128

About the project

8 proposals Remote project Active 3 years ago

Awarded to:

expertatwork

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!

$66 AUD in 1 day
(256 Reviews)
6.3

8 freelancers are bidding on average $135 for this job

asin1987

Dear Employer, I am an Excel expert and have been working on process automation projects since a decade now. I have checked your project details and will ensure highly professional delivery. Kindly check my previous More

$200 AUD in 1 day
(268 Reviews)
8.1
rahul62544

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

$179 AUD in 1 day
(163 Reviews)
6.4
youchian521

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

$100 AUD in 1 day
(5 Reviews)
2.9
yaseenbhatti

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

$78 AUD in 2 days
(0 Reviews)
0.0
romerojonalynp

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

$150 AUD in 4 days
(0 Reviews)
0.0
Sonukewat488

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

$170 AUD in 7 days
(0 Reviews)
0.0