Hi
I'm attaching an excel file that i use to manage orders, the issue is that the calculations get corrupted from time to time, i need a way to be able to keep calculations stable and also be able to move product orders from one sheet to a new sheet.
Here is how it works so you can have an idea
When we receive an order we enter in excel the item number, the brand, the description, price, buyer info and other info that you will see in the excell file
so let's said i entered 15 orders so we go get the items but when we get the the factory they may have only 10 items so we will need to return another day, at this time we need to create a new sheet and mode the items that we did not purchase to the new sheet where we may add more items before we go back to the factory to purchase.
So please take a look at the attached file and give me an idea of what you can do to help me work better
thank you
Note: The excel file is password protected with password 0116
Hi there.....
Warm Greetings
We came along with your request for Easy to use application or program and we reviewed your project description. We'd like to help you with confidence and satisfying results...
We have professionals working here with 100% results and more creative and renovative ideas for our clients !
We have worked on several similar projects before!
We are offering our services for more than 5 years in the field of Data Entry, Data Processing, Excel, Software Architecture, Visual Basic
We have worked on 300+ Projects. Please check the profile reviews
Feel free to message us to discuss briefly about your project !
Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros)
I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget.
I have 8+ years experience in Advance excel and VBA. As a solution, i can propose to have only 2 sheets using VBA
1- For daily use (at the end of day all pending orders will move to next day sheet
2- All processed orders stored in one sheet.
Give Your Excel File. I will Reacreate its Calculation Structure. I will made it easy For You.
Relevant Skills and Experience
Lots Of Working Experience Related Excel. I previously Working from 7 years On this Field.
we can write a code to mark the items brought from factory and not available items. so when you go back to factory next time you can see the new items and the items missed last time.
Also we can make additional arrangement like if the item is not available second time also then it will highlight.
Hi there,
Your excel seems to be working fine. I think the issue with the corrupted calculations occur when you are copying your formula from one sheet to the other (or probably typing them). A macro can run to automate copying of your table formats, formula and values from one sheet to the other, thus minimizing human error.
I could write the macro for you, throw in a few buttons and automate setting up a new sheet.
hint: Special Paste
If you don't want the hassle of typing everything again use Excels "Special Paste"