Extending a Series

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


Kim said:
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
Click to expand...
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
Click to expand...
without having to keep going back and forth between the 2 worksheets.
 
I should have said *double-click* the formula in B4...

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


DDM said:
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


Kim said:
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
Click to expand...
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
Click to expand...
B
without having to keep going back and forth between the 2 worksheets.
Any suggestions? Thanks in advance!!
Click to expand...
Click to expand...
 
Back
Top