 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006Extract Value from another worksheet
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 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  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email >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 [quoted text clipped - 5 lines] > Thank you, > Harsh 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 > Not sure what you mean by 'parameters' > In Sheet1 the formula =Sheet2!A1 returns the value from A1 on Sheet2 [quoted text clipped - 19 lines] > > Thank you, > > Harsh 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. SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) > 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 [quoted text clipped - 28 lines] > > > Thank you, > > > Harsh 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. > 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, [quoted text clipped - 52 lines] > > > > Thank you, > > > > Harsh 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? SignatureRegards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) 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. > 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 [quoted text clipped - 8 lines] > ---------- > It's easier to beg forgiveness than ask permission :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.