VBA Code to Pick data from one sheet and update data in another sheet accordingly.

[tvsreekanth]

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.

[p45cal]

cross posted: http://www.vbforums.com/showthread.php?742943-VBA-Code-Copy-data-from-one-sheet-and-update-in-another-sheet-based-on-criteria where thare are already 5 replies.

tvsreekanth, some light reading: http://www.excelguru.ca/content.php?184, and do what you need to do.