Find and TRansfer from another Tab in same Worksheet

  • Thread starter Thread starter davie670
  • Start date Start date
D

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
 
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.
 
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
 
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.
 
Back
Top