Need help - Seeing which cells contain data in B2 then in A2 copy formula down

[mattyp]

Sorry I wasn't sure how to word the title so everyone knows exactly what I'm looking for.

So basically what I need to do is search Column B. If there's data all the way down to B30, I want to go over to Column A and copy a formula from A1 through A30. My problem is the data in column B could vary between 2 cells all the way up to 2000 and anywhere in between.

I can figure out how to copy the formula to Column A, my biggest problem is trying to figure how far down the formula needs to be copied. Can anyone lend a hand because I honestly don't even know where to start!

[Solus Rankin]

Please Login or Register  to view this content.

[HaHoBe]

Hi, mattyp,

maybe

Please Login or Register  to view this content.

if A2 holds your formula.

Ciao,
Holger

[mattyp]

Thank you for the responses, both ways work for what I need! It's amazing how simple it ends up being (thanks to both of you!). I showed my newbie colors for sure on this one! Thanks again!