Hi,
I have a workbook which is used for audits. It has a summary table I am needing help on. My workbook is a year running total, with a summary sheet that identifies errors identified by the analyst during the audit. Currently, the data is imported from a CSV file. Manually reviewed by audit. The errors are logged in one column. Then if there is an error some key points are transferred manually to a summary sheet. I would like to create a formula, macro or ? to auto transfer this information. However, since there are 5 possible errors per row, I need a formula that will review those 5 fields and only transfer the data if there is a match. If not, I then need it to move to the next row of information. There are 20 columns and 31 rows per sheet. Any help or ideas would be appreciated.
thank you for your time.
Bookmarks