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.
This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
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.