Recent DiscussionsNewest TopicsMost LikesSolutionsexcel agnt n l b h Amount 1 1 2 5 2 20 1 2 5 2 20 Total 40 2 1 2 3 2 12 1 2 5 2 20 Total 32 3 1 2 4 2 16 Total 16 1 1 8 5 2 80 1 2 5 2 20 Total 100 1 1 8 10 2 160 1 2 5 2 20 Total 180 return amount while changing column column 1 (agt) Solvedexcel search by code and combine result in another sheet eg 1.1.16 search as 1.1 and 1.1.16 and combine result sw pipe 100 mm dia lead-5 km vba function search code 1.1.2 and by 1.1 and 1.1.2 and combine result of both of them vba function search code 1.1.2 and by 1.1 and 1.1.2 and combine result of both of Excel sheethow to find page number of cell that is linked from another work sheet.return page number of cell that linked from another sheets ,any vba function ?