I have a large data file which contains lots of data relating to individual companies.I am using a macro to create reports which contain two summary sheets which generate a summary of information for each company. These summary sheets work using lookups to populate cells based on a number i have assigned to each company. the macro is triggered by enter the company number into a cell.
What i would like to do is use a loop to run through and automatically create the reports for each company.
I have a list of the companies and i need a loop to run through that list take the number and paste it into another cell which will then trigger the creating of the report, i need this to repeat down a column for each company.
What i would like to do is use a loop to run through and automatically create the reports for each company.
I have a list of the companies and i need a loop to run through that list take the number and paste it into another cell which will then trigger the creating of the report, i need this to repeat down a column for each company.