Macro to locate and go to specific data

[sandbach]

Hello

I was hoping for some help please.

I am trying to write a macro so that when i type a unique entry into cell A2 it then locates this unigue entry on my spreadsheet and scrolls down to it. So basically instead of using the find function manually using ctrl f, u just type what you are trying to find in cell A2 and it finds it. I am getting absolutely nowhere with this after downloading and adapting a number of templates. So if anybody can help i would be very grateful.

Unfortunately i dont have the spreadsheet on this computer.

Kind regards

Joe

[MaczaQ]

I hope my solution will helps

Check attached file.

Best Regards

[davegugg]

This will go to the first instance after A2 on the worksheet:

Please Login or Register  to view this content.

If not found, it re-selects A2.

[snb]

Please Login or Register  to view this content.

[sandbach]

Thank You very much for your prompt help. They all seem to work brilliantly.

But the problem is now that i have extended my workbook to include other worksheets, is it possible so that the search can be extended to these?

Once again thanks for all your help.

Joe

[snb]

Please Login or Register  to view this content.

[sandbach]

thanks for your speedy response.

it doesnt seem to be working though, is it because my worksheets are named June 2011, July 2011, August 2011 etc?

[snb]

Please Login or Register  to view this content.

[sandbach]

!! its still not working

probably because of lack of information on my part, so have attached a dummy file and hopefully it will make things clearer.

[snb]

Please Login or Register  to view this content.

[sandbach]

thanks for all your help but i still cant get it to work

ive tried tinkering to no avail and borrowing code from other macros but nothing is working


if i search for a june address it finds them but if i search for a july address nothing happens, where am i going wrong?

[davegugg]

I think if the sheet it tries to find it on is after the sheet that you type into, it will find the one on the sheet you type into (the one you typed in), and stop looking.

Does this slight modification to snb's code work?

Please Login or Register  to view this content.

[sandbach]

Hi Dave and Snb

Thanks for that, but no, it still is only picking up June's dates but not any other months on the other sheets.

Would it make it work if i put the search on a seperate page and the code was modified to disclude any items found on the search page and so automatically goes to the correct dates?

If so do you know what code that would be.

Once again thanks for all your help and perseverance!

Joe

[snb]

Please Login or Register  to view this content.

[romperstomper]

Try:

Please Login or Register  to view this content.

[sandbach]

Thats Brilliant!!!!


Thank you so much for all your help!!!!



Really appreciate it

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save