The seems to be a contradiction there- new info on previous sheet?- if its
new info on new sheet then you could do a vlook to see what was on the
previous sheet and what wasn't hence new
I have a bunch of companys in one spread sheet that are categorized. In the
next sheet they are alphabetized. When we get a new company in I'd like the
alpha sheet to recognized the change in the categorized sheet whewww.
e6= company name in catagorised sheet
Alpha c4 to c2000= list of comapnies already inc in aplha sheet
Where you get an N/A the that company is in the cat sheet but not the alpha
If it helps post post yes in button below
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.