Closed

VBA Excel Spreadsheet work

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.

Skills: Excel, Visual Basic, Data Processing, Data Entry, Visual Basic for Apps

See more: vba reference worksheet by name, vba reference worksheet by codename, vba for loop, excel vba with worksheets statement, vba excel examples, excel vba sheet name variable, workbook.worksheets vba, excel vba programming for dummies, excel spreadsheet vba data entry form, date vba excel sql, vba excel spreadsheet work, office staff salary list excel spreadsheet, excel spreadsheet work bank statement, access vba open format excel spreadsheet, staff time management excel spreadsheet, excel contract work vba canada, vba front end excel spreadsheet, convert excel spreadsheet work web page, contract excel spreadsheet work, vba excel programmers work home

About the Employer:
( 0 reviews ) Jessore, Bangladesh

Project ID: #21193736

28 freelancers are bidding on average $10/hour for this job

shielacarttom

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 More

$6 USD / hour
(13 Reviews)
4.7
ielucerotrad1

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 More

$8 USD / hour
(13 Reviews)
3.8
indrapandu

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.

$4 USD / hour
(11 Reviews)
3.3
Rugues

Hello, I am very knowledgeable in excel, macros, VBA, data entry and have done similar task efficiently. I will like to do same for this project so that my skills will be used to achieve the goal. Relevant Skills and More

$5 USD / hour
(8 Reviews)
3.5
vibby987

able to start asap - experienced in excel. will be able to do the task, message me to discuss further details

$6 USD / hour
(4 Reviews)
2.1
daheriyakeshav

Hi, I have completed the work for you and it's uploaded onto the below location: [login to view URL] 1. Staff must take at least 10 CONSECUTIVE days off More

$2 USD / hour
(6 Reviews)
1.6
Bsram88

Hi, Currently i am working on Microsoft Products VB.NET, C#.NET, SQL, VBA in excel, access.  I can apply the above logic to your Annual Leave Project. My recent projects are,  * Scrap/Crawl Amazon Products with Deta More

$7 USD / hour
(1 Review)
0.6
wkernel

Hi, I am a senior vba expert. I can do this in 8hr. I am familiar with excel and vba. I can do it perfectly. Thanks

$8 USD / hour
(1 Review)
0.3
Panggumsok

Hi, I'm vba expert. I do some work in excel work using excel formula and macro. Working with me will may save your money and time. I can start work just right now. I hope your kind contact on this project. Thanks!

$8 USD / hour
(1 Review)
0.3
amar32

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.

$5 USD / hour
(0 Reviews)
0.0
sanjeevkumarahir

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.

$5 USD / hour
(0 Reviews)
0.0
polite90

Hi, I am a senior vbs expert. I am interested in your project. I will give you the best result best regards

$8 USD / hour
(0 Reviews)
0.0
angid18

i wann work with u Relevant Skills and Experience lead genertion ms. excel

$111 USD / hour
(0 Reviews)
0.0
Thoralf

more than 15 years of programming VBA and databases for small and medium customers in accounting related field.

$25 USD / hour
(0 Reviews)
0.0
$5 USD / hour
(0 Reviews)
0.0
jayjayceepvt

Excel is much cooperative when I get in with VB.

$4 USD / hour
(0 Reviews)
0.0
falaksitara7

i can easily do your project and 100 % accurately fullfill all your requirements to complete this project.

$8 USD / hour
(0 Reviews)
0.0
tcasas1

Hi! im an expert on excel and visual basic. point 1 (count of consecutive days, color change of cells and change of compliant column) will be done with a macro. point 2 (count of colored cells on row 2) will be done More

$2 USD / hour
(0 Reviews)
0.0
mechibabusci

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 More

$5 USD / hour
(0 Reviews)
0.0
zemanielmustapha

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.

$5 USD / hour
(0 Reviews)
0.0