Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and TRansfer from another Tab in same Worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and TRansfer from another Tab in same Worksheet
If you have one simply use a macro using FIND. If many, use
datafilterautofilterfilter for you desirecopypaste. Record a macro while doing and clean it up. -- Don Guillett Microsoft MVP Excel SalesAid Software "davie670" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and TRansfer from another Tab in same Worksheet
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" wrote: If you have one simply use a macro using FIND. If many, use datafilterautofilterfilter for you desirecopypaste. Record a macro while doing and clean it up. -- Don Guillett Microsoft MVP Excel SalesAid Software "davie670" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfer data from worksheet to another | Excel Discussion (Misc queries) | |||
Trying to transfer info from one worksheet to another | Excel Worksheet Functions | |||
Look up information on one worksheet and transfer to another | Excel Discussion (Misc queries) | |||
How to find a data in Sheet1,automatic transfer to Sheet2(Excel) | Excel Discussion (Misc queries) | |||
transfer one worksheet to another worksheet without losing format. | Excel Worksheet Functions |