LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 44
Default Insert text from another workbook based on criteria

Hi there! I would like to find out how I can insert text from another
workbook. I would like to insert the "Date of Birth" and "Client Status"
from another workbook into my Current Workbook. The only difference in the
data between my current workbook and another workbook is the "Paid" amounts
and date of each payment/number of payments per client.

Current Workbook

Client ID Number Client Name Date of Birth Client Status
Paid
88888888 Smith, Jane
100.05
99999999 Smith, John
75.00


Another Workbook

Client ID Number Client Name Date of Birth Client Status
Paid
88888888 Smith, Jane October 9, 1952 Open
35.00
99999999 Smith, John August 1, 1970 Open
80 .00

Could someone help me? Your response would be so helpful, Thank you. :)
 
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
Separating a List onto multiple worksheets in the same workbook based off 1 criteria DMRbaxter Excel Worksheet Functions 6 April 19th 07 01:36 PM
Creating function to insert data based on criteria Tami Excel Worksheet Functions 1 August 18th 06 10:42 PM
Insert text in Cell A1 based on keyword criteria [email protected] Charts and Charting in Excel 1 June 13th 06 04:56 PM
Insert Criteria Based on Current Month Mark Jackson Excel Worksheet Functions 3 May 19th 06 03:16 PM
Insert text based on date honyacker Excel Discussion (Misc queries) 2 January 30th 06 09:06 PM


All times are GMT +1. The time now is 05:25 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"