Hello Experts,
I am looking for a solution to combine 2 'live' trackers that get updated by 2 separate teams.
I have a "Team-A.xlsx" report which gets updated by 5 team members, hosted on a SharePoint.
In this spreadsheet, I 'mirror' few Columns (A,B,C,E,F & I) from 'BaseData-A' to 'Combined-AB' tab.
Now a new team came in & they have a new 'Team-B.xlsx' as their tracker in SharePoint.
I have mirrored the same Col as used in 'Combined-AB' ; into 'Mirror-B' tab.
My intention is to:
a) combine both mirrored sheets.
b) add data from 'Mirror-B' into 'Combined-AB',
c) when the 1st non-blank cell from 'BaseData-A' is encountered.
b) only when 'Col-B' in 'Mirror-B' of "Test'B.xlsx" has Status "New" & "InProgress".
I am only so much a programmer in Excel... & looking to your expert help.
Thanks in advance.
I am looking for a solution to combine 2 'live' trackers that get updated by 2 separate teams.
I have a "Team-A.xlsx" report which gets updated by 5 team members, hosted on a SharePoint.
In this spreadsheet, I 'mirror' few Columns (A,B,C,E,F & I) from 'BaseData-A' to 'Combined-AB' tab.
Now a new team came in & they have a new 'Team-B.xlsx' as their tracker in SharePoint.
I have mirrored the same Col as used in 'Combined-AB' ; into 'Mirror-B' tab.
My intention is to:
a) combine both mirrored sheets.
b) add data from 'Mirror-B' into 'Combined-AB',
c) when the 1st non-blank cell from 'BaseData-A' is encountered.
b) only when 'Col-B' in 'Mirror-B' of "Test'B.xlsx" has Status "New" & "InProgress".
I am only so much a programmer in Excel... & looking to your expert help.
Thanks in advance.