+ Reply to Thread
Results 1 to 2 of 2

Create headers in workbook based on cell references.

  1. #1
    Registered User
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    Create headers in workbook based on cell references.

    I am new to VBA & macros, so I've had little success customizing other answers to fit my needs. I'll also appreciate any answers including a simple explanation of how to implement.

    My issue:
    I have a workbook I use for listing information for construction projects. I would like to fill in the left, center, & right headers on each sheet, to reference cell info from the first sheet. Example: when I enter the Project Name in Sheet1, Cell C3 - I would like to see that Project Name appear in the center header on all sheets in the workbook.

    Do I use VBA? Macros? (not completely sure what they are, really) I'd like to use this solution on more than one workbook, right now I select all sheets and change the headers in one to reflect to all, but sometimes I change the Project information and forget to update all the headers, it gets a little messy and I'm looking for a better method.

    My worksheets are renamed - the first sheet (which has the cells I'd like to reference) is titled "P1A.Details"
    The Cells I'd like to reference are all merged - the Project Name cell is actually C3:I3
    I've attached the excel file.

    This is my first post, looking forward to finding a solution to my problem and any advice on using this forum. Thanks in advance!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Create headers in workbook based on cell references.

    Hi,

    Have a look at this solution and change it to suit your needs. Hope this helps.
    Attached Files Attached Files
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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