Thread: Selecting Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BiggyTwo
 
Posts: n/a
Default Selecting Cells

Hi All,

I have a small spreadsheet, where A1 to E1 are headings, with columns
like this:

A B C D E
1 DATE Lime/g Alum/g Chlorine/g Carbon/g
2 5/19 200 360 135 600
4 .................................................. .......
5 .................................................. .......
6 9/19 230 300 225 450

Can I link the value in cell A2 to D2? (ie if A2 is chosen how can I
select D2, another cell in the same row, for use in a calculation.)

If anybody understands what I am trying to say I will be happy for
suggestions. (Otherwise just ignore, lest I confuse more than I am.)

Many thanks in advance.

Biggy Two