Hi there, is there a way to use VBA code or otherwise to make the left hand side look like the right as per the example excel snip I've attached?
I pull the data in at the moment as a block from another sheet into the left hand sides format. The only thing I really care about is the drill/single/twin/cut&drop numbers though. Everything else is mute. But the tricky part comes where the name might not match the heading in the same row. Generally speaking, each 4 rows of a machine are operated by the person at the top of the machine# and the others are just trainees.
I pull the data in at the moment as a block from another sheet into the left hand sides format. The only thing I really care about is the drill/single/twin/cut&drop numbers though. Everything else is mute. But the tricky part comes where the name might not match the heading in the same row. Generally speaking, each 4 rows of a machine are operated by the person at the top of the machine# and the others are just trainees.