Extract Value from another worksheet

H

Harsh

I have a work sheet that has parameters Mem1, Mem2 etc. I have another
Worksheet ehich has the values for these parameters e.g. Mem_rom_234g
for Mem 1 and so on.

I am looking for an excel macro that can take the value of mem from
another work sheet and replace it with the value.

Thank you,
Harsh
 
B

Bernard Liengme

Not sure what you mean by 'parameters'
In Sheet1 the formula =Sheet2!A1 returns the value from A1 on Sheet2
If the sheet name has spaces then single quotes are needed: ='Jan Data'!A1
The point-7-shoot method of making formulas is recommended

If you are speaking of named cells and they are unique to the book, then use
=Mem_rom_234g

best wishes
 
D

Dhawal

In one of the worksheets I have the cell values as Mem1, Mem2, Mem3
etc. I have to replace them with corresponding values from another
sheet.
e.g. If I have Mem1 in one of my work books and I have corresponding
value in other i need to replace Mem1 with the new value.

Thank you
Harsh
 
K

Ken Wright

Sorry but you are really going to have to be a bit clearer on what you have
and what you are trying to do, eg Mem1, Mem2, are these range names, headers,
row titles or what....

Ditto, the data you wish to replace them with.

Also, your example lists Mem1 in your first workbook andf then you refer to
a Mem 1 in your other workboook - These are not the same, albeit that could
have just been a typo.

Are you looking to put in links from one workbook to another to pull these
values in, or are you just looking for a one time global find and replace.

The more effort and detail that is put into the question, the more specific
the replies can be.
 
D

Dhawal

These are the row titles. I have to replace them with another row title
from the other work sheet.
Mem1 was a typo, both are same.
I can send you the worksheet.
 
K

Ken Wright

Row Title? Do you mean a Row header? if so and you want to replace one
header with another, do you have an Index field that you can use to match the
records, or how do you know which row on sheet2 corresponds to which row on
sheet1?
 
D

Dhawal

Yes its the row header. For the replacement, if I have Mem1 in sheet1
then I have to replace it with a word that has "1" in the first column.

E.g.

If sheet 1 has Mem1

Sheet 2 has

1 qmc_wer


then Mem1 has to be replaced by qmc_wer


Thank you.
 
Top