I have a good basic knowledge of Excel, but have never used macros. Never really needed to until now.
What I have is a spreadsheet of material stored in a building, with about a dozen columns of info per line. There's probably a couple hundred lines.
What I'd like to do is, using info from 4 or 5 of those columns, create a placard for each item automatically, with that info being sent to empty cells on a blank sheet, then probably saving each one as a new sheet and/or new workbook.
I'm not even sure this involves macros, or if it would be another Excel feature altogether.
I'm scheduled to take a couple classes later in the year, but would prefer not to wait that long to do this project.