Thread: Adjoining Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carla Carla is offline
external usenet poster
 
Posts: 78
Default Adjoining Cells

I have two worksheets in one spreadsheet. I want to be able to change 1
number and have the next cell down display the cell adjacent to the cell I
input. For instance, if I specify Worksheet1 A1, I want the next cell down
to display, Worksheet1 B1. Is this possible? If so, what is the formula or
function?