Sciencemadness Discussion Board
Not logged in [Login ]
Go To Bottom

Printable Version  
Author: Subject: Excel automatic label generator
aa1881
Harmless
*




Posts: 16
Registered: 13-10-2021
Member Is Offline


[*] posted on 24-1-2026 at 08:37
Excel automatic label generator


I made a simple Excel spreadsheet that can make a label to be printed for reagent bottles.
It uses a macro to auto-update the table in the third sheet, which means it will ask for permissions to run macros on the first startup.
Just type the name of the chemical you want a label for in the designated cell and it will be generated automatically.

Hope others find this useful. If there are any suggestions to add functionality, I'd love to hear them.

Attachment: Chemlabelmaker.xlsm (100kB)
This file has been downloaded 53 times

View user's profile View All Posts By User
aa1881
Harmless
*




Posts: 16
Registered: 13-10-2021
Member Is Offline


[*] posted on 24-1-2026 at 11:37


Here is an updated version with more info and an easier way to scale and copy the label.

Attachment: Chemlabelmaker.xlsm (130kB)
This file has been downloaded 64 times

View user's profile View All Posts By User
pesco
Hazard to Self
**




Posts: 96
Registered: 19-11-2015
Member Is Offline

Mood: No Mood

[*] posted on 24-1-2026 at 15:28


Nice one!

Shame it doesn't properly work in LibreOffice.
I will check Open Office soon.
View user's profile View All Posts By User

  Go To Top