Help with Excel & Linking Workbooks

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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)

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Project ID: #18332136

About the project

13 proposals Remote project Active 5 years ago

Awarded to:

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 More

$130 AUD in 2 days
(3 Reviews)
2.3

13 freelancers are bidding on average $186 for this job

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 More

$250 AUD in 4 days
(310 Reviews)
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 More

$200 AUD in 7 days
(220 Reviews)
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 More

$155 AUD in 3 days
(73 Reviews)
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 More

$123 AUD in 2 days
(141 Reviews)
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 in 2 days
(72 Reviews)
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 More

$149 AUD in 3 days
(58 Reviews)
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 in 3 days
(15 Reviews)
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 More

$200 AUD in 5 days
(2 Reviews)
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 More

$222 AUD in 2 days
(0 Reviews)
0.0