+ Reply to Thread
Results 1 to 5 of 5

Help link data to new page using date range that can be changed easily

  1. #1
    Registered User
    Join Date
    05-11-2022
    Location
    Ballina, Australia
    MS-Off Ver
    365
    Posts
    3

    Help link data to new page using date range that can be changed easily

    Hi all,

    I use a spreadsheet to enter daily sales figures for our business. This happens every day. (Shelter Daily Report)

    I Have created a second page that is designed to take some of the data required by our bookkeeper from DAILY ENTRY and show it in a weekly report. (Gaz weekly report)

    I have attached an image for reference
    I would like to be able to manually enter the date of the Sunday for end of week into cell A2(eg this Sunday 15/5/2022)

    By doing this - I would like the table to update the Monday to Sunday dates (cells C2:I2) (Monday 9/5/2022 to Sunday 15/5/2022)

    I would then like the cells C2:I2 to bring corresponding data from those dates into the fields below
    If C2 becomes Monday 9/5/2022 - I would like C5 C6 C7 etc etc to pull data from the Shelter Daily report figures entered on Monday 9/5/2022

    This way I can easily populate a weekly report.

    I hope this makes sense and that someone can help me with this.

    Thanks!
    Anton

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: Help link data to new page using date range that can be changed easily

    Please attach a sample workbook and show your desired results.

  3. #3
    Registered User
    Join Date
    05-11-2022
    Location
    Ballina, Australia
    MS-Off Ver
    365
    Posts
    3

    Re: Help link data to new page using date range that can be changed easily

    Thanks Josephteh,

    Please see attached sample workbook.
    As described in example I want data from sheet "Shelter daily report" to automatically enter sheet "gaz weekly report" based on the date entered into cell A2. By doing this - I would like the table to update the Monday to Sunday dates (cells C2:I2) (Monday 9/5/2022 to Sunday 15/5/2022)
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: Help link data to new page using date range that can be changed easily

    B2=$A$2-7+COUNTA($B$1:B$1), copy across and B3=INDEX('Shelter daily report'!$5:$5,MATCH(B$2,'Shelter daily report'!$1:$1,0)), copy across.

  5. #5
    Registered User
    Join Date
    05-11-2022
    Location
    Ballina, Australia
    MS-Off Ver
    365
    Posts
    3

    Re: Help link data to new page using date range that can be changed easily

    Thank you Josphteh
    This has worked perfectly.
    Anton!

+ 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. Replies: 1
    Last Post: 03-09-2015, 05:59 AM
  2. Count occurrences of value in a date range I can specify easily each time
    By mikalaka in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-14-2014, 07:14 PM
  3. [SOLVED] Can the name of a series data for a chart be changed more easily?
    By billj in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-24-2013, 11:25 AM
  4. Replies: 5
    Last Post: 10-02-2012, 01:51 AM
  5. Automatically update date when a range of data is changed
    By rcvanriet in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 09-12-2012, 12:58 PM
  6. Display the date and time each time the data in a cell range is changed
    By BVZM in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2012, 01:23 PM
  7. Cross worksheet references cannot be easily changed
    By maintchief in forum Excel General
    Replies: 0
    Last Post: 11-25-2005, 11:35 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