Autofill with Dynamic Number of columns

[Coach3131]

I am looking to autofill a formula across a row where there is a check to see the first column with data then autofills to the last column on the sheet.

For example, Row2 may start at Column C while Row 3 may start at Column E... but they would both end at the same column for the autofill

Thus, I believe the variables needed are:
1) The current row
2) FirstCol which is checked when on that row
3) LastCol which is global for the sheet

 

[Sthrncali]

Cuple of questions:

1. What is the global column you want it to autofill to?
2. Preset number of rows or variable? If variable, is there a Max you know it wouldn't go beyond -- OR is there a column in the sheet that would always have data in it for every row (I.E. a Col you can use to identify how many rows of data are currently on the sheet.)