Drag down a row of dates

[nickharr]

Could someone please tell me if it is possible to do the following?!

I have a row of dates in Row 1 - A1 being Friday 1st May, B1 Saturday 2nd May, through to G1 being Thursday 7th May.

Row 2 is a row of formula to pick details from another worksheet.

Row 3 is the next week's dates - A3 being Friday 8th May etc.

Row 4 is a row of formula to pick details from another worksheet.

My question is - can I replicate this to rows 5 onwards by dragging down the existing information? It doesn't seem to work when I have tried it.

Any thoughts would be welcome.

 

[thisoldman]

To increment the dates, make the third row a row of formulas. In A3, enter =A1+7 and copy to the right. Then drag the last two rows.

To exactly duplicate the rows, select A1:G4. Put your cursor on the thick border between rows 4 and 5. The cursor should change to the thin, black 4-headed arrow cursor. Press Ctrl and drag.

 

[nickharr]

To increment the dates, make the third row a row of formulas. In A3, enter =A1+7 and copy to the right. Then drag the last two rows.

To exactly duplicate the rows, select A1:G4. Put your cursor on the thick border between rows 4 and 5. The cursor should change to the thin, black 4-headed arrow cursor. Press Ctrl and drag.

Thisoldman - Many thanks - that is perfect and works just as I had hoped!! Much appreciate your time.

 

[thisoldman]

I'm happy to help. Thanks for posting back with the results.