LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
transfer data from worksheet to another dave Excel Discussion (Misc queries) 1 September 4th 08 06:14 AM
Trying to transfer info from one worksheet to another jeffrey Excel Worksheet Functions 0 January 31st 08 02:38 PM
Look up information on one worksheet and transfer to another Colin Hayes Excel Discussion (Misc queries) 3 January 31st 08 01:43 AM
How to find a data in Sheet1,automatic transfer to Sheet2(Excel) Edmond Excel Discussion (Misc queries) 1 March 6th 07 04:38 AM
transfer one worksheet to another worksheet without losing format. TwiztidKitten Excel Worksheet Functions 1 August 18th 05 09:49 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"