+ Reply to Thread
Results 1 to 7 of 7

Automatic copy paste VBA required

  1. #1
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Automatic copy paste VBA required

    Hello Everyone,

    Please find the attached sample sheets in which i need a VBA code to copy paste data as per below requirement

    currently How i copy and paste right now is
    1- first i copy and paste from location to contact person in a new sheet then
    2 -copy and paste 16th mar 20 whole column data against the above (point 1), so that i can get project names against employee names, location and etc.
    3 - then i again repeat point 1 and filter non blanks from 1st additional project names which is next to 16th march date column (Yellow highlighted) and i paste it then i remove filter from yellow column and repeat point 1 and filter non blank in additional project names (this time its red)
    4 - then again i remove filter from everything and repeat from point 1 to point 4 for 17th March date
    5 - i have do this for whole month, but i get data weekly.

    Important point is wherever date is mentioned should be copy and pasted with blanks and additional projects names should be copy and pasted without blanks.
    Attached Files Attached Files
    You can add reputation(s) of those who helped

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,744

    Re: Automatic copy paste VBA required

    Administrative note
    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

  3. #3
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Re: Automatic copy paste VBA required

    I think i have updated the excel version. please let me know for any further help
    Last edited by sam1105; 03-28-2020 at 03:13 AM.

  4. #4
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Re: Automatic copy paste VBA required

    Can any 1 of them help on this taks?

  5. #5
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,744

    Re: Automatic copy paste VBA required

    Administrative Note:

    We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only 3 hours since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

  6. #6
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Re: Automatic copy paste VBA required

    Thanks for your reply...i understand it..

  7. #7
    Registered User
    Join Date
    08-04-2015
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    82

    Re: Automatic copy paste VBA required

    hello..request you to help on this thread..

+ 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. Copy paste required data from one workbook to another
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2019, 09:26 AM
  2. Required help in modifying the code.. (COPY & PASTE)
    By Revathi kannan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2019, 09:21 AM
  3. Macro required - copy and paste into new workbook.
    By BurnsyNI in forum Excel General
    Replies: 1
    Last Post: 08-30-2011, 09:32 AM
  4. Automatic Copy Paste
    By NeoPhyx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2011, 03:57 PM
  5. simple copy paste macro required
    By normanjones4 in forum Excel General
    Replies: 2
    Last Post: 02-27-2007, 12:00 PM
  6. copy and paste help required
    By khalid79m in forum Excel General
    Replies: 4
    Last Post: 01-06-2007, 09:52 AM
  7. Automatic Copy and Paste
    By Jana in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-13-2006, 05:25 PM

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