Copy specific data from one sheet to another
I had 2 Sheets in a excel file, Sheet1 & sheet2. I feed records in sheet1 having certain format. I want the records from sheet1 to get copied by using VBA to the sheet2's specific rows / columns.
Here in sheet2, what i need is when i enter the record no. of sheet1 in specific row / column of sheet2, that record of sheet1 should get copied into the sheet2.
Please help me for the same.