Forum Discussion
Excel 2013 Conditional formatted cell with Indirect function is not recognised by PDF/Printer
Dear, I have created gantt chart with indirect function (because it pulls data from another sheet). The point is I had to do it in that way since second sheet working as database and it always ch...
I'd advise to rethink the way you refer to the other sheet. Perhaps you can use functions like INDEX and MATCH to get the data you need rather than using direct cell references. That way you can also sort the data wothout disrupting your references.