Restricting search field

[sarah1]

Hi All,
How can I restrict the search field, instead of following statement:

How can I say search only in 10 columns to right. Although I have data in more than 10 columns.

Thanks for help
Sarah

[Norie]

Sarah

10 columns to the right of what?

[GC Excel]

Hi sarah,
If I understand correctly, if you want to look at the 10th column to the right of the active cell, try this :

Please Login or Register  to view this content.

[sarah1]

Norie,
It would be of sheet1 from cell a1
Thanks
Sarah

[sarah1]

Hi GC,
I like to look in 10 coulmns starting from a1
Thanks
Sarah

[GC Excel]

Then you must use RESIZE :

Please Login or Register  to view this content.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[sarah1]

Norie and GC,

I have this code taken from this site and changed a bit to suite my workbook.
My intent is to make this code work faster, it takes long time to put the searched entry in sheet2.
Please look into it if you can make it faster. I thought by restricting the search fields it might be faster, but it is not.

[GC Excel]

Can you share your file (or part of it) with example of expected results ?

[Norie]

I'm pretty sure the line of code you posted previously isn't slowing things down, all it does is find the last column of data in row 1.

What exactly is the code meant to do?

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[sarah1]

All it does is find the id and copy the whole row in sheet2.
then in sheet2 I have to edit and put it back through the 'putback' code.
I cannot put the data online.
Sarah

[Norie]

Sarah

Have you tried using a filter to find all the rows with the ID and then copying them to Sheet2?

[sarah1]

Norie,
Can it be bacause of the file size? I have about 5 K rows on this sheet.
It takes good 30 sec. to put the searched row in sheet 2.
I cannot put data online.
Thanks
Sarah

[sarah1]

Norie,
It is only one row it brings to sheet2 with the specific ID it looks in col. 1 and 2
I did not try filtering.
Thanks
Sarah

[Norie]

Sarah

If it's only one row why are you looping?

Where are you looking for the ID?

Is it only ever in columns 1 to 2?

[sarah1]

Norie,
My Ids are only in col 1 & 2. Actually I can live with only col. 1 too.
As I said I took this code from this site. If I do not need looping how would that be?
please note that it has to put back too, after I edit.
Thank you
Sarah

[Norie]

Why do you need to move the row?

[sarah1]

Norie,
The ID is is col1. When it finds the ID, it copies the whole row to Sheet2 where I makes changes and the put back code puts it back in its place in sheet1
Thanks
Sarah

[sarah1]

I need to edit/add info. and put it back.

[sarah1]

Hi Norie,
The loop was taking all that time. Once I got rid of it, it works lot faster.
Thanks anyway.
Sarah