I have a workbook with sheets 5 - 34 that have text on each sheet (cells F70 to F84), on each sheet.
Some of these cells will have text, most will be blank.
What I need is to have any and all of the the text in these cells (F70:F84) of each sheet, (in this case sheets 5 through sheet 34), show up on sheet 35, in one section (and without the blank lines). Starting on 35 - BX7 (pasted down).
So sheet 35 would have a "summary" of all the text on sheets 5-34 (of the F70 : F84 lines), but with no blank lines.
Note: My sheets are just labeled 5,6,7,8,etc,
I am using excel 2007
Bookmarks