I have a excel sheet where Sheet 2 named as 'master sheet' and sheet 3 named as 'revenue data'. I want to enter the company name in cell G2 in sheet 1 which will search the same name in column F of 'Master Sheet' and paste it in sheet 1 below master header. Similary the value of G2 needs to be searched in column B of 'Revenue Sheet' and then paste it in the sheet 1 below Revenue header.
Fro example: if I write 'Moto' in cell G2 and on clicking on Submit button then Moto name should be searched in both the Master & Revenue sheet and output should be pasted in the sheet 1 below each headers.
I don't have any knowledge of macro. Can you please help me in creating macro for the same
Fro example: if I write 'Moto' in cell G2 and on clicking on Submit button then Moto name should be searched in both the Master & Revenue sheet and output should be pasted in the sheet 1 below each headers.
I don't have any knowledge of macro. Can you please help me in creating macro for the same