Pull data from one Excel sheet to another automatically -
without using vlookup or index,match,validation functions –
Only with simple VBA codes.
When you enter values of Id in the "GetData sheet's A column", you can get Id's row information from the "Data" sheet .