debauch
02-19-2008, 04:04 PM
Hello,
Hoping someone can help. I have data in multiple columns that will change and the amount of rows will change also. Generally, I would jsut program in VBA a filldown method where possible. However, I need to filldown based on Column A and the formula is farther to the right.
Is there anyway to insert a formula into a cell and have it loop through until it sees the end of row A? I attached a sample w/ comments to explain further what I mean.
Hoping someone can help. I have data in multiple columns that will change and the amount of rows will change also. Generally, I would jsut program in VBA a filldown method where possible. However, I need to filldown based on Column A and the formula is farther to the right.
Is there anyway to insert a formula into a cell and have it loop through until it sees the end of row A? I attached a sample w/ comments to explain further what I mean.