+ Reply to Thread
Results 1 to 13 of 13

index sheet varies

  1. #1
    Registered User
    Join Date
    10-14-2018
    Location
    turkey
    MS-Off Ver
    2016
    Posts
    20

    index sheet varies

    hi

    I have a table. In this table the name of the sheets and sheet index are written.
    1 sheet1 1
    2 sheet2 2
    3 sheet3 3
    I would like to write the following code:
    sheet2.range("a2")
    For example, number 2 varies. How can I use number 2 instead of the above table?

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,205

    Re: index sheet varies

    Do you mean something like that
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    10-14-2018
    Location
    turkey
    MS-Off Ver
    2016
    Posts
    20

    Re: index sheet varies

    I click on each row in table, index sheet goes to cell A1. The front of the sheet number is read from cell A1.i want instead under code :

    sheet3.range("e3")

    use digit 3 from cell A1.

  4. #4
    Registered User
    Join Date
    10-14-2018
    Location
    turkey
    MS-Off Ver
    2016
    Posts
    20

    Re: index sheet varies

    more explain :

    more.jpg

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,205

    Re: index sheet varies

    Can you post sample of your workbook and explain what you are trying to do exactly?

  6. #6
    Registered User
    Join Date
    10-14-2018
    Location
    turkey
    MS-Off Ver
    2016
    Posts
    20

    Re: index sheet varies

    For example, my information is as follows
    1.jpg

    I want to press the colored buttons in the column F, The value of the column e will go to its address on the sheet in the same row.
    for example by press blue button in cell f3 Like the image below.

    2.jpg

  7. #7
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,205

    Re: index sheet varies

    But as for the image attached you put the value in row 5 not in row 3 as you described
    it is better to upload the workbook to work on

  8. #8
    Registered User
    Join Date
    10-14-2018
    Location
    turkey
    MS-Off Ver
    2016
    Posts
    20

    Re: index sheet varies

    in my picture attach in sheet test value cell b5 equal 10.

  9. #9
    Registered User
    Join Date
    10-14-2018
    Location
    turkey
    MS-Off Ver
    2016
    Posts
    20

    Re: index sheet varies

    example file :
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    10-14-2018
    Location
    turkey
    MS-Off Ver
    2016
    Posts
    20

    Re: index sheet varies

    up........

  11. #11
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,205

    Re: index sheet varies

    The attachment is different from your description. Can you guide us to the final results that you are seeking to please?

  12. #12
    Registered User
    Join Date
    10-14-2018
    Location
    turkey
    MS-Off Ver
    2016
    Posts
    20

    Re: index sheet varies

    I want to transfer the amount of that row to its address.

  13. #13
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,205

    Re: index sheet varies

    The issue is not clear for me. Wait for other experts to share the topic

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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