Find Jobs
Hire Freelancers

Build a few macros to develop a stocktake sheet

$30-250 AUD

完了済み
投稿日: 5年以上前

$30-250 AUD

完了時にお支払い
Hi, I need someone proficient in VBA who can build me a few Macros for an inventory stocktake sheet. I already have an activex combo box which generates a new entry every time I select a name from a drop down list. Now I need three things. 1. I need a button so that once the user inputs data (stock out, stock in etc), a confirmation pops up asking them if it's correct. Once the user click on it, the sheet will save (in two locations if possible) then the input cells for that entry become locked and aren't able to be modified anymore (unless I unprotect the sheet). 2. Once a name is selected from the drop down box, a time stamp (date and time in separate cells) is generated. I've tried using something similar to: If(cell <>"",NOW(),""). However, everytime a name is selected from the list, all of the old entries update to the current time. I need it to capture the time once the name is selected and that's it. 3. Once the time stamp has been generated, I want an if statement to read the time and see if it falls between 06:00 and 17:59, display "DS" or if it's between 18:00 and 05:59, display "NS" in a separate cell I will provide a template and the sheet passwords. Please provide a price and expected completion time.
プロジェクト ID: 17668578

プロジェクトについて

6個の提案
リモートプロジェクト
アクティブ 6年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
Hi, Nice to know your need. I am an excel, excel vba expert and have delivered around fifty solutions excel in the past eight months. Willing to work with you. Thank you, Regards.
$155 AUD 2日以内
4.9 (78 レビュー)
6.0
6.0
この仕事に6人のフリーランサーが、平均$153 AUDで入札しています
ユーザーアバター
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$200 AUD 3日以内
4.9 (183 レビュー)
6.7
6.7
ユーザーアバター
- For the Inventory Stock take sheet - Getting data for Stock in and Stock out - Confirmation to protect the data - Timestamp for the name selected and displaying DS or NS - Can be completed in 2 days for this functionality. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automat e: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables
$100 AUD 3日以内
4.7 (50 レビュー)
6.0
6.0
ユーザーアバター
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can write this VBA programme. That will perform above given tasks. Please come on chat for more details. Awaiting your response. Thank you.
$50 AUD 2日以内
4.3 (41 レビュー)
4.5
4.5
ユーザーアバター
Good Day, I am Marceli, I am recently working with macros and different VBA related codes and excel formulas. Your project is a catch to my attention and would be glad to have me try this out. I want to be honest and work hard to meet your needs. Thank you!
$138 AUD 7日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

AUSTRALIAのフラグ
MAYLANDS, Australia
5.0
3
お支払い方法確認済み
メンバー登録日:8月 30, 2018

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。