I work for a Direct mail company. We have a client in which we print mass quantities of pieces ahead of time and then twice a week they place an order for each of the pieces. The numbers can vary pretty greatly and instead of taking an inventory every time there is an order I want to the ability to enter in the number and have it deduct from the total inventory. The issue I am having is though once I delete that number it takes it out of the ending inventory as well. I do not want to have to continue adding columns for every new order as I want to keep the main page of the excel file as simplistic as possible to eliminate the chance of errors from multiple different data entry points. That being said every time there is a new entry I would like it to copy the data to a second sheet in order to track trends etc.
38 profesionistë freelancer dërguan një ofertë mesatare prej $129 për këtë punë
Hi Sir, I am expert in Excel/VBA. I can give you accurate solution to this scenario. Please ping back to discuss further/. I can complete the job within hour. Please check my reviews. Thank You Regards Rishi
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Hi there. I have good experience working with XL and creating the tools required to make work easier for the end users. I can help you get what you want. Regards. Reuben
I am full time excel programmer. I am able to do any task, such as tables, graphics and formulas. Responsable and detailed. I will always try to deliver the result as fast as posible. Contact me if you are interested.