Mbyllur

Excel expert

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.

Aftësitë: Excel, Përpunim të Dhënash, Regjistrim të dhënash, Visual Basic, Microsoft Office

Shiko më shumë: toronto excel expert job, excel expert financial models, money excel expert, need excel expert, excel expert independent contractor bid, excel expert finance job, excel expert service, freelance statistician excel expert, buy excel expert, excel expert freelance contract jobs, sound excel expert, excel expert contract, company needs excel expert, become excel expert, excel expert formulas, copy columns web page excel

Rreth Punëdhënësit:
( 0 përshtypje ) Phoenix, United States

ID Projekti: #23863841

38 profesionistë freelancer dërguan një ofertë mesatare prej $129 për këtë punë

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Më shumë

$222 USD për 3 ditë
(760 Përshtypje)
8.5
schoudhary1553

Hello, I can help you with your project - Excel expert I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects l Më shumë

$220 USD për 4 ditë
(369 Përshtypje)
8.1
asin1987

Dear Employer, I have closely checked your job and will deliver an efficient solution on this wherein you will not have to add the fields again and again. Please message me to discuss further, I will for sure do your Më shumë

$250 USD për 5 ditë
(198 Përshtypje)
7.7
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards

$150 USD për 1 ditë
(361 Përshtypje)
7.5
wsh2

Summary: Excellent MsEXCEL and Inventory application skills and experience. Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsACCESS/MsEXCEL/SQL/VBA/VB.Net Business Information, Programming, an Më shumë

$196 USD për 7 ditë
(55 Përshtypje)
6.4
rengrish

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

$45 USD për 1 ditë
(170 Përshtypje)
6.0
aubrey03

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]

$150 USD për 2 ditë
(143 Përshtypje)
6.2
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult details Më shumë

$30 USD për 1 ditë
(63 Përshtypje)
5.7
afenache

Hi, I can assist you to modify your excel orders - inventory tool. I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and Më shumë

$200 USD për 3 ditë
(22 Përshtypje)
5.3
KozlouAlex

Hello. I have completed recently two projects that are very similar to your requirements: https://www.freelancer.com/projects/excel/Excel-task-drop-down-menu/reviews I will be glad to support you with required script Më shumë

$80 USD për 2 ditë
(26 Përshtypje)
4.6
IgeS

Hi there, I suggest to have the data stack in a columnar layout instead of a static tabular layout. have a simple entry form that where you can input the new orders or new inventories. Once you have it, everything can Më shumë

$80 USD për 2 ditë
(15 Përshtypje)
4.6
reubengi

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

$99 USD për 5 ditë
(8 Përshtypje)
3.8
romanapanovich

Hi First of all - do You prefer Excel? Dont You want to go to GoogleSheet for this scope? 2 - im not sure i understood You right. Can You explain more detailed? As I understood there are three process parts a) You have Më shumë

$140 USD për 4 ditë
(2 Përshtypje)
3.5
jaelahoe

Hi there! Most people are just going to solve what you asked of them. But based on what I saw from your file, you actually need to change the layout of your data. This is so that you can generate reports more easily Më shumë

$200 USD për 3 ditë
(5 Përshtypje)
3.0
SupremeWriters

I'm an expert in data entry. I am working with a team of data entrant experts who can complete your projects within your given deadline. We can manage bulk data entry work in a very short period of time. Our service Më shumë

$30 USD për 1 ditë
(2 Përshtypje)
1.8
vw1514518vw

ready to develop the necessary code. and design to have the main customer inventory sheet as simple as it is, by creating a user input from to add customer orders, store it and deduct amounts from main sheet inventory Më shumë

$100 USD për 2 ditë
(1 përshtypje)
1.4
pinturichioz

Happy to deliver it quickly for you I am a computer engineer with an MBA degree and would love to do this as my 1st project

$30 USD për 1 ditë
(2 Përshtypje)
0.6
GermanLass

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.

$30 USD për 7 ditë
(1 përshtypje)
0.8
srikiranbusi3

I am a trained Data entry operator i can finish your work with the time frame.I am a trusted one to complete work.

$140 USD për 7 ditë
(0 Përshtypje)
0.0
plimtech

I appreciate you are currently using excel and your thoughts are to continue along those lines. Why not future proof your requirements by getting a bespoke web based interface to a proper SQL database. Much more robust Më shumë

$500 USD për 10 ditë
(0 Përshtypje)
0.0