Bulk Cell Linking

Whitney F.

I have a sheet with the Monday-Friday and a weekly total at the bottom of each week. I want to cell link each weekly total to another sheet, so I am trying to link every like 5th or 6th row, depending on how many weeks are in that specific month. Is there a way I can mass link these instead of doing each cell individually?

Genevieve P.

Hi @Whitney F.

Is there a reason this needs to be a separate sheet? What I would do in this instance is create a Report and filter if the row says "Weekly Total". That way you'll automatically see all Weekly Totals in one view.

If your column on the left is a Date column, an alternative would be to use a SUMIFS Function in a cross sheet formula instead of manually cell-linking.

You can set up a Start Date column and and End Date column in your Metric sheet, then SUM the total column based on the dates.

=SUMIFS({Total Column}, {Date Column}, >= [Start Date]@row, {Date Column}, <= [End Date]@row)

Let me know if that works for you!

Cheers,

Genevieve