Help with Excel & Linking Workbooks

진행중 등록 시간: 5년 전 착불
진행중 착불

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)

데이터 입력 데이터 처리 엑셀 비쥬얼 베이직 앱을 위한 비주얼 베이직

프로젝트 ID: #18332136

프로젝트 소개

13 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 5년 전

수상자:

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 기타

$130 AUD (2일 이내)
(3건의 리뷰)
2.3

이 일자리에 대한 프리랜서 13 명의 평균 입찰가: $186

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 기타

$250 AUD (4일 이내)
(310 리뷰)
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 기타

$200 AUD (7일 이내)
(220 리뷰)
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 기타

$155 AUD (3일 이내)
(73 리뷰)
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 기타

$123 AUD (2일 이내)
(141 리뷰)
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 (2일 이내)
(72 리뷰)
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 기타

$149 AUD (3일 이내)
(58 리뷰)
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 (3일 이내)
(15 리뷰)
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 기타

$200 AUD (5일 이내)
(2 리뷰)
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 기타

$222 AUD (2일 이내)
(0 리뷰)
0.0