I have a workbook with multiple worksheets with a macro that extracts data from each worksheet, the data is than pasted into the extract' worksheet in the same workbook.
A change in requirements has resulted in the sheets being moved into new workbooks with each workbook being renamed daily with the suffix of the date.
All workbooks will remain in the same folder
There is still a requirement for the data to be collected in the COMMSMAST - Copy workbook
I have attached an abridged version of the model showing how the core LOOKUP value in column A of the 'LIST COMMS' sheet will need to be changed to the format shown in column I of the sheet 'ADMINISTRATION'
The present macro works perfectly, all I need help with is how to include the instruction to OPEN each of the workbooks shown in column B of the 'ADMINISTRATION' before the existing macro is applied.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.