Bringing highest number from data to a table

[nikwak1]

I'm not very good at explaining things but I will try my best: I have a sheet where data is input every week, the data always increases in number. I also have a table in another worksheet (on the same workbook) and what I want to do is - every time new data is put into the worksheet, I want that to copy on to the table. So in my image 1 - column E row 29 will be filled in this week. When it is, I want that number to appear in the table (image 2) column F row 12 and that to happen every time a new row in image 1 is completed. I hope that makes sense and that someone can help with this for me. Many thanks

 

[Peter_SSs]

Does this do what you want?

nikwak1.xlsm
	F
1
2	2023
3	24,659
4	27,945
5	32,300
6	35,334
7	39,372
8	44,580
9	53,568
10	70,119
11	78,422
12
13
14
15
Sheet2

Cell Formulas
Range	Formula
F3:F15	F3	=LET(v,Sheet1!E20,IF(v="","",v))

 

[nikwak1]

Peter, sorry no that isn't it. In excel02 There are figures entered in excel02 every week going down a row each week - this figure always increases. I want the latest figure in Column E to copy to the next available row in column F in excel01. In other words, instead of relying on someone putting the figure in twice, I would like the higher figure placed in column E excel02 to appear in the next available row in excel01 column F.

 

[Peter_SSs]

Peter, sorry no that isn't it.

So, for the sample data provided in post #1, which figure(s) in post #2 are incorrect, and why?

 

[nikwak1]

Sorry I am no good at explaining things. I'll have a go and see what I can do to get the figures over to new sheet but thanks so much for help so far