Search for info and copy found info to specific cells

Hi,

First let me say that this is my first attempt at programming in Excel and any programming experience I have is in RPG so it’s not really helping me through this.

To give a little context: The team I work with have finally become fed up with the shear number of business cards from external companies we have floating around and we want to put together a quick and dirty repository for the contact details. Along with this I was going to include external company’s information so we can quickly see what services/software they provide to use.

What I’m looking at is sheet containing individual’s information, one to hold company info, a main sheet to permit searches on people with the results displayed on this sheet and an additional sheet for searching on a company displaying the company details and a list of contacts (obtained from the sheet that holds individuals data) we have at that company.

Well, I thought ‘I have some programming knowledge, won’t take long’ – seems my knowledge and Google have both failed me….


I’m asking for help with the initial search for the individuals as I think I can use and modify code for that to other areas of the spreadsheet. At the moment the code I have finds the record and enters only the first name into the specific results cell, I need to retrieve all the individuals information from the search (each individual has a single row with cells A-N used) and enter them into the appropriate cells and I also would like to accommodate multiple search results.

I’d like to change the ‘for’ loop in the code so it doesn’t search each sheet just whichever is specified in the code.

Below is the embarrassing attempt I have made:

Please Login or Register  to view this content.

You don't have to approach this as a RPG programmer if you don't want to. You CAN, but you don't have to. Based on your description, I would create a simple table, and then use Ctrl-F to find the guy you are looking for. Now if you are looking to make it a bit funkier, then that is a different story :-)