formula

  • Thread starter Thread starter d.w.
  • Start date Start date
D

d.w.

I have catering form (worksheet "A") that I manually use
a "+" to bring info from another long list "B" (offices,
addresses, ph. #'s, lunch-times,etc)into specific cells
on form A.

Rather than have to "+" several times to get each cell of
info onto form A, would like to only have to "+" one cell
on form A and have all other cells fill in. All data on
worksheet B is layed out identically for each location in
single rows. Only difference is first cell I reference
is in a different row each time.

Can I "+" first cell and have all cells in same rows go
to same cells on form A. Seems like it should be easy to
do, but I can't figure out how to do it.

Thanks
dw
 
d.w. said:
I have catering form (worksheet "A") that I manually use
a "+" to bring info from another long list "B" (offices,
addresses, ph. #'s, lunch-times,etc)into specific cells
on form A.

Rather than have to "+" several times to get each cell of
info onto form A, would like to only have to "+" one cell
on form A and have all other cells fill in. All data on
worksheet B is layed out identically for each location in
single rows. Only difference is first cell I reference
is in a different row each time.

Can I "+" first cell and have all cells in same rows go
to same cells on form A. Seems like it should be easy to
do, but I can't figure out how to do it.

Thanks
dw
Click to expand...

When you say "+", I assume you are using this symbol to start a formula.
This is not standard Excel, but was included for compatibility with Lotus. I
suggest you get into using standard Excel methods. So, to get the value from
cell A1 of worksheet 2 into (say) cell D4 on worksheet 1, in that latter
cell you would put the formula
=Sheet2!A1

Now you can copy this formula to other cells, either using Copy followed by
Paste, or by dragging the fill handle (the little black square at the bottom
right of the selected cell). The reference in the formula will adjust
automatically, so that (for example) two rows down in cell D6 you would have
the formula
=Sheet2!A3

Does this help?
 
Back
Top