I have a spreadsheet report that contains info from cells A-P (some cells are merged).
The report links to another spreadsheet in the workbook and enters the values in cells A8-A2020. Most of the time not all values are filled in, but sometimes they may be so I need to keep the formulas in place. Right now, if the linked cell has no value, the formula returns a blank (used the formula =IF('Raw Data'!A8="","",'Raw Data'!A8). This works except when I try to print, it also prints the blanks so with 1 sheet of actual filled data, it is printing 42 sheets (41 blank sheets). How can I set the range, or use a macro that will ignore the ending blank cells?
Bookmarks