I am not sure if this is something that is even possible with excel, but I figure I'll ask and see if those who are more familiar with it might know better than me.
All of my orders are downloaded as a single csv file into a workbook called Orders.
I need to transfer each of those orders to another workbook called Forms that has additional references from other workbooks and calculations, etc, and then save it as a PDF.
I was wondering if it would be possible to create a VBA code that would be able to recognize each group of matching order #s, create a new sheet for each group on my Forms workbook and then fill in the information for the order accordingly.
The way that I currently handle it is I have my Forms workbook set up to reference the rows in my Orders workbook. It only references the following rows that have a matching order number that is in the top row. I then save the Forms worksheet as a PDF and manually delete the rows for that order so that the next order group is moved up.
Example below. Workbook on the right side is Orders and workbook on the left is Forms.
All of my orders are downloaded as a single csv file into a workbook called Orders.
I need to transfer each of those orders to another workbook called Forms that has additional references from other workbooks and calculations, etc, and then save it as a PDF.
I was wondering if it would be possible to create a VBA code that would be able to recognize each group of matching order #s, create a new sheet for each group on my Forms workbook and then fill in the information for the order accordingly.
The way that I currently handle it is I have my Forms workbook set up to reference the rows in my Orders workbook. It only references the following rows that have a matching order number that is in the top row. I then save the Forms worksheet as a PDF and manually delete the rows for that order so that the next order group is moved up.
Example below. Workbook on the right side is Orders and workbook on the left is Forms.
