Help with Excel & Linking Workbooks
$30-250 AUD
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)
Project ID: #18332136
About the project
Awarded to:
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
13 freelancers are bidding on average $186 for this job
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
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
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
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.
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
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
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