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:
[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]

Jan-15​

[/TD]
[TD]

Feb-15​

[/TD]
[TD]

Mar-15​

[/TD]
[TD]

Apr-15​

[/TD]
[TD]

May-15​

[/TD]
[TD]

Jun-15​

[/TD]
[TD]

Jul-15​

[/TD]
[/TR]
</tbody>[/TABLE]

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:
[Table="class: grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][/tr]
[tr][td]

1​

[/td][td]

January-2015​

[/td][td]

​

[/td][td]

​

[/td][td]

February-2015​

[/td][td]

​

[/td][td]

​

[/td][td]

March-2015​

[/td][/tr]
[/table]

Is that something you can work with?