+ Reply to Thread
Results 1 to 3 of 3

Referencing worsheet names

Hybrid View

  1. #1
    Registered User
    Join Date
    06-05-2007
    Posts
    2

    Referencing worsheet names

    Hello! - I am beating my head on my desk trying to figure this one out. Here is what I am trying to do:

    I have worksheets in my workbook that are named with number. On my first sheet however is a chart that I am referencing where for the number of the row, I want the info to go into the other worksheets.

    For instance - worksheet1 - sunday - row 3 should take info from columns in row 3 and place that info into different places in the worksheet named 3. Info in row 4 should take info from columns in row 4 and place that info into different places in the worksheet named 4.

    The reason I cannot just reference the cells is that I have some other code that is working and populates these sheets numerous times. Please let me know if you have any ideas how I can reference the worksheets based on the names by rows.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Sample spreadsheet would be useful with an example

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    06-05-2007
    Posts
    2

    Sample

    Here is a sample:

    If you see in the attachment (very basic) - Sheet Monday and Tuesday would have a button that would populate sheet 2 & 3 - Sheet 2 and 3 would have the information from Monday based on the row number corresponding with the sheet number.

    Again - super basic example! Thanks for your help!
    Attached Files Attached Files

+ 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