View Single Post
 
Old 03-13-2020, 03:57 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 171
ganesang is on a distinguished road
Default 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
Attached Files
File Type: xlsx Maintracker.xlsx (10.8 KB, 11 views)
File Type: xlsx XT.xlsx (9.7 KB, 7 views)
File Type: xlsx SB.xlsx (9.7 KB, 7 views)

Last edited by ganesang; 03-13-2020 at 08:09 AM.
Reply With Quote