Results 1 to 6 of 6

Macro to copy a specific cell and paste in another cell, for all sheets in workbook

Threaded View

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    9

    Macro to copy a specific cell and paste in another cell, for all sheets in workbook

    Hi

    I have a macro that will cut and paste cell B11 to cell A13. I need it to do that for every sheet in the workbook. Can someone please help me complete this macro?

    Sub CellCopy()
    
    ' CellCopy Macro
    
    Sheets(1).Activate
    
    For Each Sheet In Sheets
    
    If Sheet.Index  1 Then
    
        Range("B11").Select
    
        Selection.Cut Destination:=Range("A13")
    
        Range("A13").Select
    
        End If
    
    Next Sheet
    
    End Sub

    FYI, I'm doing this from my phone, so it might not be formatted correctly.
    Last edited by lyoung1124; 07-17-2014 at 09:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find specific Data copy and paste into Cell Macro VBA
    By kunmateo93 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2014, 10:17 AM
  2. [SOLVED] Macro to copy and paste info into specific cell
    By janeml in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-28-2013, 03:38 PM
  3. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 AM
  4. [SOLVED] Macro - Copy and Paste to a Specific Row based on the input in a cell
    By usc1382 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2012, 05:05 PM
  5. Macro-Copy&Paste Fixed Data Ranges Into Last Empty Cell of Specific Column
    By hailnorm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2009, 10:15 PM

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