Help on incrementing cells.

[Matt2298]

Hi,

I have been trying to create a formula where cell letter for example A1 increases next time to D1.

For example; A1 on MAIN sheet is january-2015, and A7 on REFERENCE SHEET is also January -2015. However next time on MAIN Sheet February - 2015 is in D1, and REFERENCE Sheet its in B7.

Images here to help: https://onedrive.live.com/redir?res...84&authkey=!ADr-wiG21Uoa19s&ithint=folder,PNG

 

[Ron Coderre]

If I understand correctly, you want a formula that can be copied from A1 to D1, G1, etc...every 4 columns
that references a sequential row-range on the REFERENCE tab

With
On the REFERENCE tab:

	A​	B​	C​	D​	E​	F​	G​
7​	Jan-15​	Feb-15​	Mar-15​	Apr-15​	May-15​	Jun-15​	Jul-15​

<tbody>
</tbody>

On the MAIN tab

A1: =INDEX(REFERENCE!$A$7:$O$7,CEILING(COLUMN()/3,1))

Copy that formula into D1, G1, etc

The result will be:

	A​	B​	C​	D​	E​	F​	G​
1​	January-2015​	​	​	February-2015​	​	​	March-2015​

Is that something you can work with?