+ Reply to Thread
Results 1 to 4 of 4

VBA code Copy/special paste/ transpose data using date as parameter

  1. #1
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    302

    VBA code Copy/special paste/ transpose data using date as parameter

    Hi Expert,

    I am novice to VBA can understand bit of functions
    Currently I copy/ select special / transpose data and put in date wise rows in another sheet
    My manual process is time consuming

    Request please see my attached simple file

    Thanks in advance foe your suggestions
    Karnik
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: VBA code Copy/special paste/ transpose data using date as parameter

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Office365
    Posts
    302

    Re: VBA code Copy/special paste/ transpose data using date as parameter

    Hi Fluff13
    Thank for your suggestion,
    Saved lot of my manual time
    Cheers
    Karnik

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: VBA code Copy/special paste/ transpose data using date as parameter

    You're welcome & thanks for the feedback

+ 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. Sort by date/time, copy, & paste special (transpose)
    By dekeith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2017, 06:31 PM
  2. I want to transpose and link data using paste special
    By Daniel Brown in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2014, 08:43 AM
  3. Copy-Paste Special - Transpose values if condition applies
    By Florinnn in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-01-2013, 05:35 AM
  4. Replies: 1
    Last Post: 08-12-2012, 04:02 PM
  5. Repeat copy and paste special (transpose)
    By Mengtzee in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-16-2012, 11:38 AM
  6. HELP....Is there a way to automate copy/paste special/transpose -
    By Mel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-28-2005, 07:06 PM
  7. Trying to transpose linked data using Paste Special
    By Mike in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2005, 02:06 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