Data search

**Aretradeser** · 02-12-2014, 04:56 PM

In a sheet I have data in 13 columns, each with their corresponding titles, from "A1" to "M1". Through a code search is made throughout the leaf, from the data entered in the InputBox. If found, copy Sheet2 all the rows where the search data are, as often as apareza it. I would like to modify this code so that:
1 -. Searching only be done in the "G" column.
2 - when copying (in Sheet2) of the rows where the data found,. Further in cell "C1" of that same sheet, I copy the data searched (the previously entered in the InputBox).

The code I use is as follows:

HTML Code:

thanks.

**HaHoBe** · 02-13-2014, 01:11 AM

Hi, Aretradeser,

1 -. Searching only be done in the "G" column.

Please Login or Register  to view this content.

These commands search in the entire sheet due to using Cells. You might like to restrict it to be Column("G:G") in order to find the last row in Column G and omit uColumna as you restruct that to Column G

Please Login or Register  to view this content.

sets the range which should be modified to read

Please Login or Register  to view this content.

2 - when copying (in Sheet2) of the rows where the data found,. Further in cell "C1" of that same sheet, I copy the data searched (the previously entered in the InputBox).

You must add another parameter to the Procedure containing the contents of the InputBox or make that a local/global variable in order to make the contents available for inserting into cells in another procedure.

Ciao,
Holger

**bsalv** · 02-13-2014, 01:28 AM

Please Login or Register  to view this content.

**Aretradeser** · 02-13-2014, 06:41 PM

Thanks HaHoBe and bsalv. Both codes work well, but are incomplete. Foul copy the code that allows the cell "C1", the data to search for the entered in the InputBox.

**HaHoBe** · 02-15-2014, 08:41 AM

Hi, Aretradeser,

Foul copy the code that allows the cell "C1", the data to search for the entered in the InputBox.

If you didn´t change the procedure as suggested it´s what I would the result to be like.

Ciao,
Holger

**Aretradeser** · 02-15-2014, 02:54 PM

I have not understood anything.
thanks

Data search

LinkBack

Thread Tools

Rate This Thread

Display

Data search

Re: Data search

Re: Data search

Re: Data search

Re: Data search

Re: Data search

Thread Information

Users Browsing this Thread

Similar Threads

Match data and find data following search several search criterias

Search Box to Search and Display Data

[SOLVED] type in a search tab and search the data in another tab(and Delete)

[SOLVED] Match search terms, and add data in next column. Multi search problem.

search header name and match data in row and hight light unmatch data in colour

Bookmarks

Bookmarks

Posting Permissions