Results 1 to 10 of 10

Copy and paste based on Date and next empty row.

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2017
    Location
    Helsinki, Finland
    MS-Off Ver
    MS Office 365
    Posts
    60

    Copy and paste based on Date and next empty row.

    Hello,
    I need help. I am trying to find an easier way to copy data by VBA coding. Here source sheet is “Yearly Sales”, and destination sheet is “P01”. Data will be paste column N-X and Row 14 (cell N14). Sheet “P01” contains Product “Rice”. Sheet Yearly Sales has data till now 10th of March. Here 3rd and 10th of March are “Holyday”. The date of 7th and 8th of March I have not sale any Rice. Here is problem that when I copy from source (yearly sales) to paste destination (“P01”) by clicking a Button, then I did not get Row for Holiday and No Sale with date. Look at destination sheet “P01”. But I want to same as Sheet “Sheet1”. My destination sheet always update every day (not holiday).
    I attached file “621 Current Send.xlsm” for you. Also I attached 2 screenshots, “621 P01” is my present result which I don’t want. “621 Sheet1” result is which I want.
    If I write manually “Holiday” and “no sale” with date, then next update overwrite on holiday’s and No sale’s row. But I do not want it.
    What will be the right code? Can any one help me?
    Your help is greatly appreciated as always!! thank you for your time!!!
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to copy to new sheet and paste to last empty row based on criteria
    By Makroz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-19-2019, 10:32 AM
  2. Copy and Paste based on Date VBA
    By sjk1193 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-31-2019, 07:20 AM
  3. copy paste based on a date
    By namluke in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-11-2015, 10:39 AM
  4. [SOLVED] Copy Paste Based on Date
    By RedMug in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2014, 01:50 PM
  5. [SOLVED] Code to Copy Rows from 3 zones based on min/max value,and paste in next empty Target row
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-08-2014, 02:29 AM
  6. Copy/Paste to Next Empty Row Overwriting Previous Row When Column A Is Empty
    By grantfitz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 04:34 PM
  7. Copy row based on date and then paste into a new worksheet based on section number
    By calmlaunch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2011, 11:40 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