You can use VLOOKUP for this, or an INDEX/MATCH combination - both
described in Excel Help.

Hope this helps.

Pete

On Oct 31, 8:34 am, Syahira wrote:
Hi everybody. thanks in advance for helping me. I a workbook with 2 sheets.
the first sheets I need to key the figure of report, and the second sheet is
showing when the report submitted. Let say if I want to key in the figure in
report and automatically the date is pop-up on the second sheet, it is
possible to do it? If yes,how?
thanks again