+ Reply to Thread
Results 1 to 7 of 7

copy and paste entry for current month to another sheet vba

  1. 02-28-2014, 08:33 AM #1
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    copy and paste entry for current month to another sheet vba

    Hi all,
    I have 4 columns in sheet1 and column 1 is having dates.

    I am trying if we can copy data from sheet 1 ( entries for current month only) and paste them to sheet 2 as values.

    I have tried but no success yet. sample is attached
    any help please
    Many thanks
    Kind regards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-28-2014, 08:46 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: copy and paste entry for current month to another sheet vba

    Hello

    A simple way..

    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 02-28-2014, 08:53 AM #3
    satabp
    satabp is offline
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: copy and paste entry for current month to another sheet vba

    Hi,

    One more way...

    Attached is the file....
    Attached Files Attached Files
    Like my answer, then click * below
    Reply With QuoteRegister To Reply
  4. 02-28-2014, 08:56 AM #4
    chinraj
    chinraj is offline
    Registered User
    Join Date
    02-27-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    77

    Re: copy and paste entry for current month to another sheet vba

    Or:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-28-2014, 09:44 AM #5
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: copy and paste entry for current month to another sheet vba

    Hi Fotis1991 ,
    As usual, very kind of you to help me again.
    The solution works great.
    Thanks again
    Reply With QuoteRegister To Reply
  6. 02-28-2014, 09:46 AM #6
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: copy and paste entry for current month to another sheet vba

    Hi satabp ,
    This one from you is very great and simple solution.
    Very kind of you to help me.
    Thanks again
    Kind regards
    Reply With QuoteRegister To Reply
  7. 02-28-2014, 09:49 AM #7
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: copy and paste entry for current month to another sheet vba

    Hi chinraj ,
    Thanks for your help. Your solution is with difference and works great.
    Thanks again for your kind help.
    Kind regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] command button to copy & paste current month data to sheet2 vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2014, 06:45 AM
  2. Using current month selection to copy/paste formulas and values
    By gigi85 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-03-2014, 07:51 AM
  3. [SOLVED] Copy & paste entire row to different sheet based on cell entry
    By XxCMoneyxX in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-14-2013, 07:52 PM
  4. Copy and Paste into new worksheet based on entry on Sheet 1
    By alextwre in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2013, 06:10 PM
  5. Macro to detect text ‘Current Month’ and then copy column and then paste special values
    By robertguy in forum Excel General
    Replies: 0
    Last Post: 09-18-2012, 11:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1