Hi,
here is my problem.
Let's say I have 2 sheets in my workbook.
On sheet 1, I have a database with x number of columns.
in this database I will everyday add a line with information in every columns.
Ex : column A is the date
column B is a Brand of car (Ford, Renault, Toyota, etc...)
column C is the driver of the car
In sheet2, in a cell (whatever cell) : I am looking for a function that will take automatically the data of the last line of my sheet 1.
for ex in cell A1, I want the brand of the car (Column B) of the last line of sheet1.
Can someone help me ?
Thank you very much in advance