View Single Post
Old April 29 2014, 07:13 PM   #1
Vice Admiral
Ar-Pharazon's Avatar
MS Excel Question

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.
Rimmer, on what period of history to live in-
“Well, It’d be the 19th century for me, one of Napoleon’s marshals.
The chance to march across Europe with the greatest general of all time and kill Belgians” - (White Hole).
Ar-Pharazon is offline   Reply With Quote