ahmetk
Member
Dear Excel Gurus hi,
I have a long list of a data that shows over 4000 of incident in different locations reported by close to different 1000 person. Each row has contact (person), location, problem, description and date of a specific issue reported.
Now I have been asked to prepare a single "report" for each row.
Is it possible to formulate a tab that each time I create an a new one (report #xxxx), it automatically copies the related following datas from the data tab (Problem tracking)?
At the attachment I am sharing the excel file. "Report #xxxx" tab is the report that needs to be created thousands of times
, "Problem tracking" tab is the raw data.
I would very appreciate if you could kindly share your expertise with me.
Kind regards
Ahmet K
I have a long list of a data that shows over 4000 of incident in different locations reported by close to different 1000 person. Each row has contact (person), location, problem, description and date of a specific issue reported.
Now I have been asked to prepare a single "report" for each row.
Is it possible to formulate a tab that each time I create an a new one (report #xxxx), it automatically copies the related following datas from the data tab (Problem tracking)?
At the attachment I am sharing the excel file. "Report #xxxx" tab is the report that needs to be created thousands of times
I would very appreciate if you could kindly share your expertise with me.
Kind regards
Ahmet K