Automatically fill down data depending on column length

[laxster]

I have a template in which people will paste varying amounts of information into Column A - could be 10 records, could be 100.

I need Excel to automatically fill down a set of data that remains constant.

So if Cells A2:A10 are filled, I need the data residing in B2:C2 and fills B3:C10 with the same data.

Is this possible?

 

[vicsar]

I might be able to help but I need a sample file to work on. Please could you upload it?

 

[Brianwarnock]

Automation can be useful, but it can also be unnecessary, this is so simple and quick to do manually, following a manual operation that it hardly seems worthwhile.

However that said you can put formulae into your template that can do this.

Eg in B3 =If(isblank(A3),"",B$2)

And fill down as far as you like, similar for column C

Else you can write code in the sheet change event that looks for the last cell in col A and then does the copy and paste for the other columns.

Brian

 

[vicsar]

Good point Brianwarnock. laxster did this solve the challenge?

 

[NBVC]

Have a look at Excel List feature (Excel 2003)

http://office.microsoft.com/en-ca/excel-help/about-excel-lists-HP001004433.aspx

or Excel Table Feature (Excel 2007+)

http://office.microsoft.com/en-ca/excel-help/overview-of-excel-tables-HA010048546.aspx

These can be use to "autofill" as you create new rows.