+ 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
    31

    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,882

    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
    31

    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
    31

    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,882

    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
    31

    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,882

    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
    31

    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
    31

    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
    31

    Re: index sheet varies

    up........

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

    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
    31

    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,882

    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)

Similar Threads

  1. Getting the value which is varies with the time.
    By himaru in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-22-2017, 01:22 AM
  2. [SOLVED] VBA - Create New Sheets Based on Index Sheet Cell Values with Link to Index Sheet
    By order in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-02-2017, 06:23 PM
  3. Copy tabs names to index sheet in alphabetical order
    By cjharley1450 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2015, 01:00 PM
  4. [SOLVED] 2 Column Lookup with 6 Column array Col index number is Varies Within Entire Array
    By Weasyb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-05-2015, 12:54 PM
  5. [SOLVED] Copy Data from one sheet and paste the consolidated data into another (Data Range Varies)
    By kittu55 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-13-2013, 10:02 PM
  6. Fix value in 1 cell from another that varies
    By Lewis Koh in forum Excel General
    Replies: 2
    Last Post: 07-20-2009, 01:40 AM
  7. Code that Varies
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-13-2008, 10:14 AM

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