Excel Automation Help needed
$30-250 AUD
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
ID projekta: #17796214
Več o projektu
18 freelancerjev ponuja v povprečju za $165 na tem delu
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č
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
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č
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č
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.
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
Looking your reply Relevant Skills and Experience D Hands-on experience in excel,worked in organised team. proficient in time-bound work completion
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