I have two excel sheets. One has Server Names only.
Second has server names with other columns with more data like OS,Supplier,Application running.
1st sheet is imp and dont want to change or remove any severs.
I want to match 2nd sheet.If server if 1st sheet matches with server in 2nd sheet, i want to put all other columns in front of Server so I will have one list with all details
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com,http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book.