• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Non - Manual Formula Fill

A

AZExcel

Member
Happy New Year to All.

I have been searching the forum for a solution but to no avail. I am looking for a way to have a series of formulas in a row automatically fill downward was data is entered into a subsequent row.

I am working on a tool that will track payments(see attached). The data will be entered sequentially in rows. 3 of the columns have formulas that I need to automatically fill in the row below once that row has data added.

I would rather try this approach rather than drag the formulas manually.

Anyone have any suggestions?
 

Attachments

  • Copy of C&S CREDIT TRACKER2.xlsm
    44.8 KB · Views: 4
Hi ,

I am not able to understand your worksheet , but I have one or two points :

1. Just as you have put in a formula in H5 , and are using it in the formulae in column G , why are you not using the formula in H6 ?

2. Your formulae can always ensure that missing data is unused ; for example , the formulae in column C :

=(F13-D13)+1

can be replaced by :

=IF(OR(D13="",F13=""),"",F13-D13+1)

which will ensure that even if you drag the formula down as far as C2000 , only data where both cells in column D and column F are populated will be displayed.

Narayan
 
Narayan

Thanks for your reply. The sheet is under development. The structure will be evaluated for more continuity once I get the basic functions worked out.

With respect to your question, H6 is for reference only... but part of the formula you mentioned will equal H6 ... ($H$4/30.416). Users of this tool will understand why this number is provided.

I am trying to avoid having to drag the formulas if possible... possibly using VBA but I will work with what you suggested in the event that there are no other solutions that give me the desired outcome.
 
Hi AZExcel,

You should convert the input area to a table, but before you that put Headers in al columns.

That would force the formulas into new rows that you enter

kanti
 
Kanti,

Thank you very much... with a little restructuring I was able to convert the input area to a table and this achieved my desired outcome.

Thanks for your time!!
 
You must log in or register to reply here.
Back
Top