+ Reply to Thread
Results 1 to 2 of 2

Copy range of 28 cells and paste to duplicate every 28 cells

  1. #1
    Registered User
    Join Date
    06-07-2010
    Location
    Michigan
    MS-Off Ver
    Excel 2016
    Posts
    47

    Copy range of 28 cells and paste to duplicate every 28 cells

    I am hoping this is easy and I am just over looking something. I am making a work schedule with cell a2 being the first day of the year and cell A366 being the last day of the year. I simply want to enter a schedule for a number of days (i.e. 28 days cells a2-a29) and duplicate them every 28 days without having to cut and paste every 28 day schedule. I hope this makes sense. I appreciate any help that is available.

    This probably isn't the right thread for this but I would also like to have the opportunity to enter a number of days to carry the out to. For example if I only wanted to carry the schedule out 240 days with that schedule duplicating every 28 days it would be nice to manipulate how many days I can carry out the schedule.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,720

    Re: Copy range of 28 cells and paste to duplicate every 28 cells

    Put this formula in B30 after setting up the values in B2 to B29:

    =B2

    Then just copy this down to cell B366.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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