Hi Can u please attach a sample sheet...
Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Sat, Jul 25, 2009 at 1:22 AM, Telenochek <elet.mir...@gmail.com> wrote: > > Hello everyone, > > I have a worksheet that calculates system performance on Sheet1 based > on electronic components, whose data is located in other Sheets > (sheets 2,3...n). > > I would like to have the user simply select a component from another > sheet to place in a system, and have it import the rest of the data > automatically. For example, suppose the user wants place an amplifier5 > (located in "Amplifiers" sheet) instead of the resistor3 (located in > the "Resistors" sheet) in my system. > > I'm wondering if there's a simple way to extract the source address > from a formula. > > For example, suppose the user types the equals sign "=" and then goes > to Amplifiers sheet and selects the name of the amplifier (located in > E1 cell, where E2:E20) contain data relevant to this component. > > Now the formula for cell A1is: = Amplifiers!E1 > How can I extract this address, so that I can automatically fill data > from Amplifiers!E2:E20. > > CELL("address", A1) does not work, since it will return A1, not > Amplifiers!E1 > > Do I have to write a macro with an InputBox, or is there an easier > way? > Assume a non-technical user, we don't want the user to type in =CELL > ("address, etc..) > > Thanks > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---