Two formulas repeating that won't fill properly

[rschell]

Hey y'all

Here is my dilemma, I have two formulas that reference another sheet, my example shows it more clearly...
...............Column E
Row 11......=sheet1!F16+sheet1!I16
Row 12......=sheet1!G16
Row 12......=sheet1!F17+sheet1!I17
Row 12......=sheet1!G17
etc.

Is there a macro or a formula I can use on the remaining 4000 rows that will keep this pattern while maintaining the formulas above?

Thanks in advance!

[modytrane]

are you sure you have your row numbers correct?
better yet, attach a sample workbook.
modytrane

[rschell]

Here is an example, I am making a template so I can just type on sheet 1 and have it automatically populate the form 105. I have kind of started the old fashioned way but I really don't feel like having my fingers fall off haha.

[modytrane]

see the attached example.
This is one way, I am sure someone will probably come up with a different solution. I know that it can be done with macros, if you're interested.
The example here shows you how to do it without macros.

I have created helper columns M and N to create the references. If you drag the formulas in those columns down, the pattern will continue. Then in column E, I am using INDIRECT function.

If you have to drag these down to a few thousand rows, it will work.


Hope it helps.

[rschell]

You are freakin' awesome!

[modytrane]

One thing I forgot to mention.
When dragging down column E formuls, select last two cells e. g. E73 and E74.
Then drag down as far as you want. That way the pattern of formula will repeat correctly.
For columns M and N, you can select M74 and N74 and drag them down.

I am glad this helped you.
modytrane