Replacing cell of a column with cell of other worksheet

G

Guest

Hello,

I have the following problem.
In one sheet I have a table with imported keys from an
access table.
Now I want to replace these keys with strings that are in
a second worksheet. So eg when a cell in the 1st sheet
has value 2 it has to be replaced by eg "the second"...

How can I do this for all the cells of that column
automatically?

Thanks a lot.

Kristof
 
A

Andy Brown

Multiposted in misc + newusers + programming + worksheet.functions.
Aarrgghhhh!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Cell data entering slow! 0
WORD VBA Search and switch to advanced ... 1
External cell reference between two excel worksheets both in One Drive 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Need help modifying code 0
Fill cells based on the other 3 cells unique combination the value on the target cell 0
Copy corresponding cell in Column B if cell in A contains certain text? 1

Top