Results 1 to 6 of 6

Copy Cell (Only Value) to different Sheet's Cell

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2014
    Location
    TX
    MS-Off Ver
    Excel 2007
    Posts
    21

    Copy Cell (Only Value) to different Sheet's Cell

    Right now, I copy two cells on one sheet, into another sheet's two cells. That works fine. I don't want the formatting to transfer over though, just the values. Also, I don't want to be brought to the new sheet after the paste has been performed.

    Can someone offer advice please?



    Sub Defending_Blue_1()
    Sheets("Battling_Teams").Range("A2").Copy Sheets("Forecast").Range("A5")
    Sheets("Battling_Teams").Range("B3").Copy Sheets("Forecast").Range("A6")
    End Sub
    Last edited by Elieson; 07-22-2015 at 01:24 PM. Reason: Added code txt

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search for a sheet based on a cell copy to that sheet first empyt cell
    By WimpieOosthuizen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2014, 01:47 AM
  2. [SOLVED] Copy cell from 1 sheet to another sheet depending on what info is displayed in a cell
    By chilli76 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2013, 12:33 PM
  3. Replies: 2
    Last Post: 11-18-2013, 07:31 AM
  4. Replies: 2
    Last Post: 10-16-2013, 09:16 AM
  5. copy a specif cell value, find another like that in sheet copy adjacent cell and pate
    By smwaqas89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2013, 10:00 AM
  6. Replies: 0
    Last Post: 06-24-2012, 11:23 AM
  7. Replies: 13
    Last Post: 04-04-2012, 01:25 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