selecting ranges

[pam]

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?

 

[Ron de Bruin]

Hi Pam

You can enter a value in b1 for example and
double click on the down right corner of the cell b1

 

[Guest]

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
(e-mail address removed)

----- 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?

 

[Guest]

Pretty slick Ron. Tricks like this are the reason I hang around on the newsgroup.

Mark Graesser

----- Ron de Bruin wrote: -----

Hi Pam

You can enter a value in b1 for example and
double click on the down right corner of the cell b1

 

[Ron de Bruin]

Hi Mark

Yes this is Super Tip<g>