Fill Formulas

**Brian Matlack** · 12-03-2009, 04:34 PM

Hi!
I export a report from Quickbooks that has data columns running left to right in Descending order.
I have formulas that refer to this data but I want my columns to run left to right in Ascending order which means I have to write each formula separately in stead of lettting me copy-fill my cells to the right.

Is there a way to do this with a macro more easily?

Is there a way to do it without a macro?

Thanks for any help you may give!!

**pike** · 12-03-2009, 04:55 PM

Brian
use something like

Please Login or Register  to view this content.

**Brian Matlack** · 12-03-2009, 05:22 PM

Pike:

K4 Refers to J4 then L4 refers to K4 etc.

When I fill it needs to refer to cells going left.

K4 refers to J4 then L4 refers to I4 then M4 refers to H4 and so on.

Can you help do this? Thanks for the feedback!!!

**DonkeyOte** · 12-03-2009, 06:15 PM

In terms of native formulae, you can use INDEX

K4: =INDEX($A4:$J4,COLUMNS($A4:$J4)-(COLUMNS($K4:K4)-1))
copied across

Or OFFSET

K4: =OFFSET($J4,,1-COLUMNS($K4:K4))
copied across

the latter though shorter in terms of syntax is Volatile - both can be dragged etc...