samuraikata
New Member
- Joined
- Nov 12, 2015
- Messages
- 2
Hello,
I have a workbook with several sheets: AP, AR, GL, Expenses which all contain information about KPIs for different companies.
Column A in each of the above sheets is a concatenation between columns B & C (used as a unique key for vlookup in other sheets which generate graphs).
Column B contains a list of company names.
Column C contains different categories for KPIs
Columns D to AS contain month-year - the idea is that people need to input numbers for each category for each company.
What I need is a macro which selects all rows (regardless of whether they are empty or not) for each company from each of the AP, AR, GL, Expenses sheets and copy them into a separate workbook which will contain data only for 1 company. So, the result should be - a new workbook with sheets AP, AR, GL, Expenses for company ABR only and all these sheets contain rows with data about only company ABR.
Can anybody help with the code please?
Thank you.
I have a workbook with several sheets: AP, AR, GL, Expenses which all contain information about KPIs for different companies.
Column A in each of the above sheets is a concatenation between columns B & C (used as a unique key for vlookup in other sheets which generate graphs).
Column B contains a list of company names.
Column C contains different categories for KPIs
Columns D to AS contain month-year - the idea is that people need to input numbers for each category for each company.
What I need is a macro which selects all rows (regardless of whether they are empty or not) for each company from each of the AP, AR, GL, Expenses sheets and copy them into a separate workbook which will contain data only for 1 company. So, the result should be - a new workbook with sheets AP, AR, GL, Expenses for company ABR only and all these sheets contain rows with data about only company ABR.
Can anybody help with the code please?
Thank you.
