Extending a Series

[Kim]

I have information in a column in one Worksheet - Saved As TotalCompleted
ex:
P6 17
P7 22
P8 29
P9 19
P10 32
P11 26

I want to put this information into a different Worksheet - Saved As Comparison.
So in cell B4 I will type = and then click cell P6 from the other Worksheet. So cell B4 now reads =[TotalCompleted.xls]Total!$P$6.

I want use the fill feature and drag it so the other numbers continue in B without having to keep going back and forth between the 2 worksheets.

Any suggestions? Thanks in advance!!

 

[DDM]

Kim, click the formula in B4, click the $P$6, and press the F4 function key
until both $'s disappear. Then press Ctrl+Enter. Then drag down.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

I have information in a column in one Worksheet - Saved As TotalCompleted
ex:
P6 17
P7 22
P8 29
P9 19
P10 32
P11 26

I want to put this information into a different Worksheet - Saved As Comparison.
So in cell B4 I will type = and then click cell P6 from the other

Worksheet. So cell B4 now reads =[TotalCompleted.xls]Total!$P$6.

I want use the fill feature and drag it so the other numbers continue in B

without having to keep going back and forth between the 2 worksheets.

 

[DDM]

I should have said *double-click* the formula in B4...

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

Kim, click the formula in B4, click the $P$6, and press the F4 function key
until both $'s disappear. Then press Ctrl+Enter. Then drag down.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

I have information in a column in one Worksheet - Saved As TotalCompleted
ex:
P6 17
P7 22
P8 29
P9 19
P10 32
P11 26

I want to put this information into a different Worksheet - Saved As Comparison.
So in cell B4 I will type = and then click cell P6 from the other

Worksheet. So cell B4 now reads =[TotalCompleted.xls]Total!$P$6.

I want use the fill feature and drag it so the other numbers continue in

B
without having to keep going back and forth between the 2 worksheets.

Any suggestions? Thanks in advance!!