Microsoft Office Questions? Ask a IT Expert for Support ASAP
No It is not that simple.
Please see attached file with sheet A and Sheet B
I want to replace Item Code (Column I) and Dept (Column J) in sheet B with the Data from Sheet A where Sheet B Coulmn A Matches SheetA Column A)
You did exactly what I need.
How I can read the content of Macro?
Thanks a lot.
I may use this small Macro for different excel data basis after making changes in mthis small program (Macro) as per my requirements.
To do this what kaind of basic program I need and How I open that utility and how I save that Macro after modifications...