Excel Automation Help needed

In the beginning the sheet will have the following tabs

Index - Manually created

Introduction - manually created

GO/NO GO Checklist - Manually Created

Master Server List - Manually populated ( have marked columns that are mandatory to fill up in Grey. If these columns are not populated then there will be an error in generating run books )

Migration Methodology - Will have the list of all Migration Methods and will also have provision to add a new method

List - Will be a hidden list which has all the Migration methods

Migration Methodology Steps - Will have steps for each migration method

Requirement 1 : generate Run Book


STEP 1 : User fills up mandatory columns in Master Server List

STEP 2 : User selects Migration Methodology from Master Server List

STEP 3: User hits the button generate run book

Expected output : This should generate detailed run books as shown in the sample sheet

Wave#1 Group 0

Wave#1 Group 1

Wave#1 Group 2

Wave#2 Group 1

The Wave number comes from master server list and the Group number also comes from Master Server List

The rows highlighted in Grey in the Detailed runbooks will remain exactly the same and will not change. The steps will be populated for each server in the Group. In the sample sheet there are 2 servers in each group but there may be more servers in the group. Also there may be multiple waves so the tab needs to be named accordingly.

Requirement 2 :


Assume there is a new Migration method in the market and we want to add this in the Excel.

Step 1 : User appends the migration method in Migration Methodology Steps Tab

Step 2 : User goes to the tab Migration Methodology and clicks on the button Add methodology

Expected outcome

The list in the Migration Methodology should be updated to reflect the new method

User should be able to generate run book based on this methodology

Znanja: Excel

Več: excel automation step step, excel project help needed, getafreelancer message sql query help needed, how to automate excel reports using macros, excel automation tools, excel automation examples, microsoft excel automation, what is the use of macros in excel with examples, excel automation methods, how to automate excel reports, how to automate excel spreadsheets, sharepoint services export excel automation, python projects help needed, excel automation charts xaxis range, marketing help needed, photography portfolio help needed, excel macro cut paste based cell value, visual start help needed, programmers help needed, excel automation visual basic script

O delodajalcu:
( 0 mnenja ) Bangalore, Australia

ID projekta: #17796214

19 freelancerjev ponuja v povprečju za $162 na tem delu


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( Več

$250 AUD v 3 dneh
(612 Ocen)

Hello! This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel Automation Help needed. I've delivered more than 400 + projects in the last 5 years and this makes me very confid Več

$250 AUD v 6 dneh
(258 Ocen)

- Went through the Run book and the various tabs Based on the GO/No GO checklist Master Server List Migration methodology Run Book could be generated for each of Wave#1 Group0 Wave#1 Group1 Wave#1 Group2 Več

$160 AUD v 3 dneh
(47 Ocen)

Hello there, as an expert in excel and VBA, i can help you to automate your workbook exactly as you have specified. Please contact me and let us talk more about your project. Thanks

$144 AUD v 3 dneh
(58 Ocen)

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached file. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanc Več

$120 AUD v 3 dneh
(45 Ocen)

Dear Hiring Manager, I have been working on Excel Automation and have successfully delivered all projects My expertise include, but not limited to: Macros, Web Scraping, Dashboard, Pivot Tables, Customized Ribbo Več

$201 AUD v 3 dneh
(6 Ocen)

Hi Good day! A serious freelancer here! I have a lots of available time to this work. I can help you to complete this work, but need to know the full requirements to assess how long would it take to complete this Več

$150 AUD v 3 dneh
(7 Ocen)

I am ready and available for this job. I can do the data entry or research if necessary. Please send more info about the job.

$155 AUD v 3 dneh
(0 Ocen)

Hi I am currently working with Microsoft as a tier 2 technician and I have good knowledge of Excel Relevant Skills and Experience Good knowledge of Excel

$155 AUD v 3 dneh
(0 Ocen)
$111 AUD v 5 dneh
(0 Ocen)

Hi Sir, I am able to do this project. I have good knowledge on excel and VBA coding and I have done many automation in excel. Further,I have also good knowledge on the following accounting software:- -Xero -Qu Več

$200 AUD v 3 dneh
(0 Ocen)

Hello sir , I am willing to work for your project. And also I am interested in your [login to view URL] me one time and I am sure I will never make you disappointed

$155 AUD v 3 dneh
(0 Ocen)

Looking your reply Relevant Skills and Experience D Hands-on experience in excel,worked in organised team. proficient in time-bound work completion

$155 AUD v 3 dneh
(0 Ocen)

Hi Sir, please feel free to contra cc for further details. I Would like too provide quality service with accuracy for your required format. Regards, Danish Rehman

$111 AUD v 3 dneh
(0 Ocen)
$88 AUD v 5 dneh
(0 Ocen)
$222 AUD v 3 dneh
(0 Ocen)

I have 12 years of experince in MS Excel and Data Management.

$155 AUD v 3 dneh
(0 Ocen)

Hi-Res Team, I’m a post Graduate in [login to view URL] IT and I’m full time employer as Business Strategy. I’m well versed with MS office and as I committed I can be able to submit the project on time. Relevant Skills and Experienc Več

$144 AUD v 3 dneh
(0 Ocen)

I come from a strong experience of 8 years in Software Testing with rigorous on job experience. Experience includes handling end to end Testing projects independently with detailed and structured documentation. My e Več

$155 AUD v 3 dneh
(0 Ocen)