Forum Discussion

woodlaneaccounting's avatar
woodlaneaccounting
Copper Contributor
May 02, 2025

Making data add to a new row in the same sheet

I have an excel sheet that we input data at the top weekly and it also pulls from other tabs. We update the numbers weekly, along with other data, into rows below and keep the previous data in rows above the current week. 

so for example: B27 would need to be F2 when we update it but B26 would still need to stay what F2 is now. Same thing with C27,E27,F27,G27,I27,K27. All of those pull from data at the top and change weekly. 

 

What formula could i use to make this happen? Help! 

BI & Data Analysis
excel

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor
    May 03, 2025

    It wouldn't be a formula. You're looking for a macro or VBA routine.

    But why do it that way? Why not enter each week's data directly into the table that tracks history? What you have at the top is essentially what some folks call "a dashboard," which would be a set of data extracted from an ongoing database giving a summary of important averages, etc.

    I'm suggesting a change of design, yes.....you're using the top section as both INPUT and OUTPUT now. View it instead as a "dashboard"--the OUTPUT, and do all your data collection (INPUT) in the table. And formulas to extract and week's data into the dashboard would be easy.

    Something to consider,

Resources