Hi rftech,
welcome to the forum.
How do you populate your column in the first place? Copy and paste, formula, VBA?
Maybe providing some sample data would help.
Hi rftech,
welcome to the forum.
How do you populate your column in the first place? Copy and paste, formula, VBA?
Maybe providing some sample data would help.
My column of data that is my starting point is a list of model #s followed by a column with a broad model description. Several model numbers can have the same description.
I don't have access the 'ACCESS' database that contains everything, I was just given an excel query form that I can select dates and customer #s to query for. The data I import also has data that contains things like: when it was brought in for repair, when it was finished, what was the complaint, and what was the fix. Occasionally someone brings in a new piece of equipment with a new model number. After I import, say a months worth of data, I need to find out if there have been any new model #s added before I start sorting and analyzing turn time and so on. If there was something added and I didn't catch it, it throws off my analyzed results.
Is that enough info or even close to what you requested?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks