Transfer data to another book based on the active cell - Specific ranges only
Hi Folks,
I need your help to automate this task based on the Excel VBA.
I have the master excel workbook named as "Maintracker" which needs to be move specific data ranges (ranges are dynamic so we have to select a range based on the current selection cell) in each row (F2:G2) based on the current cell selection to another respective workbook named as "SB" and "XT" vice vara if click the specific button in Maintracker we create.
I have attached the three sample files as mentioned above and highlighted in yellow.
In case I have new data in Maintracker which is also needed to move respective workbook based on the Main tracker workbook "Engine Name" column value (SB or XT) when I click the button at the end of the row in the respective workbook.
Additionally if try to copy any duplicate row Vb yes or no pop up will ask yo confirm.
Please review and let me know.
Advance thanks!!!
Ganesan. G
Last edited by ganesang; 03-13-2020 at 08:09 AM.
|