+ Reply to Thread
Results 1 to 17 of 17

Command cell from another cell

  1. #1
    Registered User
    Join Date
    04-24-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    27

    Exclamation Command cell from another cell

    Hello everyone!

    I just registered in this forum, I'm sorry I didn't make an introduction yet but ill leave here a little intro.

    I never used Excel before, only to see some data or ultra basic things. Now I'm creating a excel system to control sales as a performance guide.

    I need help in a little question.

    Obviously in excel we can get a value from another cell... if I want to get a value from A1 i might just do in a random cell =A1, so far so good...

    My question here is... Is there a opposite way?

    Can I "write" in A1 from a random cell?

    And more important... Using formulas only?



    I'm sorry to come here and just ask, don't want to be rude, i'm just a little desperate.

    Thank you in advance.

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Command cell from another cell

    Hi, you can't put random contents into a cell, you are telling the cell what you would like it to display.

    Why would you want random values in cells?

    I think we need a bit more detail or better still an example spreadsheet displaying what you would like to see

  3. #3
    Registered User
    Join Date
    04-24-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    27

    Re: Command cell from another cell

    No no friend... No random value.

    I was trying to say "pick a random cell" or "no specific cell".

    Basically... You can read a cell from another cell, but can you "write" in a cell from another cell?

  4. #4
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Command cell from another cell

    If you have the value =A1 placed into B1 and then typed into A1 you will see the contents of B1 change. Is this what you are querying?

  5. #5
    Registered User
    Join Date
    04-24-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    27

    Re: Command cell from another cell

    I'm asking for a way (if there is any) to command in B1 to change a value in A1.5wglrn.jpg

    EDITED: A1 has no values, what I want it to create a formula that when added to anywhere in the spreadsheet (In this image we can see is B1), it will add a value to A1. What I want resembles a little object oriented programming.
    Last edited by ExNub; 04-24-2017 at 11:28 AM.

  6. #6
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Command cell from another cell

    Put this in A1
    =IF(C1<>"",C1,"")
    and type something in C1
    Teach me Excel VBA

  7. #7
    Registered User
    Join Date
    04-24-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    27

    Re: Command cell from another cell

    Quote Originally Posted by ImranBhatti View Post
    Put this in A1


    and type something in C1
    This is almost the same as the =C1

    What I need is to add data to A1 from any other cell, some formula that can point the cell and remote edit her.

  8. #8
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Command cell from another cell

    you mean: B1: =A(randomnumber) ?

  9. #9
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Command cell from another cell

    O now I understand
    "You want not to enter any formula in A1 and it should be populate by populating any other cell."

  10. #10
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Command cell from another cell

    you can try eg. =INDIRECT("A"&RANDBETWEEN(1,10))
    where your data is in A1: A10

    or if you want randomize A1:E10 you can try: =INDIRECT(CHAR(RANDBETWEEN(65,69))&RANDBETWEEN(1,10))
    Last edited by sandy666; 04-24-2017 at 12:47 PM.

  11. #11
    Registered User
    Join Date
    04-24-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    27

    Re: Command cell from another cell

    Sorry for my late response


    This is not what I need but it might become handy for something else, thank you!
    =INDIRECT("A"&RANDBETWEEN(1,10))
    This:
    Quote Originally Posted by ImranBhatti View Post
    O now I understand
    "You want not to enter any formula in A1 and it should be populate by populating any other cell."
    Correct! Sorry If I was confusing explaining :D
    If you can translate that into a formula... I've been struggling with this for a while and and can't find anything resembling this in google or anyplace in the web.

  12. #12
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Command cell from another cell

    To answer open way: No, you can't achieve this by a formula.
    but changes in a sheet can be reflected in a cell.

    See how such sample code:
    Please Login or Register  to view this content.
    works (see the code by rightclicking a tab with sheet name and select show code from pop-up menu).
    Attached Files Attached Files
    Best Regards,

    Kaper

  13. #13
    Registered User
    Join Date
    04-24-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    27

    Re: Command cell from another cell

    Quote Originally Posted by Kaper View Post
    To answer open way: No, you can't achieve this by a formula.
    but changes in a sheet can be reflected in a cell.

    See how such sample code:
    Please Login or Register  to view this content.
    works (see the code by rightclicking a tab with sheet name and select show code from pop-up menu).
    That's what I was afraid I was trying to run away from VBA. I belive I can modify that code to blend in to what I need. Thank you Kaper and everyone else who was here to help.

  14. #14
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,609

    Re: Command cell from another cell

    Well, you can think of a cell referring not to another cell, but to a name (Ctrl+F3) . And the name can be not referring to a cell, but be calculated as a formula. But basically - it is still a cell containing
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    so not too far from simple
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  15. #15
    Registered User
    Join Date
    04-24-2017
    Location
    Portugal
    MS-Off Ver
    2016
    Posts
    27

    Re: Command cell from another cell

    Thank you everyone! I have my problem solved! I found another way to work things out. You can close this thread!

  16. #16
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Command cell from another cell

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  17. #17
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Command cell from another cell

    Quote Originally Posted by ExNub View Post
    Thank you everyone! I have my problem solved! I found another way to work things out. You can close this thread!

    and would you like to share that work around with the community?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] command button to fill color in cell based on text in another cell
    By gavwalsh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2014, 03:10 AM
  2. IF Command based on cell or IF/AND command -HELP needed
    By lsafri in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-30-2012, 08:42 AM
  3. Nest SUM command with a command to make result cell blank
    By dwest185 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2011, 08:10 PM
  4. Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  6. Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. Replies: 1
    Last Post: 06-23-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1