Excel Formulas and Functions

Occasional Visitor

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?

Related Conversations
Round Down to the nearest 5
jshea23 in Excel on
0 Replies
help with formulae
Gavc1 in Excel on
1 Replies
print macro for variable print area
tomb999 in Excel on
0 Replies
Mailing worksheets in excel
Bruno1250 in Excel on
4 Replies
Ribbon or right clicking will not go further out
51218 in Excel on
0 Replies
How to automate a timesheet template?
fishfish31 in Excel on
1 Replies