Summarising where data is being pulled from

Good Day,

I hope you well.

I require your assistance, i have a large data set which sums together random lines from a separate worksheet

i would like to know if its possible to obtain a summary of which lines each cell is pulling data from without having to manually trace back to the cell using the formula.

Your Assistance and advise in this matter will be greatly appreciated


Thanking You

N.Loonat

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Without seeing your data I can only give you the bare minimum. I would start out with =FormulaTEXT(A1). Where A1 is the cell the data is in. THis formula will show what the formula in that cell is, in Text form. From here you could use =Left() =mid() and other lookup and text formulas to narrow down and beautify your results.

I thank you for your response, I have created and attached a sample file (with the before and after tabs)

Thank You Once Again i truly appreciate your assistance.

Originally Posted by Pepe Le Mokko

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Originally Posted by dosydos

Without seeing your data I can only give you the bare minimum. I would start out with =FormulaTEXT(A1). Where A1 is the cell the data is in. THis formula will show what the formula in that cell is, in Text form. From here you could use =Left() =mid() and other lookup and text formulas to narrow down and beautify your results.

I thank you for your response, I have created and attached a sample file (with the before and after tabs)

Thank You Once Again i truly appreciate your assistance.