Find and TRansfer from another Tab in same Worksheet

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
 
D

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.
 
D

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top