I have the following formula in two rows of a spreadsheet:
=('PASTE-rpt'!B5937)
=('PASTE-rpt'!B5943)
I want to extend this pattern for several more rows, but can't get autofill to maintain the every sixth row increment. Here is what happens:
=('PASTE-rpt'!B5937)
=('PASTE-rpt'!B5943)
=('PASTE-rpt'!B5939)
=('PASTE-rpt'!B5945)
The increment of row 3 is a value of 2 instead of 6.
Seems like a simple issue and I hesitate to post, but I could use the help.
=('PASTE-rpt'!B5937)
=('PASTE-rpt'!B5943)
I want to extend this pattern for several more rows, but can't get autofill to maintain the every sixth row increment. Here is what happens:
=('PASTE-rpt'!B5937)
=('PASTE-rpt'!B5943)
=('PASTE-rpt'!B5939)
=('PASTE-rpt'!B5945)
The increment of row 3 is a value of 2 instead of 6.
Seems like a simple issue and I hesitate to post, but I could use the help.