Improve on existing MS Project Excel Macro

every one bid this project its a simple project need to give example.

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 macro tutorial for beginners, excel macro examples, improve excel 2016 performance, excel macros, improve excel performance with large files, how to copy excel macros from one pc to another, excel vba, excel macro tutorial, 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:
( 0 ulasan ) Chennai, India

ID Projek: #18815935

9 pekerja bebas membida secara purata $207 untuk pekerjaan ini


Hello there, I am an Excel expert. I read your description and your macro seem quite complicated but I can improve it. Please send me the file and I can look carefully. It's will take 1 day to fix but I can start r Lagi

$50 USD dalam sehari
(33 Ulasan)

Hi Let me start by expressing my admiration for your thoughts I'm pleased to bid in this project and hope my proposal find you in a good spirit I Made Many projects in these Fields: Arabic Translation Data Lagi

$45 USD dalam 2 hari
(3 Ulasan)

Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description and I am available and ready to work on it. I am a professional MS excel expert. I am enable to fulfill Lagi

$45 USD dalam sehari
(2 Ulasan)

Well Expertise in Kpo Field Data Entry(Copy paste Work) Web Research Data grabbing Ecommerence LEad Generation Email Appending Address Appending Copy paste work Advance Excel Catalog Creation Let me give Lagi

$155 USD dalam 3 hari
(0 Ulasan)

I will do your project

$155 USD dalam 3 hari
(0 Ulasan)

I have more than 15 years of excel experience with certification, thus I’m confident that i can help you Relevant Skills and Experience Microsoft Excel certifications and 15+ years of experiences

$110 USD dalam 3 hari
(0 Ulasan)

well I have an experience in data entry and Microsoft office,well I think I was capable of doing itfor your work

$166 USD dalam 3 hari
(0 Ulasan)

Me honest , hard worker , active & trustable . If u want good quality u should choice me I have lots of previous experience about this work Thank u so much

$1111 USD dalam 10 hari
(0 Ulasan)

Hye..As An AccA i can do this work quite easily and with the high degree of professionalism.I have vast experience of working in excel and PDF..:) THANK YOU

$30 USD dalam 3 hari
(0 Ulasan)