Hi all
Thank you in advance for looking at this. I require assistance to clean up a report and allocate data from the ‘Export’ sheet into various other sheets depending on their allocation of ‘code by manager’.
The only data to be replicated is from columns ‘B’, ‘C’, ‘D’, ‘E’ and ‘K’ of the ‘Export’ sheet. This is then transferred to the relevant manager’s sheet.
In the attached sheet, I need the data replicated into each of the relevant sheets, i.e. ‘RRRR’, ‘BBBB’, ‘DDDD’, ‘AAAA’ etc. based on the ‘Code by Manager’ allocations. All columns in the ‘Export’ sheet marked in line 1 with an “x” also contain data that is not required.
In the first instance, the data to be replicated must be a “Yes” in coulmn ‘K’ of the ‘export’ sheet. If it is “No” in column ‘K’, then it is to be disregarded.
Samples of the outcome (not everything) is provided in each of the relevant sheets.
There may be instances of a code not being represented in the ‘code by manager’, if this occurs can the line in the ‘Export’ sheet be highlighted with "a colour" or "a new sheet created" with the non-represented codes listed? I’m open to suggestions.
Thanks again for your support, regards.
Bookmarks