Adding new data sets to multiple worksheets

Aaron - Mar 4, 2011 at 08:52 AM
 Aaron - Mar 4, 2011 at 09:20 AM

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.


1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
Mar 4, 2011 at 09:12 AM
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,
I love trying to make things more complicated then they need to be. Thanks!