parth007
01-07-2015, 04:26 AM
Need to write a VBA or below..
My Macro sheet name which have Button is known as Summary
Summary Workbook have Command button..
Now When user clicks this command button then below should be done..
1) After button click Vba should ask for the other file to be open
2)Once user select file path Vba should open the file & ask for sheet name on which user want to work.
3) Once sheet is selected & active then VBA should consider two columns
Column "J" & Column "M" and check the row difference and highlight it.
Attached is the Summary workbook & Input workbook.
Note - The Input workbook and sheet name may be by any name..
User should manually select Workbook & Sheet in it
Can anyone please suggest on this
My Macro sheet name which have Button is known as Summary
Summary Workbook have Command button..
Now When user clicks this command button then below should be done..
1) After button click Vba should ask for the other file to be open
2)Once user select file path Vba should open the file & ask for sheet name on which user want to work.
3) Once sheet is selected & active then VBA should consider two columns
Column "J" & Column "M" and check the row difference and highlight it.
Attached is the Summary workbook & Input workbook.
Note - The Input workbook and sheet name may be by any name..
User should manually select Workbook & Sheet in it
Can anyone please suggest on this