Excel Automation Help needed

Zaprto Objavljeno pred 5 letoma/leti Plačilo ob prevzemu
Zaprto Plačilo ob prevzemu

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

Excel

ID projekta: #17796214

Več o projektu

18 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

18 freelancerjev ponuja v povprečju za $165 na tem delu

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 Več

$250 AUD v 6 dneh
(505 ocen)
8.4
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 Več

$200 AUD v 3 dneh
(36 ocen)
6.7
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 Več

$160 AUD v 3 dneh
(49 ocen)
6.1
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 v 3 dneh
(84 ocen)
5.8
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 Več

$120 AUD v 3 dneh
(107 ocen)
5.9
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 Več

$150 AUD v 3 dneh
(76 ocen)
5.4
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 Več

$201 AUD v 3 dneh
(8 ocen)
3.9
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 v 3 dneh
(0 ocen)
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 v 3 dneh
(0 ocen)
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 v 3 dneh
(0 ocen)
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 v 3 dneh
(0 ocen)
0.0
sajeevsasi

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

$155 AUD v 3 dneh
(0 ocen)
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 Več

$155 AUD v 3 dneh
(0 ocen)
0.0