Hi
For the benefit of the Group, can you attach a sample file containing
the dummy scenario. Thanks
DILipandey
On 7/25/09, 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
>
>
>
>
>
> >
>
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
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
-~----------~----~----~----~------~----~------~--~---
