joeny0706
09-17-2021, 08:16 AM
Hi All
I have raw data that I convert into a format I can upload into my accounting program.
I have a xlsm file with 7 modules or so. One of these modules calculates discount. It takes the price in the raw data and compares it to a price listed on a xlsx file. If that price is lower it will calculate the discount them make a new discount line with that value. We are changing our prices for some of the customers. It is going up of course. Since it is only changing for some customers it is causing a problem. Currently if the price in the raw data sold price is more than the price of the item “price listed in xlsx file” it replaces the higher price with the correct price. Since that price increase, I need a change I was hoping someone can help me with. If the price is higher than the correct price “listed in the xlsx file” I now need it to leave that price alone. “Not change it to match the correct price”. Would anyone have time to take a look and see if it is just a quick fix.
I have two xlsm files. One for credits and one for invoices. I need the same done to both.
I have attached both xlsm files I use to convert the data, the xlsx files the xlsm use to do conversion and a file showing raw data, current conversion and how I need the conversion outcome to look.
I have raw data that I convert into a format I can upload into my accounting program.
I have a xlsm file with 7 modules or so. One of these modules calculates discount. It takes the price in the raw data and compares it to a price listed on a xlsx file. If that price is lower it will calculate the discount them make a new discount line with that value. We are changing our prices for some of the customers. It is going up of course. Since it is only changing for some customers it is causing a problem. Currently if the price in the raw data sold price is more than the price of the item “price listed in xlsx file” it replaces the higher price with the correct price. Since that price increase, I need a change I was hoping someone can help me with. If the price is higher than the correct price “listed in the xlsx file” I now need it to leave that price alone. “Not change it to match the correct price”. Would anyone have time to take a look and see if it is just a quick fix.
I have two xlsm files. One for credits and one for invoices. I need the same done to both.
I have attached both xlsm files I use to convert the data, the xlsx files the xlsm use to do conversion and a file showing raw data, current conversion and how I need the conversion outcome to look.