Results 1 to 4 of 4

Thread: help needed with searching sheet for todays date and copying into new sheet

  1. #1

    help needed with searching sheet for todays date and copying into new sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, i have attached a mock up of spreadsheet i am trying to create. I want us to easily be able to see what deliveries we have today when we open the spreadsheet without having to look through it for today's date.

    i want it to search the the first column for any entries between today's date and the next 5 days and copy them into a new sheet in date order. I want to it auto update everyday when the spreadsheet is opened. what is the best way to do this?
    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    gus2000,

    What you are wanting seems like a practical request, but you will need to supply more information in order to get help. Your attachment indicates where you want to end up but without knowing where you're starting assistance is impossible.

    I realize including the original data, in a lot of cases, is a problem because of the personal information it may contain. You will greatly increase chances of people helping out by investing time in "sanitizing" a sheet of data that would be used to create what your after and posting that so that people will actually have something to work with.

    NoS

  3. #3
    Thanks,

    i have put in some dummy data. this is the spreadsheet we will start with and input the data onto as we sell products, i want it to do exactly the same layout in the next sheet just always showing today's and the next few days deliveries so we know what we have to get ready each morning.Delivery Schedule.xlsx

  4. #4
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    i have put in some dummy data
    Actually I believe you've posted the same thing twice

Posting Permissions

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