Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default How to seperate people


Hello, I have several sheets in a workbook with husband & wife
In the first example how would i extract all of Mrs Hilary Johnston's
details so that I could paste special link them into a new spreadsheet

and then do the same for Mr David McCarley?
Thank you
--
Martin
©¿©¬






Com Dist. Family First Name/s Address
Town Post Code


H 3 Johnstone Mr & Mrs J. John & Hilary Downshire Gardens
Carrickfergus BT

D 12 McCarley Mr & Mrs D. David & Muriel Island Road
Ballycarry BT


  #2   Report Post  
Junior Member
 
Posts: 3
Default

"TÃ*i sản giá trị nhất của công ty bạn chÃ*nh lÃ* cách mÃ* khách hÃ*ng biết đến nó."
Brian Tracy
  #3   Report Post  
Junior Member
 
Posts: 3
Default

"[/b]BÃ* quyết của sá»± thÃ*nh công nếu có - đó lÃ* khả năng tá»± đặt mình vÃ*o địa vị ngÆ°á»i khác vÃ* xem xét sá»± váº*t vừa theo quan Ä‘iểm của há» vừa theo quan Ä‘iểm của mình."
Henry Ford
Reply
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
add two cells from seperate work sheets into a cell on seperate wo lar Excel Worksheet Functions 6 April 27th 10 06:54 PM
How seperate text with comma in a cell into seperate rows geniusideas Excel Programming 3 May 27th 09 08:10 AM
How do I have seperate headers for seperate pages in 1 worksheet? JessicaDL Excel Discussion (Misc queries) 1 February 22nd 08 08:14 PM
How do I seperate a full name field out into three seperate columns? Rod Excel Worksheet Functions 3 October 31st 06 09:06 PM
seperate first 2 lines of column in seperate columns in same row Glynnhamer Excel Discussion (Misc queries) 2 October 9th 06 04:23 AM


All times are GMT +1. The time now is 03:47 PM.

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

About Us

"It's about Microsoft Excel"