Closed

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

Skills: Excel

See more: 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

About the Employer:
( 0 reviews ) Bangalore, Australia

Project ID: #17796214

19 freelancers are bidding on average $162 for this job

jaylancer43

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 freelancer.com and have been featured by the freelancer community ( More

$250 AUD in 3 days
(612 Reviews)
8.3
schoudhary1553

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 More

$250 AUD in 6 days
(258 Reviews)
7.5
satishtl

- 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 More

$160 AUD in 3 days
(47 Reviews)
6.0
supper5guy

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 in 3 days
(58 Reviews)
5.1
vsprybhanu

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 More

$120 AUD in 3 days
(45 Reviews)
4.7
chintuag

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 More

$201 AUD in 3 days
(6 Reviews)
3.8
paulodayto08

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 More

$150 AUD in 3 days
(7 Reviews)
2.8
rodrigomatias

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 in 3 days
(0 Reviews)
0.0
priyankaasinghal

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 in 3 days
(0 Reviews)
0.0
$111 AUD in 5 days
(0 Reviews)
0.0
GopalJp

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 More

$200 AUD in 3 days
(0 Reviews)
0.0
keyan4

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 in 3 days
(0 Reviews)
0.0
dhokchaule

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 in 3 days
(0 Reviews)
0.0
danireh

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 in 3 days
(0 Reviews)
0.0
$88 AUD in 5 days
(0 Reviews)
0.0
$222 AUD in 3 days
(0 Reviews)
0.0
sajeevsasi

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

$155 AUD in 3 days
(0 Reviews)
0.0
ssivaraj93

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 More

$144 AUD in 3 days
(0 Reviews)
0.0
moksha19

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 More

$155 AUD in 3 days
(0 Reviews)
0.0