Do some Excel Work -- 2

Closed

The project goal is to consolidate different files of the same microsoft spreadsheet into a single consolidated spreadsheet.

The scenario will be two tools and two kind of target users:

- XLS Form to be filled by approx 100 users twice a year;

- Microsoft XLS with a macro that would fetch all the filled forms at a specific moment and consolidate data into a single new tab/spreadsheet; this xls will be used by no more than 4 users;

For mainteinability, the consolidation logic must be located at the spreadsheet and not a various XLS forms (spread for more than 100 people). It must comprises of:

1. Provide a button/trigger to start the consolidation;

2. when clicked, asked user to inform a directory to scan ms xls forms documents;

3. when submited, create a new work-sheet at the same spreadsheet having the current date (DDMMYYY_HHMM) into its name;

3. the algorithm must scan this directory and all subdirectories and, for each XLS found it must bring data to the target worksheet following certain rules:

a. data are those located in green or yellow cells; all of them must be consolidated at the target consolidation spreadsheet;

a. each form will fill in a new line at the worksheet;

b. each field (only form fields) will be a column at the spreadsheet;

c. column name must be consistent with form information.

d. form fields:

- text type: text must be filled at corresponding target worksheet cell;

- selection list: the corresponding value (not label) must be filled at corresponding target worksheet cell;

- selection list (Yes/No): 0 or 1 must be filled at the corresponding target worksheet cell;

Additional scope:

- lock the forms cell that aren´t destinated for input (all, except yellow);

- lock the entire form spreadsheet and allow input only in yellow fields (no changes in layout as well);

- make the spreadsheet printable in A4 format (all content must be able to be read).

Skills: Data Processing, Excel

See more: tab scope, microsoft excel spread sheet, logic algorithm, microsoft at work, excel scenario, fill spread sheet with data, fill in spread sheet, fill in a spread, fill in a spread sheet with, excel tools, excel project 2/2, do some excel work 2, Do some Excel Work -- 2, d printable, create excel worksheet, spread sheet fill, data fetch spreadsheet, scan excel data, additional work scope, create user forms excel, lock specific cell, excel sheet consolidate, excel macro read data files, additional work scope work, excel selection list

Project ID: #6131581

22 freelancers are bidding on average $31 for this job

zExcel

A proposal has not yet been provided

$83 USD in 1 day
(88 Reviews)
6.3
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement,budget and I can start to get this done with required qua More

$14 USD in 1 day
(56 Reviews)
5.6
aarifakhtar

Hi: Please check my profile page to know more about my experience in Excel macros. I have 100% completion rate and 5-star feedback on projects. Please connect with me to discuss more.

$77 USD in 3 days
(20 Reviews)
4.7
gillian1607

A proposal has not yet been provided

$55 USD in 1 day
(10 Reviews)
4.4
MasterExcel

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high More

$24 USD in 1 day
(12 Reviews)
3.3
dank111

Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can do this Excel project for you. Since this job involves macros and/or creation of the data input form, I am bidding a little higher More

$60 USD in 3 days
(4 Reviews)
1.9
ssviatlana

Hello! I worked as an analyst in several retail companies for over 10 years.I have extensive experience in software development and automation using Excel, VBA and Microsoft Office Products. I can work with data bu More

$25 USD in 3 days
(1 Review)
1.6
Shamim96

Dear Sir, I am very much interest to your job that is “Do some Excel Work -- 2”. I have a lot of experiences in Visual Basic appilcation for excel, internet research, data scraping, internet marketing, social marke More

$20 USD in 1 day
(2 Reviews)
1.4
ConradGillard

Hi there! My name is Conrad Gillard and I would like to help you with your spreadsheet project. I have extensive experience with VBA programming to automate data processing, and I am confident that I can develop the More

$10 USD in 1 day
(2 Reviews)
1.1
abacusfreelance

Hello - I can create this consolidation XLS for you. I'm trying to be awarded my second project, so my bid is very affordable as you can see. I'm a Microsoft Excel specialist and VBA programmer. Choose me if you want t More

$15 USD in 3 days
(1 Review)
1.1
bilalhaider93

A proposal has not yet been provided

$15 USD in 1 day
(2 Reviews)
1.0
Benlavi1990

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
afyrosli

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
hasee7

i am a partly qualified Charted institute of management accountant and i am able to do accounting works until report writing and decision making through costing calculation.

$20 USD in 1 day
(0 Reviews)
0.0
nagarjunchoudary

I have a vast knowledge in the field of business and related areas. I am a time conscious person who is able to submit work before the deadline set. I have a guarantee provision of non-plagiarized work at all the time. More

$25 USD in 1 day
(0 Reviews)
0.0
Ecologistu

Propunerea nu a fost încă furnizată

$25 USD in 3 days
(0 Reviews)
0.0
Gikomi

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
GNOURH

Aucune proposition n'a encore été fournie.

$25 USD in 3 days
(0 Reviews)
0.0
WeirdMix

hello!!! I have very good experience in this type of consolidation projects. Let me help you!!! greetings

$30 USD in 2 days
(0 Reviews)
0.0
pbankar

Hi, I have worked on such projects for few of clients and also worked on Excel macros, pivot tables, data filter, conditional formatting, vlookup, etc. I would like to work on this assignment. Looking forward for y More

$25 USD in 1 day
(0 Reviews)
0.0