Hello community members,
I am using Excel 2003 (and have access to Excel 2007 too) and would like to to graphically map out the precedents of a cell and make a flow chart of the data paths used in the calculation of this cell -- preferably in a separate Excel worksheet.
My initial thought was to use the "Trace Precedents" function within Excel but this proved to be too messy and difficult to transfer to a chart for my presentation. Also, the precedents of this cell use data from other worksheets within my workbook which also negate the "Trace Precedents" functions because a line trace will not follow data from another worksheet....
I have attached the Excel file I am working with. The cell I am referring to is C304 in the "Valuation BEZ" worksheet.
Any ideas or help will be greatly appreciated! Much thanks,
Nick
Bookmarks