This may be an oddly specific request. I am also new to all of this so if I am missing some details please let me know. I got dumped with creating some crazy excel document at a new job despite being clueless about excel because I am new and young so I think they assume I just know this stuff. Anyway,
https://imgur.com/a/Dg2wW45 This link has a picture of my sheet one and sheet two (those are the names of each sheet)
I need a macro to start at the top row of sheet one, and pull the data from each column in to sheet two as I have it displayed in the picture. Then I need the macro to print that box in sheet two, and loop that process. Essentially I need it to go down sheet 1, row by row, formatting the data and printing a "ticket"
The end goal is that someone can upload the data needed for these tickets, and we can run a macro that will format the data and print all the tickets.The tickets have a very specific size and shape to them, which is why the formatting is important.
I would like it to display the print options screen before it spits out all the tickets. I am not sure if this relates to the macro or my computer settings. If anyone is able to help I would be incredibly grateful!
https://imgur.com/a/Dg2wW45 This link has a picture of my sheet one and sheet two (those are the names of each sheet)
I need a macro to start at the top row of sheet one, and pull the data from each column in to sheet two as I have it displayed in the picture. Then I need the macro to print that box in sheet two, and loop that process. Essentially I need it to go down sheet 1, row by row, formatting the data and printing a "ticket"
The end goal is that someone can upload the data needed for these tickets, and we can run a macro that will format the data and print all the tickets.The tickets have a very specific size and shape to them, which is why the formatting is important.
I would like it to display the print options screen before it spits out all the tickets. I am not sure if this relates to the macro or my computer settings. If anyone is able to help I would be incredibly grateful!