find value,loop through 2 sheets and copy headers

**SarahPintal** · 01-22-2010, 07:44 AM

Hi guys,

Ive got most of the code going, though cant seen to get the search results to show as I want them.

I am putting in search items and running a macro to find the items on 'physical servers' WS, copying the header in that WS and the entire line the match appears on, though I cannot get it to do this.... it is really causing me stress

Then next part that is working is the items that return false are showing up on the results page - this is expected and what i want it to continue to do.

What I cant seem to work out also is how to run the search on the 'Virtual Server' WS also and return the results to the results WS as just like the 'physical servers' WS.

I have included some dummy data + code + the expected result on the 'Server Results' WS.

Hope you all can work out a way to make it work.

thanks in advance guys

**rwgrietveld** · 01-22-2010, 07:49 AM

Am I overlooking something

running a macro

I don't see any code / macro in your Book1.xlsx (non macro enabled)

**SarahPintal** · 01-22-2010, 08:08 AM

Oops... my bad, sorry X 10

Ive attached the proper file.

thanks

**rwgrietveld** · 01-22-2010, 08:51 AM

Can you describe what it should do.

All these offsets, searches and such make my head spin.

.. and what should this do?

Please Login or Register  to view this content.

**rwgrietveld** · 01-22-2010, 09:03 AM

Sorry, I got it. Will take me a few minutes to remake the code.

Hold your breath ....

**arthurbr** · 01-22-2010, 09:09 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**rwgrietveld** · 01-22-2010, 09:32 AM

here's my code

Please Login or Register  to view this content.

**SarahPintal** · 01-22-2010, 05:24 PM

Thanks Rwgrietveld

**SarahPintal** · 01-22-2010, 10:38 PM

Hi, thanks for your efforts, it is about 90% exactly what I wanted.

the only thing it doesnt not do is tell me which ones didnt have match...

ie: i was expecting 'ExpectedNotToBeThere' to appear under a heading 'Found only in your input data'

is that possible?

**rwgrietveld** · 01-23-2010, 07:58 AM

For simplification add this code at the Bottom (between Next and End Sub)

Please Login or Register  to view this content.

The code can be resized enormously, but now the code is very readable as there are three logical steps.

I would make an addition routine (Function) for the search that takes the SearchRange and the FindRange as an input.

Maybe this is good exercise for yourself ...

**SarahPintal** · 01-24-2010, 04:25 AM

Thanks

It works though it seems it is only looking into the rang3( and not range2 as well.

Ive been trying to work out how to do this for the past 2 hours so i didnt have to ask, though ive failed

can you assist one last time?

**SarahPintal** · 01-24-2010, 05:01 PM

hi guys,

Can someone please help,

I need the below code to be extended to also look in FindRng2 not much FindRng3.

Please Login or Register  to view this content.

**rwgrietveld** · 01-24-2010, 06:18 PM

t works though it seems it is only looking into the rang3( and not range2 as well.

Ive been trying to work out how to do this for the past 2 hours so i didnt have to ask, though ive failed

Why not copy the code again and change range2 into range3.

Please Login or Register  to view this content.

I know the code can be made more efficient, but not it is readable. I'll rework it tomorrow, so it's more compact. It's a sunday for me as well after all...

**SarahPintal** · 01-24-2010, 07:10 PM

Hi,

Hope your having a good Sunday

food for thought for tomorrow - the code you just gave checks range2 against the the inputted data and if not there write the line, then goes and checks range3 and does the same.

This means that if there is a match in range2 and not in range3 (and vice versa) the line will still copy and make it look like its not in either range.

It is is supposed to check both ranges and if it does not appear in either then write the line.

hope i made it a lil clearer

thanks in advance,

have a nice sunday

**SarahPintal** · 01-24-2010, 08:13 PM

Hi all,

This almost works though it will only finds and copies 1 of the"'NOT FOUND"

in the attached workbook in there post there are 2 'NOT FOUND' when you click the button though it only copies the last. If it could find both then its completed.

I think it just need a loop though ive been trying and cant get the result.

**SarahPintal** · 01-25-2010, 12:48 AM

Worked it out - took a long time but did it.

Please Login or Register  to view this content.

I know it isnt hard code though I think im getting better thanks to everyones help on this forum. Your help and time is always very much appreciated

find value,loop through 2 sheets and copy headers

LinkBack

Thread Tools

Rate This Thread

Display

find value,loop through 2 sheets and copy headers

Re: Cant seem to get this code to work - over my head

Re: Cant seem to get this code to work - over my head

Re: Cant seem to get this code to work - over my head

Re: Cant seem to get this code to work - over my head

Re: Cant seem to get this code to work - over my head

Re: Cant seem to get this code to work - over my head

Re: find value,loop through 2 cheets and copy headers

Re: find value,loop through 2 cheets and copy headers

Re: find value,loop through 2 cheets and copy headers

Re: find value,loop through 2 cheets and copy headers

Re: find value,loop through 2 sheets and copy headers

Re: find value,loop through 2 sheets and copy headers

Re: find value,loop through 2 sheets and copy headers

Re: find value,loop through 2 sheets and copy headers

Re: find value,loop through 2 sheets and copy headers

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions