Cross Excel databases

I need to automate manual processes. It is about cross Excel databases including:

- I have about 10 spreadsheet and I must have all the information in one. Now I work on the main spreadsheet filling the information included in the other ones.

- Find and delete duplicates: with the same unique ID and also fulfilling different conditions (ex. same date, same ID card)

- Complete information between databases. I have information with an unique ID in the different spreadsheets and must be filled in the main spreadsheet.

- Create extra rows in the main database if the ID is found in one of the spreadsheet

- Create some fields based on conditions (ex. if 'the field first buy'='no' and the field 'fidelity card='yes' create a column with the value of the customer, in this case 'VIP customer'').

This is now a manual process and I have to do it monthly, so I need to automate (with a macro?) inserting the updated spreadsheets every month. Must be done in Excel or Access because it's the software I have avaliable. Also want to know if it's possible to do a Dashboard with some of the results.

Habilidades: Excel, Microsoft Access

Ver más: excel cross check data website, excel cross check, creating client databases excel, excel vba find value list, excel web table value, excel assign rank value based column values, excel vba case column, excel vba paste value internet explorer, excel marco website value, client databases excel, excel vba rank value, foreclosure databases excel, excel repeat sum value next row, excel vba increment value, making online databases excel

Información del empleador:
( 0 comentarios ) Spain

Nº del proyecto: #11315271

2 freelancers están ofertando el promedio de €39 para este trabajo


Greetungs of the day! I would love to assist you in the project.I have been working in excel for last 3 years creating dashboard and macros is my everyday task. I can assure you the best quality work. Would love to hea Más

€66 EUR en 3 días
(6 comentarios)

I will deliver a satisfactory job that will impress you. I crave for a chance to prove to you my worth and abilities.

€12 EUR en 1 día
(0 comentarios)
€12 EUR en 1 día
(1 comentario)