Retrieve data from cell. (Very wierd)

[kckay]

I am working on a worksheet that will display data from a database for use in the field using a pencil. Some of the fields might be modified. I want to display both the original data and the changed data on the worksheet. I have some code that will extract the modified data and place it on another worksheet for semi-manual entry. During the extraction, I also want to bring the original and the modified data. I know, wierd requirements, but that is the parameters I must live with.

If I have data in cell $C$5, I also want to retrieve the data in cell $C$4.

How do I define the cell I want ($C$4) based on $C$5?


Thank you.

 

[Joe4]

How do I define the cell I want ($C$4) based on $C$5?

Perhaps take a look at the OFFSET function?