Search and Display in another sheet Using VBA and userform

**Simar** · 04-18-2013, 05:27 PM

Hello

I could not find the solution to specific problem I have.

So i have the huge database

Serial no. Name Address Employer Manager Group Qualification Yes/No

I basically want to build this setup

1. user enter the serial number,
2. check for serial number
3. Search through the database
4.Display all the columns in different sheet with specific format.

I fairly new to VBA and trying to figure this out. Hopefully any of you can provide a great insight or a sample solution

Thank you

**tehneXus** · 04-18-2013, 05:51 PM

Hi Simar,

could you provide an example workbook including the original data table and how the result should look like?

Regards

**Simar** · 04-18-2013, 06:11 PM

Originally Posted by tehneXus

Hi Simar,

could you provide an example workbook including the original data table and how the result should look like?

Regards

Hello tehneXus

Here is the example database and i have put the result in sheet 2.
Thank you for looking into it.

**tehneXus** · 04-18-2013, 07:39 PM

Hi,

check "Sheet2" here: example.xlsm

Regards

**Simar** · 04-22-2013, 11:45 AM

Perfect. Thank you

As code works very well. can you please kindly explain the code as I am having hard time understanding it. especially where you find records and paste it in the sheet.

Thank you

**tehneXus** · 04-22-2013, 02:04 PM

Hi,

please find attached the file including detailed explanation of the code.

example.xlsm

Regards

**Simar** · 04-22-2013, 03:17 PM

Thank you.

Lets say There is another column which shows Manager's Serial number
and Person enters a serial number which is of Manager's
is it possible to see a all the data of the Manager and persons underneath that Manager?

**tehneXus** · 04-22-2013, 03:35 PM

Hi,

Lets say There is another column which shows Manager's Serial number

please list --> ALL <-- the things you want the macro to do at once. I am glad to help you but I am not a big fan of never ending stories where each time one problem is solved ppl come up with other things which require the code to be rewritten ...

Generally, yes it is possible.

Regards