Autofill non adjacent cells

[juriemagic]

Hi,

I have tried numerous examples given by experts to other people, but none seems to work for me. Please help!!.

I would like to autofill only every 4rth cell. I have attached a small part of a very long spreadsheet. The yellow cells is what I would like to copy to the right. Please no VBA as my sheet is clogged with plenty VBA already. I prefer this be done with a formula..thanx a lot people!!

[FloMM2]

juriemagic,
Have you checked out the 'OFFSET' function (fx) in excel?
If I understand your request, you want the value 4 cells to the right of the value in the column and row 2.
Example:
In cell A7 = 18,020.10, cell B7= 13,284.80 (This is the value 4 columns to right of C2).

Following the above example, C7=6,316.00, D7= 2.10, E7=17,302.50,F7= 1,669.90, etc.
What I did was put the formula "=OFFSET(C2,0,4)" in cell C7 and copy across.
HTH and answers your question.
FloMM2

[sktneer]

Try this..

In B7

Please Login or Register  to view this content.

and then copy across.

Is this what you are trying to achieve?

[sktneer]

Or this if you don't input value in A7 manually.

In A7

Please Login or Register  to view this content.

and then copy across and down.

[juriemagic]

Sktneer,

thanx a lot...your first approach just gives zeros, but the second one works perfect!!. Thanx a million!

FloMM2,
I also tried your version but the results were scrambled. Thanx for helping though. All is appreciated!!

[sktneer]

You're welcome. Glad I could help.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.