I have two workbooks, one is my data and the other is report from random
areas of my data. I am using the following formula to pull information:
=IF(ISBLANK('[Data.xlsx]Sheet!$F318),"",'[Data.xlsx]Sheet'!$F318)
The column is stationary, but sometimes there are a few rows that I can fill
with data. I need the blank cell if there is nothing in my data file, and the
data I am using is Text, Dates, and numbers so traditional conditional
formatting was not sorting out blanks. An example would be:
=IF(ISBLANK('[Data.xlsx]Sheet!$F318),"",'[Data.xlsx]Sheet'!$F318)
=IF(ISBLANK('[Data.xlsx]Sheet!$F319),"",'[Data.xlsx]Sheet'!$F319)
=IF(ISBLANK('[Data.xlsx]Sheet!$F341),"",'[Data.xlsx]Sheet'!$F341)
=IF(ISBLANK('[Data.xlsx]Sheet!$F348),"",'[Data.xlsx]Sheet'!$F348)
€¦ and so on.

Some cells already have existing links others are blank.
Is there a more efficient way of ether adding the formula to existing cells?
OR
Changing reference cell other than going in to formula and changing number?
(i.e. the = + Click on data cell used to create reference)