Help with Excel & Linking Workbooks

V teku Objavljeno pred 5 letoma/leti Plačilo ob prevzemu
V teku Plačilo ob prevzemu

Project Brief – Excel formulas/linking of workbooks

Please note: Project to be completed by 13th December

Please look over the project brief and attached workbooks prior to bidding.

- Circular formula needs to be added to create date/time stamp. When data is entered in C2 cell, C27 needs to be date/time stamped (on case note worksheet)

- support coordination duration needs to be entered on case note worksheet and then exported over the NDIS Budget & Reconciliation workbook as a duration but also as a cost (hourly rate will be provided to successful bidder)

- in the case note coordination workbook, a blank excel sheet needs to be brought to the front so the current case note is always the first case note in the workbook

- all worksheets to have the name SCCN_(date); possible way to automate date when data is entered into the sheet?

- date picker on Date cells

- formula in ‘Forecast’ worksheet of the NDIS budget & reconciliation workbook to calculate expenses over the duration entered (eg. 26 weeks)

Vnos podatkov Obdelava podatkov Excel Visual Basic Visual Basic za aplikacije

ID projekta: #18332136

Več o projektu

13 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

Dodeljeno:

informatikz

Hi, Good morning. I will explain a bit about the project first. Assume that you will be maintaining both sheets in one folder. When cell C2 is filled, automatically date can be captured in cell C27 through a m Več

$130 AUD v 2 dneh
(3 mnenj)
2.3

13 freelancerjev ponuja v povprečju za $186 na tem delu

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Help with Excel & Linking Workbooks. I can assure you the quality job. I have good experience in Data Entry, Data Processing, Excel, Visual B Več

$250 AUD v 4 dneh
(310 ocen)
7.7
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 Več

$200 AUD v 7 dneh
(220 ocen)
6.9
polarjin2017

Hello? How are you? I have good experiences in "Help with Excel & Linking Workbooks" as you can see my profile for these (Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps). I have been working Več

$155 AUD v 3 dneh
(73 ocen)
6.5
vlayausa

Hello, I am proficient with Excel and VBA. I would love to help with this project. I can add everything you requested, including datestamps whenever data is entered onto sheet. Please contact me for more info Več

$123 AUD v 2 dneh
(141 ocen)
5.8
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.

$250 AUD v 2 dneh
(72 ocen)
5.9
TechnoGuruu

Hi, I have checked the project description and he attached Excel sheets, I will do the automation of this sheets as per requirements. I have 10+ years of experience in MS-Excel, data processing automation and VBA ma Več

$149 AUD v 3 dneh
(58 ocen)
5.4
haleem0786

I can do this. I have good command over ms excel especially pivot table, charts, advance formulas, formatting, macro and vba as well . please review my profile and inbox me. thanks

$200 AUD v 3 dneh
(15 ocen)
3.6
Apisylux

Hi, I have read the description. Prior to opening the files, what i could sense from the description, that the functionalities you want to acquire, are quite hard and obviously some limitations because of Efficient Več

$200 AUD v 5 dneh
(2 ocen)
2.9
Ncowan1987

Good evening, Thank you for taking the time to consider me for your freelancer project. I have over 12 years of experience with Microsoft Office packages and have received a Microsoft Work proficiency certificate. I Več

$222 AUD v 2 dneh
(0 ocen)
0.0