Hello all.
I have setup 2 tabs (and I will setup more) for my team members to log entries on tab's with their names on.
I need to combine this onto one master tab to be able to have a glance at everyone's entries on one tab
How can I do this? I have attached my sheet with 2 tabs that are identical with different team member names and a third tab of how I envisage this looking. Essentially, it needs to combine the two tabs into one tab. hope this makes sense and thank you!
Thanks,
R.
Your file suggests this is (could be) a calendar month report so do you require monthly summary tabs?
How many employees (and hence tabs to combine)?
In A7 of master sheet copied to entire range till blank rows are seen.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Try A7
=FILTER(IFERROR(FILTERXML("<x><m>"&TEXTJOIN("</m><m>",0,Granit:Judith!A7:A99)&"</m></x>","//m"),""),ISTEXT(FILTERXML("<x><m>"&TEXTJOIN("</m><m>",0,Granit:Judith!$A$7:$A$99)&"</m></x>","//m")))
Due to the text length limit of 32768 characters, this formula only combines up to 1000 rows of data.
more that 1000 require Power Query or VBA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks