+ Reply to Thread
Results 1 to 2 of 2

Copy and paste cells when worksheet is copied

  1. #1
    Registered User
    Join Date
    11-12-2015
    Location
    Washington DC
    MS-Off Ver
    2013
    Posts
    34

    Copy and paste cells when worksheet is copied

    Hi All,

    I'm trying to write a macro that will copy cell I18 and paste special values into F18 when I copy a worksheet. It is a bank reconciliation template and every month the beginning balance is always equil to the ending balance of the prior month. Each month I have to do the copy paste values manualy. i'd like to automate it.

    Cheers,

    Chuck

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Copy and paste cells when worksheet is copied

    You want a macro that copies and pastes 1 cell to another sheet and this happens once a month?
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

+ 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. Paste copied range into added worksheet
    By beancounter72213 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2014, 02:16 PM
  2. Replies: 5
    Last Post: 11-10-2014, 11:49 PM
  3. [SOLVED] Copy Row---> Add New Sheet----> Paste Copied Row
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2014, 05:21 PM
  4. [SOLVED] Copy data from one worksheet to another then delete the copied cells
    By youranitsas in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-30-2014, 03:48 PM
  5. [SOLVED] Need to copy certain cells from one worksheet and paste into another worksheet
    By ddouget1 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-15-2013, 05:42 PM
  6. [SOLVED] Copy row of data, paste in another worksheet, delete some of the cells copied
    By dev111ski in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-14-2012, 05:58 PM
  7. Copy full row then paste to another workbook horizontally last 5 copied cells
    By raemon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2012, 01:41 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