Cerrado

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

ID de proyecto: #11315309

50 los freelancers están ofertando un promedio de €156 para este trabajo.

€175 EUR en 1 día
(245 comentarios)
7.5
fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Más

€147 EUR en 3 días
(68 comentarios)
6.9
maverick44000

Hi sir, I am highly skilled in Excel and VBA and I can automate the whole mentioned process for you on a click of a button. I have done same work before a few times. Please discuss. Thank you. Usman

€200 EUR en 3 días
(68 comentarios)
6.7
someka

Hi there. Yes it is also possible to create a dashboard as well as automation features. We can write the necessary VBA macros and also use the native functions to automatically transfer the data to other sheets. As bei Más

€225 EUR en 3 días
(103 comentarios)
6.7
shikhamehta

Hey, Going by the description you shared, yes this can certainly be automated using Excel macros. I am an expert in writing automation processes using Excel and have been highly rated for for the excellent quality w Más

€222 EUR en 5 días
(106 comentarios)
6.3
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Más

€200 EUR en 4 días
(120 comentarios)
6.3
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

€250 EUR en 5 días
(95 comentarios)
6.2
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Wai Más

€150 EUR en 3 días
(92 comentarios)
6.0
lukaszoz

Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA Más

€140 EUR en 10 días
(22 comentarios)
5.7
€100 EUR en 2 días
(81 comentarios)
5.9
zu02

Hi, I'll do that via Ms Access(if need with Excel automation). I'll code just you are wondering . Belove is my contact information and introducing: email zura_esartya @ [url removed, login to view] Skype zura_e I’m an Acc Más

€250 EUR en 6 días
(22 comentarios)
5.5
mail2vimalarora

Hi, I have read your project description in detail and would like to take an opportunity to work on it. Based on your requirement, I would suggest you to go ahead with MS Access as there you can have forms for data Más

€111 EUR en 7 días
(76 comentarios)
5.7
finecodervw

Hi, I intend to do this using MS Excel. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I h Más

€150 EUR en 7 días
(54 comentarios)
5.6
TonmoyRoy111

A proposal has not yet been provided

€150 EUR en 3 días
(110 comentarios)
5.4
KellogITSolution

Hello I am working with MS-Access database and VBA for the past 14 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Acce Más

€55 EUR en 3 días
(31 comentarios)
4.7
schoudhary1553

Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I had Más

€100 EUR en 1 día
(42 comentarios)
4.7
slenders13

Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, SlenDATA

€150 EUR en 5 días
(17 comentarios)
4.4
€155 EUR en 3 días
(11 comentarios)
4.2
satishtl

I have very good expertise in Excel macros and automation. I can get the data from the multiple sheets consolidated into one sheet based on the certain criteria you wanted to get them together. I have done similar co Más

€75 EUR en 3 días
(18 comentarios)
3.8
royalcalif

Hi Mr. Employer I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Access. [url removed, login to view] Price might be negotiable during Más

€180 EUR en 6 días
(12 comentarios)
3.5