Hi Guys,

I have rewritten my words here more clearly to sort out a clear understanding.

I need the two-way transfer/copy some specific ranges of data as follows.

Maintracker to Sub-excel (SB or XT) ranges - (D:E:F)

Sub-level excels to Main-tracker ranges - (A:B:C) (from both SB and XT to the main tracker)

I have a master excel file (Maintracker) which has the data to be moved some specific ranges (E:F:G) to respective sub excel files (XT, SB) vice vara based on the current cursor position in master file column "E". Please refer the attached sample files for the references.

Also if any range of data duplicate if try to transfer both ways the msgbox alert (yes or no) will appear to confirm based on the column B value which has some time more than one check required.

Please help me out on this as soon as possible is great!!!