Hello everyone,
I am new to VBA. I need help to sort this.
I have a data of workbook 1 which is updated every 4 hours. I have workbook 2 which is Master file. Workbook 1 has like 25 columns with some headers. Workbook 2(Master file) has only 8 columns with same headers as workbook 1. for example: workbook 1 has headers: A,B,C,D,E,G,H,.......Y and Workbook 2 has headers B,F,I,W,C,V,A,K.
headers are present in row 1. I want a VBA code in Master file (Wb2) which compares column headers and updates data row wise.
If for the first time data from wb1 is 10 rows it copies according to the headers in Master file and second time data in wb1 is 20 rows in which 8 rows are are same and already copied. VBA should copy remaining 12 rows.
Thank you.
#
It would be great help if some can help.
I am new to VBA. I need help to sort this.
I have a data of workbook 1 which is updated every 4 hours. I have workbook 2 which is Master file. Workbook 1 has like 25 columns with some headers. Workbook 2(Master file) has only 8 columns with same headers as workbook 1. for example: workbook 1 has headers: A,B,C,D,E,G,H,.......Y and Workbook 2 has headers B,F,I,W,C,V,A,K.
headers are present in row 1. I want a VBA code in Master file (Wb2) which compares column headers and updates data row wise.
If for the first time data from wb1 is 10 rows it copies according to the headers in Master file and second time data in wb1 is 20 rows in which 8 rows are are same and already copied. VBA should copy remaining 12 rows.
Thank you.
#
It would be great help if some can help.