+ Reply to Thread
Results 1 to 10 of 10

Formula to autofill data to another spreadsheet every 7 days

  1. #1
    Registered User
    Join Date
    03-18-2019
    Location
    Kalamazoo
    MS-Off Ver
    2007
    Posts
    7

    Formula to autofill data to another spreadsheet every 7 days

    I have 5 tabs within a workbook. The 1st tab captures 28 days of data. The next 4 tabs are meant to separate the 28 days of data into weeks; separated by 4 weeks and therefore 4 weekly tabs.

    What I want to do is have the 4 weekly tabs auto-fill with the data from the 1st tab. So "Week 1" would have the first 7 days of information collected from Tab 1, and "Week 2" would have the next 7 days of information collected from Tab 1, and so on and so on.

    So basically, can I create a formula that automatically fills data into the weekly tabs that is already entered into Tab 1, based on data range of 7 days for each weekly tab?

    I have very limited experienced with formulas, please bear with me.
    Attached Files Attached Files
    Last edited by Atruin; 03-19-2019 at 11:31 AM.

  2. #2
    Registered User
    Join Date
    03-18-2019
    Location
    Kalamazoo
    MS-Off Ver
    2007
    Posts
    7
    Any help would be appreciated.
    Last edited by Atruin; 03-19-2019 at 06:35 AM.

  3. #3
    Registered User
    Join Date
    03-18-2019
    Location
    Kalamazoo
    MS-Off Ver
    2007
    Posts
    7

    Re: Formula to autofill data to another spreadsheet every 7 days

    I'm starting to think this might not be possible because no one has responded. Is that fair to say?
    Last edited by Atruin; 03-19-2019 at 08:20 AM.

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,462

    Re: Formula to autofill data to another spreadsheet every 7 days

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  5. #5
    Registered User
    Join Date
    03-18-2019
    Location
    Kalamazoo
    MS-Off Ver
    2007
    Posts
    7

    Re: Formula to autofill data to another spreadsheet every 7 days

    Quote Originally Posted by Phuocam View Post
    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Hello Phuocam! Thanks for your reply. I have attached an exact copy of the Excel file I will be using for this project. Please let me know if you have any questions. Thanks again for your help!

  6. #6
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,462

    Re: Formula to autofill data to another spreadsheet every 7 days

    Sorry, the sample file is no data, no desired results. Can you update the file?

  7. #7
    Registered User
    Join Date
    03-18-2019
    Location
    Kalamazoo
    MS-Off Ver
    2007
    Posts
    7

    Re: Formula to autofill data to another spreadsheet every 7 days

    Quote Originally Posted by Phuocam View Post
    Sorry, the sample file is no data, no desired results. Can you update the file?
    I'm sorry about that! I have updated the Excel file with 14 days of sample information. I hope this helps. Thanks again!

  8. #8
    Registered User
    Join Date
    03-18-2019
    Location
    Kalamazoo
    MS-Off Ver
    2007
    Posts
    7

    Re: Formula to autofill data to another spreadsheet every 7 days

    Still looking for help please. I have attached an excel file as well. Thank you!

  9. #9
    Registered User
    Join Date
    03-18-2019
    Location
    Kalamazoo
    MS-Off Ver
    2007
    Posts
    7

    Re: Formula to autofill data to another spreadsheet every 7 days

    Bump. Looking for assistance. This is for my job and I really need help. Please and thank you.

  10. #10
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,729

    Re: Formula to autofill data to another spreadsheet every 7 days

    This proposal employs cells C4:D4 on each of the weekly sheets to give the start and end dates.
    Note that these dates may be hidden, for aesthetic purposes, by setting font color to white.
    Fill the start date in Week1:C4 and the rest will automatically fill.
    C4 (of weeks 2, 3 and 4) uses: =Week1!D4+1
    D4 uses: =C4+6
    The dates in column A are filled using: =IF(MAX(A$18:A18)<D$4,MAX(A$18:A18)+1,"")
    The Activity:NT columns are filled using: =IF($A18="","",IFERROR(INDEX('FF CLIENT TIME SHEET '!B$18:B$200,MATCH($A18,'FF CLIENT TIME SHEET '!$A$18:$A$200,0)),""))
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Auto Populate Excel Calendar based on Date Ranges
    By mikearmanios in forum Excel General
    Replies: 12
    Last Post: 11-01-2018, 06:39 AM
  2. [SOLVED] Auto Populate a Linear Calendar Based On A List With Date Ranges
    By falafelologist in forum Excel General
    Replies: 3
    Last Post: 05-20-2015, 08:15 PM
  3. [SOLVED] Auto fill cells with data from another spreadsheet
    By TlgKill in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-26-2013, 01:46 AM
  4. Auto-fill cells with Dates based on another date cell
    By oneilkr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-16-2013, 07:32 PM
  5. auto fill a spreadsheet on a userform based on a textbox value
    By cyclone77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2012, 11:38 PM
  6. Auto fill cells based on a date range given
    By timmy1254 in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 11:12 PM
  7. Auto fill table based on the data from another workbook
    By Biona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2011, 01:30 AM

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