Copy specific detail from one spreadsheet to another

**Noel2008** · 06-06-2008, 05:00 AM

Hi,

I am trying (learning) to code VBA, but need help in this exercise. I want to code a search in the spreadsheet for a specific company.

Table headings:

COMPANY_NAME /Date/Last Modified/Contact Name /Telephone /Email /Mobile

I want to run an inputbox, asking the user what company they want to retrieve. The code should then search for all the companies with the=at name, copy all the delails (copy the entire row) and open a new spreadsheet and paste in details. It should retrieve all the companies in th eoriginal list ang present them in a new sheet.

I would be grateful for any assistance in this - I'm just a beginner and apologise it this is considered trelatively simple....

Thank you ......

**StephenR** · 06-06-2008, 05:52 AM

Probably best if you attach a sample but see attachment.

**Noel2008** · 06-06-2008, 06:20 AM

Hi Stephen,

Thank you very much for your reply - thats great. But how can I search a project e.g. Search for all the people associated with the 'Wave Energy' project, copy,and paste it in to a new sheet enamed 'People' Sheet....

Thank you very much for you help -

**StephenR** · 06-06-2008, 06:36 AM

So are you saying you want to be able to search by company name, project, contact name and then copy all relevant rows to another sheet?

EDIT: cross-posted http://www.ozgrid.com/forum/showthread.php?t=93095

**Noel2008** · 06-06-2008, 06:50 AM

Yes - I want to build a form, allow the user to select how they want to search, ie.e a radio button for a Search by Company, another radio button for search by Project etc. When they click on the choice, an input box will appear, they enter, e.g. Project Name, and it pulls all the relevant data from the sheet, into a new sheet with only the relevant rows(infio) on trhat project....

**Noel2008** · 06-09-2008, 04:35 AM

HI,

In relation to the above, project - I'm am finding it difficult to:

I form with a button for 'Search Projects'.
An input box appears, asking 'What Project do you wish to retrieve?'

The problem is in teh retrieval process - it returns a blank sheet, will names the new sheet correctly, e.g. "Project A", and includes the correct headings, but no data???

Can anyone help me with this? (example attached)

Thank you,

Noel