VBA search and retunr results - simple programming

[renangv]

Hi,

I know this is probably basic programming for some of you: -) but after spending all afternoon watching youtube videos and getting
the same error message 'For without next' and 'Cannot execute code without break' I finally give up. ;-(
I have no training or knowledge of excel apart from as a user.

PLEASE HELP!!!
ok....ill keep it simple

on sheet1 I have a search box to enter 'store number; (and a button to link to the macro).
if a match is found on sheet2 column A (sheet 2 has 5 columns) results should be displayed back on sheet1 D6,E6,F6,G6,H6
there is more than one entry for the same store on sheet 2 they all need to be displayed on sheet 1 and its not in order.

this what I've tried so far.....copying a youtube video but it was design to only return one row I need all matches to be returned....
and it didn't work anyway.

Please Login or Register  to view this content.

PS. This spread sheet is for a bank and I can't upload any of the information or onto here :-(

[sintek]

Hi renangv

Your post does not comply with Rule 3 of the Forum....

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window

[mike7952]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[sintek]

Please attach a sample workbook with a before & after scenario making sure that your desired solution is shown - mock up the results manually.

[mikerickson]

from what I can see, you need to add

Please Login or Register  to view this content.

with the rest of the dim statements. And add

Please Login or Register  to view this content.

right after the End If. Note that if there are multiple results found, the last result will overwrite the preceeding ones.

[sintek]

Perhaps this can start you off. Would be better seeing a sample file.

Please Login or Register  to view this content.

[renangv]

IMG_0478.JPGIMG_0479.JPG
i've taken some pictures of a sample as i can't upload files from this computer.

[mike7952]

You added the pics and not said anything about any of the solutions that have been given. Are the codes not working? If not what is not working?

[sintek]

Here you go...

Please Login or Register  to view this content.

[renangv]

Hi Sintek,

Thank you for your efforts.
Your spreadsheet it pretty similar to what i need,
what do i need to add in order for the previous data to clear when you search a new number. *sorry i forgot to mention this.*

Thanks this is just the initial project i will be adding on more data and more tabs as it progresses but i think this has been really helpful to start me up !

Here you go...

Please Login or Register  to view this content.

[bakerman2]

This one should cover that.

Please Login or Register  to view this content.

[sintek]

Yep, that covers it ....bakerman2 to the rescue lol

[renangv]

Yep . That is perfect :-) thanks Everyone
Thanks Sintek and Bakerman2

[sintek]

Pleasure...Thanks for rep points

[sintek]

@ bakerman2

Indicator As Boolean

Of course...Silly me.

[bakerman2]

@ renangv

You're welcome and thanks for rep+.