Taking my first steps in VBA and Get & Transform Data functionalities in Excel 2016.
I have 2 Excel workbooks (different files) - a transport note (template.xlsm) and the second one for the entire log or history (log.xlsx). I need the rows from the transport note to be copied into the workbook with the entire history. Doing it manually is clearly not ideal with the added risk of overwriting an existing row. I also prefer not to open the history file for this process if possible.
Could you advise me if it would be possible or more feasible to handle this via VBA or can an Excel Get & Transform functionality do this (in this case, push the data out from the template file to the log file)? I have some experience with VBA, so running a macro to select the necessary rows in template.xlsm is not a problem, but not sure how to proceed to copy from one file to another as seamlessly as possible. I will add a screenshot to illustrate this:
I have 2 Excel workbooks (different files) - a transport note (template.xlsm) and the second one for the entire log or history (log.xlsx). I need the rows from the transport note to be copied into the workbook with the entire history. Doing it manually is clearly not ideal with the added risk of overwriting an existing row. I also prefer not to open the history file for this process if possible.
Could you advise me if it would be possible or more feasible to handle this via VBA or can an Excel Get & Transform functionality do this (in this case, push the data out from the template file to the log file)? I have some experience with VBA, so running a macro to select the necessary rows in template.xlsm is not a problem, but not sure how to proceed to copy from one file to another as seamlessly as possible. I will add a screenshot to illustrate this:
