+ Reply to Thread
Results 1 to 2 of 2

Copy Row 1 in every worksheet (not page) in Excel 2007

  1. #1
    Registered User
    Join Date
    01-13-2009
    Location
    Buffalo, NY
    MS-Off Ver
    Excel 2003
    Posts
    11

    Copy Row 1 in every worksheet (not page) in Excel 2007

    I am looking for a way to add the first row of my workbook to every worksheet I create. Currently Worksheet one contains the the text that I would like to automatically be added to worksheet 2, etc, even if I create a new worksheet, I would like that text added to the new worksheet.

    I have attached a copy of the file to this post. Any info would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,343

    Re: Copy Row 1 in every worksheet (not page) in Excel 2007

    1) Copy this code.
    2) Right-Click the sheet tab
    3) Select "View Code"
    4) Double-click the "ThisWorkbook" object in the project explorer
    5) Paste the code into the window that appears.
    6) Save the file as a macro-enabled .xlsm file.


    Please Login or Register  to view this content.
    Last edited by Bernie Deitrick; 05-13-2016 at 10:16 AM.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Replies: 1
    Last Post: 10-19-2015, 09:13 AM
  2. [SOLVED] Excel 2007: Copy Column to another worksheet, transpose paste
    By wendie1970 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-04-2012, 03:54 PM
  3. VBA:How to Copy Slides on Web Page To Excel Worksheet
    By JohnM3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 11:43 AM
  4. Excel 2007 Search for highlighted text and copy to another worksheet.
    By DHopgood@sms in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2010, 01:58 AM
  5. Replies: 0
    Last Post: 11-08-2007, 09:58 AM
  6. Excel 2007 copy/move worksheet to another workbook
    By Hoekie@work in forum Excel General
    Replies: 0
    Last Post: 06-21-2006, 02:30 AM
  7. [SOLVED] Copy Page in 2007
    By Mark W in forum Excel General
    Replies: 0
    Last Post: 06-15-2006, 08:15 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