Kingofhearts6464
New Member
- Joined
- Dec 13, 2020
- Messages
- 10
- Office Version
- 2019
- Platform
- Windows
Hello please help. My company recently fired our tech guy and needed someone to fill his shoes for a bit. I volunteered and have no idea why lol.
They have a daily spreadsheet with 31 sheets used to track sales of items per day. They would like a easy botton on sheet1 that would add a row to all the sheets in the same place. I've been able to create a commandbutton and I can now create a row in sheet1 but I cant figure out how to make it form a row in all 31 sheets at once. Can someone help with the code I would use?
They have a daily spreadsheet with 31 sheets used to track sales of items per day. They would like a easy botton on sheet1 that would add a row to all the sheets in the same place. I've been able to create a commandbutton and I can now create a row in sheet1 but I cant figure out how to make it form a row in all 31 sheets at once. Can someone help with the code I would use?