Forum Discussion

Beth_Herrmann's avatar
Beth_Herrmann
Copper Contributor
Feb 20, 2019

Excel Formulas and Functions

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?

No RepliesBe the first to reply

Resources