+ Reply to Thread
Results 1 to 3 of 3

Copy 3 cells from first sheet to all sheets

  1. #1
    Registered User
    Join Date
    11-09-2014
    Location
    iowa
    MS-Off Ver
    2010
    Posts
    8

    Question Copy 3 cells from first sheet to all sheets

    I'm sorry for posting this as I am sure it's here somewhere already. I am two searches as I type this up. However one has been running for nearly 6 mins and doesn't appear to be working.

    I am attempting to take 3 Cells worth of data A1, B1, and C1 as follows, "Name" "Type" "Address". I need to take those three words from Sheet1 and copy them to EVERY sheet in the workbook. I'm Looking to do this for roughly 120 differently named sheets. I thought I found a code to do it but all the code did was copy it and then paste it on the same sheet. so it worked for sheet 1 lol then did nothing as it looped through the other 119 sheets.

  2. #2
    Registered User
    Join Date
    11-09-2014
    Location
    iowa
    MS-Off Ver
    2010
    Posts
    8

    Re: Copy 3 cells from first sheet to all sheets

    Check this out lol
    If you hold shift and select sheet one then it the last sheet button and select that last sheet then type in the desired cells and hit enter.. it inputs that into every sheet... too easy.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Copy 3 cells from first sheet to all sheets

    Hi, reinventingthewheel,

    you didnīt post the code that wasnīt working for you.

    A working code may look like this
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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. [SOLVED] copy cells from a row in one of several sheets into another sheet based on check box.
    By SMcuthbert in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-30-2013, 08:47 AM
  2. Match cells on two sheets, copy columns to sheet 3
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2013, 09:42 PM
  3. copy 2 cells from multiple sheets to one sheet
    By StartingOut in forum Excel General
    Replies: 3
    Last Post: 02-25-2011, 12:59 PM
  4. Loop sheets then copy cells to end sheet
    By Mayweed in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-06-2011, 10:32 PM
  5. Copy filled cells from multiple sheets to 1 sheet
    By jomno69 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2010, 09:59 AM

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