Im having a real problem at work that could be solved with the next example.
My paint company sells 3 different paint products cars manufacturers and importers around the world. Note: Red, blue and green paints costs $10, $20 and $35 USD per hour respectively.
I’ve created a spreadsheet in excel that keeps track of my customers history, allowing me to see their status (active, interested, inactive) and last comments regarding the last contact date (see document attached). Note: Active means working on the project, interested means negotiating and Inactive means nothing.
Considering that my list has increased with too many contacts and that the complex formulas in my spreadsheet is making my document too slow, I’ve decided to migrate to Access, considering its robust nature.
I am trying to export the information to Access without losing info. My problem is that my excel list has too many columns, considering the several dates build initially to keep the history of my clients. I need some advice on to how to migrate my spreadsheet info while optimizing without losing any info.
Note: It is worth mentioning that I use my current spreadsheet to see my active clientes and interested clients in dynamic tables in two separate tabs(nos in the excel included).
Ill appreacite very much your valuable help