Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting a cell value from another spreadsheet
hi guys, I am a sort of newbie with excel.
I have 2 spreadsheets which I inherited from the previous IT manager. 1. master spreadsheet 2. Ref spreadsheet within the master spreadsheet I have few columns, one of them represent engine code. within the ref spreadsheet I have a description of that code. what I would like to do is to create a macro within the master spreadsheet that will look for the value in the ref spreadsheet and will replace the code with the value. any idea ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting a cell value from another spreadsheet
How about just using the adjacent cell to show the description. Then you could
use a =vlookup() formula: =if(a2="","",vlookup(a2,sheet2!a:b,2,false)) If you've never used =vlookup(), visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html for nice instructions. Rani wrote: hi guys, I am a sort of newbie with excel. I have 2 spreadsheets which I inherited from the previous IT manager. 1. master spreadsheet 2. Ref spreadsheet within the master spreadsheet I have few columns, one of them represent engine code. within the ref spreadsheet I have a description of that code. what I would like to do is to create a macro within the master spreadsheet that will look for the value in the ref spreadsheet and will replace the code with the value. any idea ? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting a cell value from another spreadsheet
using the adjacent cell will not help me, I need to copy the cell value in
order to create a meaningful table "Dave Peterson" wrote in message ... How about just using the adjacent cell to show the description. Then you could use a =vlookup() formula: =if(a2="","",vlookup(a2,sheet2!a:b,2,false)) If you've never used =vlookup(), visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html for nice instructions. Rani wrote: hi guys, I am a sort of newbie with excel. I have 2 spreadsheets which I inherited from the previous IT manager. 1. master spreadsheet 2. Ref spreadsheet within the master spreadsheet I have few columns, one of them represent engine code. within the ref spreadsheet I have a description of that code. what I would like to do is to create a macro within the master spreadsheet that will look for the value in the ref spreadsheet and will replace the code with the value. any idea ? -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting a cell value from another spreadsheet
Can't you copy from the helper column and paste special|Values?
Rani wrote: using the adjacent cell will not help me, I need to copy the cell value in order to create a meaningful table "Dave Peterson" wrote in message ... How about just using the adjacent cell to show the description. Then you could use a =vlookup() formula: =if(a2="","",vlookup(a2,sheet2!a:b,2,false)) If you've never used =vlookup(), visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions02.html for nice instructions. Rani wrote: hi guys, I am a sort of newbie with excel. I have 2 spreadsheets which I inherited from the previous IT manager. 1. master spreadsheet 2. Ref spreadsheet within the master spreadsheet I have few columns, one of them represent engine code. within the ref spreadsheet I have a description of that code. what I would like to do is to create a macro within the master spreadsheet that will look for the value in the ref spreadsheet and will replace the code with the value. any idea ? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a cell a search cell for a spreadsheet | Excel Worksheet Functions | |||
how do i get a cell in a spreadsheet to enter in a different cell | Excel Worksheet Functions | |||
Attach a Spreadsheet File to a Cell in Another Spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet name in a Cell | Excel Discussion (Misc queries) | |||
how do I reference a spreadsheet in a cell | Excel Worksheet Functions |