Lengkap

Improve on existing MS Project Excel Macro

Please see below the requirements that must be satisfied:

1. The each week must always start from Sunday and end on Friday.

2. If no works occur on one of these days, the column must still appear but just have no contents.

3. Each alternate stage should be an alternating colour. Currently this is done manually.

4. A custom header should be added containing the two logos attached. Woolworths on the left and Flexem logo on the right.

5. The rows and columns on each sheet should be formatted so that it is centred and takes as much of the page as possible.

There are currently a few bugs present,

1. The in filled cell colour is black. We have to manually change it to no fill.

2. The above requirements are sometimes not met depending on the dates selected.

3. Excel and the “run macro” project file must be closed before rerunning the macro.

To run the macro on the project file:

1. Open both the run macro and the Cronulla project file

2. Go to view macro while in the Cronulla project and run macro

3. Enter the dates using the date selector

4. Hit run

5. An excel workbook should be created.

I’ve attached the raw output from the current macro.

We then add the headers/logos, selected the area of each page to be printed and space the rows and columns manually to maximize the area on each page.

Ive also attached the manually modified excel file. We would like you to achieve this result without having to manually make the changes.

Any questions, please don’t hesitate to get in touch!

Kemahiran: Excel, Microsoft, Microsoft Office, Visual Basic

Lihat lagi: excel macros, export ms project to excel and keep formatting, export ms project 2016 to excel and keep formatting, improve excel performance with large files, export ms project to excel gantt chart, export ms project 2010 to excel, convert ms project to excel, excel macro tutorial for beginners, excel macro move data existing cell, excel macro project daten importieren, excel macro protect project, excel macro read microsoft project, excel macro import project files, excel macro call project, project excel macro, export project excel macro, macro import project excel, project excel macro libro, web reference project excel macro, copying data ms projects excel macro

Tentang Majikan:
( 5 ulasan ) Rydalmere, Australia

ID Projek: #18804846

Dianugerahkan kepada:

schoudhary1553

Hello,\r\n\r\nI have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profil Lagi

$150 AUD dalam 2 hari
(312 Ulasan)
7.8

28 pekerja bebas membida secara purata $390 untuk pekerjaan ini

prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can help u adjust or modify in your existing macro please ping me now and im free now to discuss more Thank you Galih

$250 AUD dalam 3 hari
(340 Ulasan)
7.1
zekovicm

Hi there,I am Excel Macro expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the Lagi

$388 AUD dalam 3 hari
(96 Ulasan)
7.0
dgled

I’m qualified for this task and can show you an example of a similar project I did recently. I'm an expert in Excel/Macro with over 30 years of experience and in-depth knowledge of formatting, advanced formulas, pivot Lagi

$500 AUD dalam 3 hari
(76 Ulasan)
7.0
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 Lagi

$400 AUD dalam 5 hari
(220 Ulasan)
6.9
mateenbhatti94

Dear sir I have read the requirements and completely understand the project. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will al Lagi

$500 AUD dalam 2 hari
(62 Ulasan)
6.0
SShtv

Hi, I'm interested in your proposal. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel These are screenshots of some of Lagi

$250 AUD dalam 3 hari
(77 Ulasan)
5.9
vsprybhanu

Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Lagi

$250 AUD dalam 10 hari
(70 Ulasan)
5.4
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Lagi

$250 AUD dalam sehari
(84 Ulasan)
5.5
vmadhavan15

THIS PROJECT IS ALREADY OUTSOURCED BY SOMEONE CHECK THIS https://www.freelancer.com/projects/excel/Improve-existing-Project-Excel-Macro-18815935 I AM NOT A RANDOM BIDDER>>> PLEASE PING ME IF YOU ARE INTERESTED WI Lagi

$300 AUD dalam 3 hari
(29 Ulasan)
5.2
sdroberts

Hello I’d be happy to assist with your macro. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba based iss Lagi

$444 AUD dalam 3 hari
(8 Ulasan)
4.0
dungchan44

Hi, bro! I'm very happy to put my bid by 12th on your project. I've read your requirement and full test your attached. I have a wealth of experience with data processing using Excel formula and VBA. I have finishe Lagi

$250 AUD dalam 2 hari
(16 Ulasan)
3.9
Altantsetseg

Hi. From your project declaration, it's the kind of project that I have been experienced well. I have been experienced in programming including Ms Excel macro /VBA/ since 2000. During 2006-2013, I had been working as a Lagi

$422 AUD dalam 5 hari
(6 Ulasan)
4.0
Apisylux

Hi Sir, I have read your description. I understood all the point and need few questions to ask. Also i got the understanding that you want a macro to do all for you including those things which are currently manua Lagi

$666 AUD dalam 10 hari
(3 Ulasan)
3.3
arash18k

Hi, I can make all these steps automatically, just send me message to clarifying some steps. Best Regards

$250 AUD dalam 3 hari
(4 Ulasan)
3.3
sundamase

Good in Power point presentation work, MS office, Data Entry, Inventory report , Excel work, Ms word, I have good knowledge of Microsoft office work, MS office, Data Entry, Inventory report , Excel work, Ms word,

$277 AUD dalam 10 hari
(1 Ulasan)
1.2
TumblingWave

Hi there, I would like to bid for this project. I have 10+ years of advanced Excel programming in a variety of industries, including Finance Depts of large US Companies. I look forward to making your project a success.

$388 AUD dalam 10 hari
(1 Ulasan)
0.8
Divakarao

I have good skills on MS office, so i can do the tasks.... I am new to this work but i am sure i can do this job very well.

$555 AUD dalam 10 hari
(0 Ulasan)
0.0
Kksingham

Scored 98% in MS-CIT course from maharashtra india Relevant Skills and Experience Good experience in ms office and good typing

$555 AUD dalam 10 hari
(0 Ulasan)
0.0
gazirevenue

I want to work for you, I promise that you will complete satisfactory after your work was done, Thank you

$555 AUD dalam 10 hari
(0 Ulasan)
0.0
afsar0704

Documentation of HVAC system And any other data entry works

$555 AUD dalam 10 hari
(0 Ulasan)
0.0