I have an Excel worksheet called ModelV1.xlsm. On this worksheet, I have a tab called CompanyInformation and a tab called Lookup. On the Lookup tab, I have company names starting on celll A2 to A367.
What I need:
1) I want to copy the first company name on the lookup tab to CompanyInformation cell P15 (would it help if I give the companies on the lookup tab a name range?)
2) Save ModelV1.xlsm with the first name on my lookup tab in cell A2 to path C:\My Documents
3) Perform items 1 and 2 for all the companies on my lookup tab