Complicated Formula into VBA Macro using Compare - Maybe a Challenge for Advanced Programmer

[ucsutah1]

Hi,

I have been working on this vba script for a while now and this is the piece that I need to complete it. I tried to do this myself with STRCOMP Function but it didn't work or not the correct function.

Compare Colum H (Total Buy Box Price) & Column J (Seller Price) if Column H (Total Buy Box Price) is higher than Column J (Seller Price) then equal Column H (Total buy box price) and lower by .10 in Column J (Seller Price) Column then output the results in Column N (Total Seller Price) and change cell to red. On another sheet called products-selected, copy Column N (Total Seller Price) and column B (sellersku).

If Column H (Total Buy Box Price) is lower than Column J (Seller Price) then lower Column J (Seller Price) to 5% if column J (Seller Price) is within 10% of Column H (Total Buy Box Price), If not then keep the same amount.

If this makes sense great, if not I can create some examples?

I hope you guys like a challenge because this one to me is difficult and would probably need an advanced programmer. I know you guys like challenges though. I tried it myself and over my head.

thanks again for helping me on this.

 

[JimboP77]

Do you have a sample spreadsheet?

 

[ucsutah1]

Hi,

thanks for your quick response. Here is a link to a sample file called SampleSpreadsheet.xlsx
[FONT=source_sans_proregular]https://mega.nz/#!Ho92VAKA!6O-izExiMP15gZblCUaod1Wc68juhvab5bE4dXpyXZ8

Also, I made a mistake, instead of Column H, it should be the column I (Total BuyBoxPrice).

thanks[/FONT]

 

[ucsutah1]

Sorry, i just realized i made a mistake when i ran my code.

Compare Colum I (Total Buy Box Price) & Column N (Total Seller Price) if Column I (Total Buy Box Price) is higher than Column N (Total Seller Price) then equal Column I (Total buy box price) and lower by .10 in Column N (Total Seller Price) Column then output the results in Column AC (Final Seller Price). (Final Seller Price) and change cell to red. On another sheet called products-selected, copy Column AC (Final Seller Price) and column B (sellersku).

If Column I (Total Buy Box Price) is lower than Column N (Total Seller Price) then lower Column N (Total Seller Price) to 5% if column N (Total Seller Price) is within 10% of Column I (Total Buy Box Price), If not then keep the same amount.

The mistake I made is I didn't add shipping and fees to make it a proper Total Seller price to compare with Total Buy Box Price.

Sorry i made that mistake

 

[ucsutah1]

I guess nobody wants to tackle this project? lol