Lengkap

Excel Calandar Pivot solution in VBA

Description

This job is for mid to senior Excel/VBA people. Please do not apply if you paste code found from Google. Your code will be edited/maintained by other people, so it must be modular, clear and concise. Only take this job if you can complete it comfortably in 2 days. I need this job done quickly and have another similar larger job straight after it.

I need an Excel Calendar Pivot created with layout and formatting performed in VBA.

The Excel spreadsheet will need to:

1. Have the data pivoted,

2. A layout applied, and

3. To have formatting applied.

This spreadsheet will have raw data refreshed regularly (from a database connection) in a ‘data only’ worksheet. I need VBA code to be written that transforms the data into a calendar style view on a new worksheet.

Whenever the VBA code runs, it will create a new worksheet and loop through the refreshed data to create a new calendar view. This calendar view will be read only for users.

I have attached two spreadsheets:

1. ‘SampleCalendarOutput.xlsx- this is similar to what the final product should look like

2. ‘SampleCalendarData.xlsx- this is sample data to base your code on. When code is ready for testing, I will provide a few hundred rows to test against

VBA deliverables

1. Prepare Calendar Worksheet

a. Delete any old worksheets named “Calendar”

b. Create a new worksheet named “Calendar”

2. Transform/Pivot Data

a. From the ‘Data’ worksheet:

i. Populate ‘Calendar’ row 1 with column names: First name, Surname, Trade, date1, date2, date3, … dateX

ii. Row onwards: populate data

b. Create rows for each person, then populate the dates for the days they are working

c. The first cell of any work should have the name of the site inserted. Every 7th day should have the site name inserted (makes it easier to read)

i. The colour for the cell should be taken from the “SiteColour” sheet

ii. Where a match for the site cannot be found, the “default” colour should be used

d. Loop though the entire data worksheet to populate all people and the job calendars they are working on

e. If a person has two jobs that overlap, then the overlapping cells should be black and populated with a star (i.e. *)

3. Format Data

a. Set all column widths, so all data is visible

b. Freeze the first 3 columns

c. The original data in the ‘data’ sheet goes back about a month and is about 2 months calendar in the future. The users will want to look at old data, but would like to start at todays date. Can you get the default view to be centred on today’s date?

d. Hide the ‘data’ and ‘sitecolour’ sheets

Notes

1. If you wish to apply, please:

2. Read the notes carefully and make sure you understand

3. Make sure you can complete the bulk of this in 1 day and have a spare day for any modifications

4. Be ready to talk to me to discuss

5. If unforeseen changes we will pay for this

6. I have another similar larger scope that needs to be completed 5 days later. It will be 2, or 3 times the amount of work. Similar, but with more formatting.

7. If you do a good job, I will ask you for an estimate and only give the work to you.

8. There are 2 more scopes in the next 2 weeks after the second scope is complete

9. Please only apply if you are available and certain you can complete this work on time

10. I will choose someone in 12 – 24 hours to commence the work immediately

11. I look forward to working with you.

2 days

Kemahiran: Excel VBA, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: cnet excel working pivot tables, excel addins installed analysis vba, excel custom pivot table, excel vba calendar schedule, refresh specific pivot table vba, how to make an interactive calendar in excel, how to create a calendar using pivot tables, convert excel dates to calendar view, how to create a pivot table calendar in excel, excel populate calendar from data, excel calendar macro, excel, using excel data google finance vba, excel 2003 paste clipboard vba macro excel, excel utf mysql asp vba, excel multi user login vba, vba excel update pivot, excel change pivot datasource vba, excel pivot load vba, pivot sum vba excel

Tentang Majikan:
( 1 ulasan ) Perth, Australia

ID Projek: #19974305

Dianugerahkan kepada:

aubrey03

I am an MS Excel and Access Specialist and an experienced Freelancer who is dedicated to provide quality results within a reasonable timeline and budget. Accuracy is my priority so I believe I am the best freelancer fo Lagi

$200 AUD dalam 2 hari
(73 Ulasan)
5.5

10 pekerja bebas membida secara purata $234 untuk pekerjaan ini

rinabuoy13

Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$200 AUD dalam 10 hari
(57 Ulasan)
5.9
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$450 AUD dalam 7 hari
(54 Ulasan)
5.4
urielbaray

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam Lagi

$180 AUD dalam 10 hari
(23 Ulasan)
4.8
nvchien94

Hello there, I am an Excel VBA coder from Vietnam. I looked your 2 attachment and I can do it for you within today. I am in timezone +7 and I can start working today. No difficulty I found so all will be smoothy as you Lagi

$200 AUD dalam sehari
(61 Ulasan)
5.0
$235 AUD dalam 3 hari
(14 Ulasan)
5.4
shoguna2m

Hi There, My name is Mauricio, I'm the MS Excel and VBA expert professional from Trascender Global team. I reviewed the 2 files attached and read the description and I can help you in building the code you need Lagi

$414 AUD dalam 2 hari
(8 Ulasan)
4.4
mtdevil369

Hi, I am having good knowledge on excel,micros and VBA module development. I have developed many automation process in excel. I am able to develop your process as well. Please come on freelancer chat to discuss many mo Lagi

$127 AUD dalam 0 hari
(23 Ulasan)
4.3
$150 AUD dalam 2 hari
(2 Ulasan)
1.1
evonsystems7

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Lagi

$180 AUD dalam 7 hari
(0 Ulasan)
0.0