Overwrite data
Results 1 to 1 of 1

Thread: Overwrite data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2016
    Post Thanks / Like
    1 Post(s)
    0 Thread(s)

    Post Overwrite data

    Hi there

    I am trying to create a macro/code that will overwrite data each day when a new file arrives

    I have a spreadsheet that has a daily forecast for the next month where each day has 48 half hours/rows and 28 columns (including the column for the date/period i.e. dd/mm/yyyy hh:mm).

    This forecast is then updated each day for the next day i.e. on the first of the month the forecast is reran for the second of the month etc.

    The plan is that I have sheet A acting as the master sheet with sheet B being where i pull the data in from. The idea being that each day the day ahead forecast from sheet B will overwrite the forecast in sheet A (without affecting the other days on either side of the forecast). I'm assuming the code will need to look up the specific date/time entry and then move the data across from sheet B into the corresponding row in sheet A.

    I have tried playing around with a few simple copy and paste macros but i can't get round the issue that it overwrites everything and not just the data that's applicable.

    I'd appreciate some help from the Excel masters as it is beginning to do my head in Thank you
    Last edited by Woofy_McWoof_Woof; Aug 5th, 2019 at 05:10 AM. Reason: Fixed date/time format

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts