Help making a group of rows/columns populate when choosing a certain number
Scenario: Staff tracker for clockin/out times and cash variance
I want to make it so that if in a certain section on the tracker the manager gets asked “how many staff are working?” And they say 3, the sheet will make 3 copies of the same selection of rows/columns available to enter data
Eg of the Column A and Bs that I’d want populated i
Column A / Column B
Staff name / Dropdown with names
Scheduled clock in time / blank cell for time
Actual clock in time / blank cell for time
Scheduled clock out time / blank cell for time
Actual clock out time / blank cell for time
Drawer cash out variance cash / blank cell for currency
Drawer cash out variance card / blank cell for currency
Posted Sep 11, 2025, 5:01 PM UTC
12