Data from multiple sheets into one sheet

[Abbas]

Hi,

I have made an excel file which contains a different supplier's information on each sheet, along with one of the categories approved, conditionally approved, conditionally rejected and rejected. Now I want one summary sheet to display a list of all the suppliers that are either approved or conditionally approved. If I change the category of any supplier from approved to rejected, it should be removed from the list in summary sheet. The supplier's name could be on say A1 and its category on G7 of each supplier sheet.

 

[Faseeh]

Hi Abbas,


Do you have sheets named on status or you have multiple sheets each containing diff. status?? Upload a sample file. It will help members to give you a solution.


Regards,

 

[Abbas]

Hi Faseeh,

I hav named the sheets on supplier's name. It can be Sheet1, Sheet2 and so on as an example...

 

[Faseeh]

Hi Abbas,


I suggest you following, as you are only interested in updating Status (that i assume will be a single cell containing some data):


1. Create a sheet with name of Name of Suppliers.

2. Add this formula against each:

=INDIRECT(A1&"!E1")

, here A1 is the name of Supplier and E1 is the cell that contains the status, and drag down this formula. The result will be updated automatically.


Should there be any problem, let me know.


Regards,

 

[Abbas]

Yes this one's good. But I want only the list of names that are approved or conditionally approved.

 

[nazmul_muneer]

Dear Abbas

Would you kindly upload a sample file?


Regards


Muneer