Import text from another excel workbook

15 pts.
Tags:
Excel 2003
Excel functions
Excel macros
Excel workbooks
Macros
I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to retrive data from wb1. I want to search wb1 to find the first action that takes place in the current month and import the action text into a cell in wb2. Is this possible
ASKED: November 13, 2008  1:54 PM
UPDATED: November 13, 2008  2:15 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Use the VLOOKUP function. Maybe this <a href=”http://www.cpearson.com/excel/TablesAndLookups.aspx”>Tables & Lookups tutorial</a> will help.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following