Find and TRansfer from another Tab in same Worksheet

[davie670]

Hi, I have a worksheet in which contact information (names/add/postcode etc)
are stored in a secondary tab. I need to update the information onto the
first (main) tab. Is there a way I can put a postcode into the postcode
column and for it to search the secondary tab, match the postcode there and
transfer full contact information to the main sheet?

Thanks in advance. David

 

[Don Guillett]

If you have one simply use a macro using FIND. If many, use
data>filter>autofilter>filter for you desire>copy>paste. Record a macro
while doing and clean it up.

 

[davie670]

Thanks for your assistance. However, as a complete novice I'm a bit lost!.
I can find an individual fixed item but don't know how to process a Macro to
search all records and find one particular address.

Thanks

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.