Concluído

Excel keep completed monthly totals from changing after a price change in future months

I have an Excel sheet where I want to get tabulate the value of inventory on hand each month.

Sometimes the cost of items changes. For example if there was 12 widgets in January that cost $1 each, then in January the value should be $12. If the price changes to $2 in Feb. though, I want January's total to remain @ $12 and not change once a new month begins.

Habilidades: Processamento de Dados, Processamento de dados, Excel, Microsoft Office, Visual Basic

Veja mais: excel running total based on criteria, sumif, how to keep a running balance in excel, if function excel, excel formula to allocate an amount into monthly columns, excel formulas, excel sum values based on month, excel running total in one cell, updating excel vba workbooks without changing data, joomla price change virtuemart, using excel segregate monthly data, app price change monitor, excel formula ranking totals, php database price change, magento product options price change text value, javascript order form price change, oscommerce select attribute price change, virtuemart mass price change, oscommerce product price change currencies, inventory price change

Acerca do Empregador:
( 11 comentários ) Glen Allen, United States

ID do Projeto: #18890312

Concedido a:

atifdar

Hi there, MS Excel expert here I got your requirements, i will advise you to create a rates database on another tab through which i will link the inventory values calculations by formula in respective months Feel fre Mais

$18 USD em 1 dia
(78 Comentários)
6.2

22 freelancers estão ofertando em média $24 para esse trabalho

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega Mais

$30 USD in 0 dias
(222 Comentários)
6.9
priyal1997

Hi there, I’m a qualified accountant and an expert in advanced excel skills and can do this task perfectly. You can refer my profile to see details of my qualifications and if you are comfortable with those let’s discu Mais

$49 USD em 1 dia
(192 Comentários)
6.7
asadkhan3533

Please review my profile as I have relevant skills and experience required for this project. Kindly send me a message to discuss further details. Thanks, Asad khan

$30 USD em 1 dia
(116 Comentários)
6.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Mais

$30 USD em 1 dia
(84 Comentários)
5.5
Devrits

Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. A≠ I can do Data RESEARCH from any platform for certain subjec Mais

$10 USD in 0 dias
(38 Comentários)
5.4
gr8tech

Hello there I have seen the attached document. To achieve what you are referring, I would suggest adding some Macros/VBA code to your file, which will keep track of the prices, as you change them between the Months. S Mais

$30 USD em 1 dia
(39 Comentários)
5.0
$30 USD in 3 dias
(10 Comentários)
4.4
haleem0786

i can do this. i have good command over ms excel especially pivot table, charts, advance formulas, formatting, macro, VBA etc. Please review my profile and inbox [login to view URL]

$25 USD em 1 dia
(16 Comentários)
3.6
paulodayto08

Hi Good Day! I've done a lot of report like this before and I think I can help you with this project. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate Mais

$25 USD in 2 dias
(17 Comentários)
3.6
MoenTek

Hi there, I have gone through project descriptions. You required Excel to keep completed monthly totals from changing after a price change in future months. We are working with US companies like Convirza, ListenF Mais

$25 USD em 1 dia
(5 Comentários)
2.4
ComplianceNet

Hello! My name is Armando and I am a Systems Developer. I can help you with your requirement because I am a programmer in excel vba environment. For your requirement I will create a simple macro, to perform a "month cl Mais

$25 USD in 10 dias
(3 Comentários)
1.8
shahidulbhatsi3

Hi, there ! Welcome to my profile. If you are looking for a hard working , self- motivated, dynamic, able to harness critical situation and meet deadlines under pressure expert in Ms- Office that holds the following cr Mais

$15 USD em 1 dia
(0 Comentários)
0.0
RaymondAure

Good day! I studied financial management in college and I have vast knowledge in accounting, so recording the inventory is easy. I am also proficient in using Microsoft Excel and Word.

$15 USD em 1 dia
(0 Comentários)
0.0
parvez9072

Hi im interested to do this project. I have experience in data entry work. I will finish the project on time as per client’s requirements.

$11 USD in 10 dias
(0 Comentários)
0.0
sherpurpostecent

Hello Sir I Read Now your project description. I will be able to complete your work at the right time. creative it a training center. I & am all members of your team will be able to complete your work correctly. T Mais

$15 USD in 2 dias
(0 Comentários)
0.0
sudharshankopper

Microsoft Excel Certified

$25 USD in 2 dias
(0 Comentários)
0.0
prachiconultin4

If the scope of work is as written then will deliver the same in 2 days at written bid otherwise please discuss

$29 USD in 2 dias
(0 Comentários)
0.0
nabajitpaul2013

I CAN DO IT PERFECTLY IN JUST 01 DAY. I HAVE 10 YEARS EXPERIENCE IN DATA ENTRY AND MICROSOFT OFFICE.

$25 USD em 1 dia
(0 Comentários)
0.0
debimjahspet77

I have over 10 years experience in data processing, project writing, internet research. I work excellently with Microsoft Excel in keeping records and storing data.

$25 USD em 1 dia
(0 Comentários)
0.0
myrasilvestre09

With 14 years of experience doing excel task, I can definitely help you. Please let me know in chat or call if we are the best fit. Thank you

$20 USD em 1 dia
(0 Comentários)
0.0