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