I have a column of data that is my starting point of info. occasionally the new items are added to the source I pull data from. I need to compare the old to the new, insert a row and the new item. What is the best way to do that. I have been trying different formulas and stuff all day. Anyone have some ideas?
Thanks
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?
Hmm. Someone will probably be able to come up with a clever macro. My approach would be this:
Before updating/refreshing the query that pulls the values into Excel, copy the existing list of model #s and paste them onto another sheet with Paste Special - Values. Give that list a range name, for example OldList.
Then run your query on your original sheet to refresh your data.
Insert a column next to the model# and use a formula like this to see if a model number is new (i.e. can not be found in OldList)
=IF(ISNA(MATCH(A1,OldList,0)),"new","")
Now you see the new model numbers flagged by the inserted column.
Alternatively, you could use conditional formatting to highlight new entries. Use conditional formatting with "Formula Is" and use a formula like
=ISNA(MATCH(A5,oldList,0))
hth
Last edited by teylyn; 03-14-2010 at 09:53 PM.
Thanks Very much,
This evening I was thinking if there was some way to combine the formula macro thing. I will play with what you gave me. I Really appreciate it. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks