Results 1 to 1 of 1

Thread: Update order sheet when another date worksheet is selected

  1. #1

    Update order sheet when another date worksheet is selected



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

    Hi Everyone
    Not sure if i'm in the right place but here goes

    I've got 5 worksheets named, Order - 01DEC - 02DEC - 03DEC - 04DEC

    On the Order sheet is all the calculations taken from 02DEC also in cell M2 is a dropdown list of dates

    What I want if it is possible is to select a date from the dropdown list 03DEC for example and for the Order sheet to be updated with data from 03DEC worksheet automatically

    What I am doing at the moment is changing the date in the formula bar manually eg 02DEC to 03DEC

    Thanks in advance
    Attached Files Attached Files

Posting Permissions

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