I have 2 Excel worksheets. The first contains a list of weekly items and the second is an annual view which contains a running list of all weekly items.
Each entry in the weekly and annual lists encompass 1 row and 7 columns.
I'm currently adding items to the weekly worksheet and then copying and pasting them to the annual worksheet.
Is there a linking function or formula that I can use that will automatically pull each weekly item and add it to the next available row in the annual worksheet?