VBA Excel Spreadsheet work
$2-8 USD/小时
We use an excel spreadsheet to track annual leave for your staff. We change the color of the cells to show that a staff member has booked a day for leave. This could be ANY colour. I need to modify the attached excel spreadsheet to do the following things.
1. Staff must take at least 10 CONSECUTIVE days off throughout the year to remain compliant. When a 10 CONSECUTIVE cells in a row have been highlighted, they the 10 days compliant column must change from No to Yes. If the staff member does not have 10 days then the row will remain as NO
[login to view URL] 2 at the top must show a count of every coloured cell in that row. We use this to determine how many staff members have booked leave at the same time.
3. Coloumn "total days" needs to show the count of the total number of coloured cells in that row so we can see how many days total that staff member has booked for the year.
4. We need to freeze the top two row panels so that when we scroll down (once we add many more staff members) the date and cell count will remain at the top.
5. We need to freeze the column A - G so that as we scroll right to see all the dates, this comes with it.
6. have a + button that adds another row at the bottom which copies all formulas in the above row.
项目ID: #21193736
关于项目
有23名威客正在参与此工作的竞标,均价$11/小时
Hi, I have read the attachments. I can create off day sheet either using VBA or only formula, to avoid slow loading, VBA is preferres. Let's have a chat, looking forward to discussing with you.
Good day! I'am reaching out to express my highest interest on this position. I was a virtual assistant to an Australian company and what I mostly do is create Invoices for all employees using MYOB AccountRight, proces 更多
I can do te job! Will deliver fast results in under two hours. Total Cost between 8 and 16 usd. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA incl 更多
Hi have good experience in excel and data analysis I can do this in 5 hrs kindly provide me opportunity
Hi, I'm laureat of a great school of engineers, and in my work I rely a lot on VBA programming, your project is very simple, I can help you.
I have extensive experience and knowledge in typing . I work quickly and quality is my top priority . I believe that truth and correct communication are most important for successful collaboration.
Hello Sir, I hope you are doing good. I have carefully read the job description. I would like to offer myself as a suitable candidate for this post as I have relevant experience. Inbox me to discuss further details. Lo 更多
Hello Sir, I have 8+ years of experience in Advanced Excel and VBA Macros. I can easily deliver this project in 6 hours with 100% quality, once you assign and share the files with me.
i can easily do your project and 100 % accurately fullfill all your requirements to complete this project.
more than 15 years of programming VBA and databases for small and medium customers in accounting related field.
I have more than five years experience in MIS and Data Analysis for a telecom company. I can complete this work within timelines with cent percent accuracy.
I am very good in typing skills (80 words per minute) and also expert in MS-Word and MS-Excel skills. Also i am very good in VBA Macros and automations. I am sincere at work and please give one chance and you will 更多