Jobsite Calendar.xlsxI have a question. My boss uses an Excel spreadsheet for a calendar for production jobs at our glass fabrication plant. He has me enter the information into the calendar and also have to put the name of the company and name of the job on a tag that we print out. I would like to automate the process. By this I mean I would like to put the company name and job name in to the calendar and then have it copy them to another sheet which I can then use as a mail merge to make the tags.
The cells colored yellow are the company name and the cell below that the job name. I want to have the code copy all those cells to the other sheet. These cells would have to be transposed because they are in the same column on Sheet1 and I need them in the same row on Sheet2. Is there a way to do this as it is edited- like after you enter the company name and job name?
I tried using Range(ActiveCell.Offset(0,0), ActiveCell.Offset(0,1)).Select.Copy to copy the cell I have highlighted and the one below it. I really have no idea how to do this. I'm just trying to minimize the workflow. Please help.