+ Reply to Thread
Results 1 to 2 of 2

Cell Programming Help Needed

  1. #1
    Registered User
    Join Date
    05-06-2015
    Location
    Columbus, IN
    MS-Off Ver
    2013
    Posts
    1

    Cell Programming Help Needed

    I need some help with programming a cell in Excel. I have attached a sample so you can see what I am working with. What I need is a line of code for cell B1 on Sheet2. What I need it to do is read the name of the sheet that it is on (Sheet2), then go back to Sheet1 and find the row where that sheet name is listed (row 1 on Sheet1 in this case since I need the code for Sheet2). The code then needs to go to column B and the correct row (row 1 in this case) and take the text in that row/column (B1) and insert the text in cell B1 on Sheet2.

    Then I will do the same thing for Sheet3-Sheet5. So the code will read the name of each sheet, go to Sheet1 and then go to B3, B4 or B5 and pull the text from those cells into B1 of each respective sheet.

    I have only managed to get the cell to read and display the name of the sheet that it is on and I'm not sure what to do from there. Any help would be greatly appreciated.

    Thanks,
    Doug
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,541

    Re: Cell Programming Help Needed

    Try this.


    If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.


    If you are happy with my help, please consider clicking the add reputation button in the lower left hand corner of this post.
    Attached Files Attached Files
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

+ 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. VBA programming help needed
    By Willi Wacker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2014, 11:03 AM
  2. Conditional formatting needed for shape colour - is programming needed?
    By Farmboyuk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2012, 07:27 AM
  3. Excel/VB programming needed please!!!
    By djdownfawl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2011, 03:34 PM
  4. Pivot Table Programming Needed
    By bluelotus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2007, 05:09 AM
  5. [SOLVED] help needed with excel programming!!!
    By gem.g in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2006, 11:40 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