Hello,
I am attempting to put together a macro in order to automate the following steps:
We receive a report daily. Henceforth Workbook 1.
Workbook 1 will have columns A and B, for "Sales Order" and "Line"
I would like to concatenate these into a column in front of A, then insert a column between "Sales Order" and "Line" named "Notes" or "Comments"
Therein, the user can insert their notes. The next day, we would receive Workbook 2. Many of these "Sales Order" and "Line" will be the same - rather than redo or copy/paste every note, I would like to find a way to pull over the notes from Workbook 1 into a similar column in Workbook 2. Thereafter, it would be able to go from Workbook 2 to Workbook 3 the ensuing day, and so forth.
Is there a way to do this, and does the sheet name factor in here? For instance, I would name Sheet A on Workbook 1 a certain way, if I did not name Sheet A on Workbook 2 the same would it cause an issue?
Any advice would be greatly appreciated
I am attempting to put together a macro in order to automate the following steps:
We receive a report daily. Henceforth Workbook 1.
Workbook 1 will have columns A and B, for "Sales Order" and "Line"
I would like to concatenate these into a column in front of A, then insert a column between "Sales Order" and "Line" named "Notes" or "Comments"
Therein, the user can insert their notes. The next day, we would receive Workbook 2. Many of these "Sales Order" and "Line" will be the same - rather than redo or copy/paste every note, I would like to find a way to pull over the notes from Workbook 1 into a similar column in Workbook 2. Thereafter, it would be able to go from Workbook 2 to Workbook 3 the ensuing day, and so forth.
Is there a way to do this, and does the sheet name factor in here? For instance, I would name Sheet A on Workbook 1 a certain way, if I did not name Sheet A on Workbook 2 the same would it cause an issue?
Any advice would be greatly appreciated