[slurpee55]

I can thank Chuck Wozniacks for the essence of this. Does it via formulas.

[Zack Barresse]

Don't I get lazyness points though? I guess it's just too much work for me, open both files, copy data over, transpose, enter formulas, copy across/down, blah, blah. A good solution for formulas though. I just really wanna join the lazy club.

[slurpee55]

I'm the owner and operator of that club Zack...you, at best, are on probationary status....

[MRdNk]

Laziness is the reason I got into programming. Much easier to write an Excel Macro once, then do the same work over and over again. And it makes you look good at your job - hehe!

And why I got into OOP, especially in Access, nothing worse then writing the same bit of code over and over.

[slurpee55]

I agree entirely. I always get a small chuckle when someone wants me to do something in Excel or Access that they have tried to do and wasted hours and I can find a way to do it in 15-20 minutes.
Of course, they all think I am some sort of idiot-savant and they just put up with me....

[MRdNk]

I moved to another team at work, and managed to reduce something that used to take someone all day to do, to about 30 minutes work including understanding the files, with a simple vlookup.

Yeah, I get the same thing, I'm now the "Excel Guy" in my office, even with an additional full IT support team.

[slurpee55]

Well, most of the people where I work think Excel is a simple-to-set up but annoying-to-use version of the tables in Word....

[MRdNk]

People in my workplace - i.e. Managers, think that Excel is better then having an Access database. It annoys me so much!

Especially as so much data is out-of-date, and we have a multitude of Excel sheets with different bits of data, all referring back to one reference point. - and annoy everyone else at the same time.

[whats_this]

Zack, I installed the add-in and I saw the toolbar. I set the file location, no problem. I also opened it using the third button, all's well. I assume this is supposed to be the master database file I use to store all the info, right?

Now for the "search for cert" button, it opens a window containing a button to browse for "file location". Which file is that? What's the difference between that file and the file I choose from the "set file location" button? Are they the same?

The other thing is that in my real file, the locations of the columns are different from the example file I posted here. Does the add-in take that into account? Because I tried searching for an employee number there and it didn't work. Or did I do something wrong?


P.S. I'm going on a trip for a couple of days or so (against my will ) and will report back afterwards , please don't close this thread! Not when I'm one step close to my salvation!

[Zack Barresse]

Yes, the columns do make a BIG difference. Hence problems if you post data that is different from the "real" file.

The "File Location" on the userform that pops up with the first button ("SEARCH FOR CERT") is just informational, but allows you to change it with the browse button. Basically a final check, so-to-speak. The data structure is very important.

The thread will not be closed. I'm leaving this afternoon for a few days myself. If you get back and need questions answered, there are many capable hands here to help you. Post back when you can.

[whats_this]

Ah, finally back. Sorry for the delay.

My question Zack (or anyone): since the columns in my file are located differently from what's specified in the add-in, is there a way for me to edit the add-in?

[slurpee55]

I'm sure it is editable. Why don't you post the correct information - worksheet names and correct columns - and Zack or someone else can re-write it.

[whats_this]

Thanks, I need all the hope I can get!

In my file, the certificate number is in column A. Columns B to D have some other information, then the employee numbers are in columns E and F. Just to recap, can we edit this so the code would scour through E & F for employee numbers then copy the certificate number that's in column A?


P.S. Will have to go again on a business trip (this time with a really annoying person ). Will be back around Saturday or Sunday.

[Zack Barresse]

Start on what row? 2? Not enough info. And why two columns? This is totally different from what you showed us!! Ugh. These are the nightmares of forum type format communication(s).

I'll assume data starts on row 2, and to search both columns E and F. Add-in updated and attached.

[whats_this]

bomb #21:

"Don't let it. If an idiot can get to grips with the rudiments of VBA (and I have ), so can you."

The problem is when someone who doesn't know those basics (like me and a gazillion others) is looking for merely a formula or a simple solution, yet all we find on the net is this VBA gibberish. You develop phobias after a while.