code for VBA

[Geetanjali]

how to show data from one sheet to another in excel using vba on entering specific value and then pressing enter

 

[Sathish KV]

Hi,

A VBA is not required to achieve this. You can just select both the sheets and while typing in one sheet will copy the same to another

 

[Geetanjali]

Hi,

A VBA is not required to achieve this. You can just select both the sheets and while typing in one sheet will copy the same to another

thanks for your answer but i want the user to enter a value say a range from 1000-2000 and in the other sheet i have defined some text according to range so i want that range to come upon entering a value from user.

 

[Sathish KV]

Hi,

Could you upload a sample file!