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.