Adding new data sets to multiple worksheets [Solved/Closed]

Report
-
 Aaron -
Hello,

I am creating a spreadsheet database for data to determine the best vendor to use. I have multiple vendors on different worksheets and the worksheets are formatted Identically. I want to be able to add a new data criteria (new Rows) in the Master Format" and have that formatting carry through to all the other worksheets.

for example if my rows are as follows in every sheet,

company | Address | Phone|


I want to be able to add "Cell Phone" to the Master sheet and have all other sheets add that same Row. The data wont be populated, but you now have the option to instead of adding a new row individually to 20 different worksheets.

Thank

1 reply

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Hi Aaron,

By holding down the Ctrl button when selecting every single sheet, you can adjust all your sheets at the same time. Try it out.

Best regards,
Trowa
I love trying to make things more complicated then they need to be. Thanks!