Automated labels for printing

Hey,

I am trying to set up a sheet that will let us mass import data; sort this data and automatically update fields to be able to quickly print labels. Quick run down:

Import to Data Sheet

DataSort automatically takes the data we need in the correct format (last name first name) as well as group name and a room number. 

Now the question is if we are able to use the cell structure in LabelFormat sheet to do this automatically like in the Label sheet where the data is automatically found and updated each time we change the data.  Or if the best way is to keep and print from the Label sheet once we figure out the margins and printing area. 

This sheet will be used by 10-12 different users (no common user being able to be used) and because of the pay-structure of certain extensions I am trying to find a way around this. 

Link to the google sheet  here

Thanks very much in advance!

 

1 0 105
0 REPLIES 0
Top Labels in this Space