audit

Hello Everyone. Hope you had a good thanksgiving! So this is something I do each month. It's all done in VBA except for 1 aspect which I have trouble fathoming how one would even go about coding. So for now, I do it manually :mad:. This is a small example of the data...

Hello. I have a database containing 3 Make Table queries. I'd like to track each time this is performed. I'd like the query name and the date/time it was run to be captured in a separate table automatically when the query is run. I've seached through the forums and haven't found the answer. I'm...

Hi I have a fairly large (33Mb) and complex workbook which has stopped allowing me to trace dependents on some formulas. Trace precendents is still working however. Note that this isn't that the functionality is 'dimmed', it is that the application states that there are no dependents when...

Hi All, Very frustrating problem: the trace audit tools in my worksheet are all greyed out for some reason (trace precedents, dependents). The worksheet is not protected. It does have probably a couple hundred Index/Match functions throughout the book. I've seen people give suggestions...

Hi, We are about to move into a new building and so have recently completed an audit of our existing equipment and furniture. Now that has been completed, we are needing to compare this with the list of what is required for the new building. The Audit sheet lists every item, by its item code...

Hi, I'm trying to check somebody else's excel workbook using the Audit (trace precedents / dependents). Unfortunately, when the cell has a dependent on another sheet within the same workbook, it only shows a wee spreadsheet symbol. It doesn't even give a hint as to which other sheet this...

Okay, don't know if that Title will do it. However hopefully someone can help me with the following. I think it is conditional formatting that I want to use, but it doesn't seem to be quite right. I have a row of numbers and I want to have the system notify me or colour the cell or in some way...

Does anyone know of a "trace dependents" option which will track all 'downstream' dependents for a particular cell? I am trying to debug a complex workbook where cause and effect can be separated by about 10 hops/sheets. I appreciate that this can be a long list and follow many different legs...