Pergunta de entrevista da empresa HSBC

How to do copy 1000 entries in table A to table B in Excel without directly using copy and paste?