tvsreekanth
11-14-2013, 04:23 AM
Dear All,
I am very new to VBA and wanted a VBA Code to pick data from sheet "Setup" range B17:G500 and copy the same data into another sheet "Readonly_(Overview)". But in sheet "Readonly_(Overview)" we have 5 phases. Hence if the data in sheet "Setup" has ".71 Definition", then then entire row should be updated in the corresponding table in sheet "Readonly (Overview)" i.e. row range (A14:A19). likewise if the data in sheet "Setup" has ".72 Conceptual design", then the entire row should be updated in the corresponding table in sheet "Readonly (Overview)" i.e. row range (A22:A27). Like that all 5 categories should be updated in their respective tables in sheet "Readonly (Overview)".
Also if any table in sheet "Readonly (Overview)" filled up, then it should insert a new row and update the data.
Please let me know the VBA code for this exercise.
Thank you so much for your help in advance.
I am very new to VBA and wanted a VBA Code to pick data from sheet "Setup" range B17:G500 and copy the same data into another sheet "Readonly_(Overview)". But in sheet "Readonly_(Overview)" we have 5 phases. Hence if the data in sheet "Setup" has ".71 Definition", then then entire row should be updated in the corresponding table in sheet "Readonly (Overview)" i.e. row range (A14:A19). likewise if the data in sheet "Setup" has ".72 Conceptual design", then the entire row should be updated in the corresponding table in sheet "Readonly (Overview)" i.e. row range (A22:A27). Like that all 5 categories should be updated in their respective tables in sheet "Readonly (Overview)".
Also if any table in sheet "Readonly (Overview)" filled up, then it should insert a new row and update the data.
Please let me know the VBA code for this exercise.
Thank you so much for your help in advance.