Daily update of formulas 2

[Mark2Aus]

Hello.

We have 3 Workbooks ("Data", "Calc", "Rev").
"Data" contains 5 sheets (Sheet1,Sheet2,...). "Calc" contains 7 sheets (Sheet1, Sheet2,...) and "Calc" also contains 7 sheets.
In "Data" we enter the daily information collected from our branches. "Calc" and "Rev" contain complexes formulas manipulating the information entered in "Data".
Every morning I start Excel and open all 3 Worksheets. Then in "Data" I insert a new row for the new day and enter today's date. Then I have, for each Sheet in every Workbook, to insert a new row in the right sequence (from sheet1 to sheet...) and copy into the new row created all formulas contained in the previous row.
I am afraid I can make a mistake and skip one sheet or copy in a different order and I will only realise it after losses might have occurred.

Is there a way in Excel to do it automaically, say when I entered in "Data" today's date, it automaically insert a new row and copy the formulas into the other sheets?

Any help would be very much appreciated.
Thanks

 

[tf1]

Is the new row added to the same place on each worksheet? If so, you can multi-select all the worksheets (hold down the Control key and click on each sheet to select) then insert the new row to the top worksheet, copy the above row's data by selecting the row and then pulling on the drag handle in the bottom right corner of the selection. This will have repeated the same action on all the selected worksheets. Deselect and save the changes.


Regards: tf1

 

[KenWright]

Whilst it can be done in a number of ways, including using VBA, can you not simply set up the workbook such that you have the rows with the formulas in the file on each sheet already and then just populate them each new day? Why do you need to add the formulas daily, eg:-

Day 001 123 456 789
Day 002 123 456 789
Day 003 123 456 789
Day 004 123 456 789
Day 005 123 456 789
Day 006 Blank
Day 007 Blank
Day 008 Blank
Day 009 Blank etc

Regards
Ken...........


----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[Mark2Aus]

Thanks tf1 and Ken for your prompt responses. You've given me the clear solution to my "silly" problem.
Am I dumb or what?
Happy Holidays

Mark

 

[KenWright]

You're welcome - Have a good weekend

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------