Forum Discussion
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 a...
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,