Reporting lack of documents

[jaryszek]

Hi People,

I have problem with reporting lack of documents.

Process:

1. User have workbook where he inputs new records: Name of Employee, Process, Working Area, Company etc.
2. For each record, row you have about 40 documents in columns.
3. In different columns user inputs different status of documents but most important is lack of document (in red):

lack.jpg

It is working very good, but client wishes to have also date of arrival - when specific document was delived by client.
And here we have a problem.

I have one row, a lot of columns with documents (in attachment example workbook) and date of entry one row (automatically by macro when whole file is sent to Access database).

How can i register if in this one row within one document there was a change from status "brakujący" (lack) to other?
From first sheet (Główny) i can create pivot table (macro is doing that) and maybe there i have to check if specific record was change ?

Any ideas will be welcomed,
Warm Regards,
Jacek Antek

[jaryszek]

Hi People,

I have problem with reporting lack of documents.

Process:

1. User have workbook where he inputs new records: Name of Employee, Process, Working Area, Company etc.
2. For each record, row you have about 40 documents in columns.
3. In different columns user inputs different status of documents but most important is lack of document (in red):

Attachment 481569

It is working very good, but client wishes to have also date of arrival - when specific document was delived by client.
And here we have a problem.

I have one row, a lot of columns with documents (in attachment example workbook) and date of entry one row (automatically by macro when whole file is sent to Access database).

How can i register if in this one row within one document there was a change from status "brakujący" (lack) to other?
From first sheet (Główny) i can create pivot table (macro is doing that) and maybe there i have to check if specific record was change ?

Any ideas will be welcomed,
Warm Regards,
Jacek Antek