Summary sheet by identifying the cell value.

[mayaa_mmm]

I have an order number as (o12) in a separate sheet with details as



[TABLE="width: 497"]
<tbody>[TR]
[TD]Status [/TD]
[TD]UserName[/TD]
[TD]Action[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Marimuthu[/TD]
[TD]Rejected[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Gopi[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Gopi[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Gopi[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Gopi[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Gopi[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD]Gopi[/TD]
[TD]Approved[/TD]
[/TR]
[TR]
[TD]Process[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
I want the summary sheet by providing the rejection (action column) and adjacent cell value (Username). Similarly i have an orders in the separate sheets.

[TABLE="width: 497"]
<tbody>[TR]
[TD]Orders[/TD]
[TD]Action[/TD]
[TD]Username[/TD]
[/TR]
[TR]
[TD]O123[/TD]
[TD]Rejected[/TD]
[TD]Marimuthu[/TD]
[/TR]
[TR]
[TD]O124[/TD]
[TD]Rejected[/TD]
[TD]Gopi[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[texasalynn]

is the order number on the sheet showing the rejected?

 

[mayaa_mmm]

Yes Rejected needs to observe in the report. order is rejected by which user.