mountainman88
Board Regular
- Joined
- Jun 22, 2019
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
I have 3 sheets: Sheer A, Sheet B and a sheet called Consolidation.
Using a single formula in A1 of Consolidation that I can drag across and down how can I pull just the rows of A and B that contain the text ‘import’ in Column B. Let’s say we only need columns A to H to be brought in (not the whole row).
If sheet A had 100 rows and 50 with the text ‘import’ in Column B;
and sheet B had 60 rows and 25 wijt the text ‘import’ in Column B
Then Consolidation end result would pull 75 total lines (columns A to H): the 50 import lines from Sheet A followed by the 25 import lines from Sheet B.
thanks
Using a single formula in A1 of Consolidation that I can drag across and down how can I pull just the rows of A and B that contain the text ‘import’ in Column B. Let’s say we only need columns A to H to be brought in (not the whole row).
If sheet A had 100 rows and 50 with the text ‘import’ in Column B;
and sheet B had 60 rows and 25 wijt the text ‘import’ in Column B
Then Consolidation end result would pull 75 total lines (columns A to H): the 50 import lines from Sheet A followed by the 25 import lines from Sheet B.
thanks