Identify where the data in a cell was collected.

NoSparks · #1 07-26-2024, 10:44 AM

You would be far better to attach the workbook rather than a picture of the workbook.

MattCream75 · #2 07-30-2024, 09:12 AM

Thank you for the advice. I made a simple workbook using the same concept that we use in our Time keeping workbook. Maybe this will help.

MattCream75 · #3 07-30-2024, 10:56 AM

A thought I had about this:

Is there a way to generate a Dynamic Note/Comment in the cell that would display the sheet names that have values that are contributing to the cell data?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Excel to Audit Data Responses (IF and THEN identify wrong answers)	tdeogburn	Excel Programming	0	01-25-2022 04:33 AM
VBA Word : identify empty cell and aply specific format	Denalei	Word VBA	2	01-05-2022 12:41 AM
How to restore collected addresses	Atom	Outlook	0	10-22-2021 11:56 AM
How to identify Overlap Dates data	golden618	Excel Programming	0	10-28-2015 04:34 AM
Identify last blank cell in column	mbesspiata	Excel	0	02-27-2015 11:29 AM