Hello ExcelFOrum!
I have list of data on sheet1 cells a1,a2,a3.... where i enter data every day. In other workbook i need link values from sheet1 but only last 30 rows of data.
So, if i have data only in a1,a2 a3 what formula should be in another wbook? Please, excel look another wbook's last 30 rows if there is values, if not, look last three(example a1 a2 a3)
Any help is appreciated, God Bless.
Bookmarks