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.