Pam
What are you entering in column B? If it comes from a formula related to column A you could use something like this in B2
=IF(A2="",B1,your formula
This will check if the adjacent cell in A is blank and then duplicate the above number if it is. If the cell in A isn't blank, your formula will be applied
If the values in B have to be typed in directly you can try this. In B2 enter the formula =B1 and then copy this down as far as you need. Then enter the B values next to the A values. As you enter each value everything under it will change
In either case you can then Copy and Paste_Special>Values to eliminate the formulas
Good Luck
Mark Graesse
[email protected]
----- pam wrote: ----
I have data in column A. I want to enter a value in
column B down to the same number of rows that are non
blank in column A. Problem is that the amount of data
varies and so does the number of rows. How do I do
this?
