Amenolakaky
New Member
- Joined
- Feb 17, 2022
- Messages
- 14
- Office Version
- 2016
- Platform
- Windows
First of all I would like to give a big thanks to all of you specially "DanteAmor" who helped me !
second, New i need to call the largest number from another sheets and add +1, these numbers in sheets named by companies name
I will set formula says; =IF(AND($G$4="ALEX";$H$4="Life");LARGE([Submissiondatabasee.xlsx]Alex!$P:$P;1);IF(AND($G$4="ABK";$H$4="Life");LARGE([Submissiondatabasee.xlsx]ABK!$B:$B;1)
is there any code can it ?
sheet one named "Alex", its range contain 10001, 10002, 10003, i need to call 10003 and add one= the result is 10004" Looked to this sheet based on two logics " Sheet name" and " first number if serial "10"....
sheet two named "abk", its range contain 440001, 440002, 440003, i need to call 440003 and add one= the result is 440004" Looked to this sheet based on two logics " Sheet name" and " first number if serial "440"....
second, New i need to call the largest number from another sheets and add +1, these numbers in sheets named by companies name
I will set formula says; =IF(AND($G$4="ALEX";$H$4="Life");LARGE([Submissiondatabasee.xlsx]Alex!$P:$P;1);IF(AND($G$4="ABK";$H$4="Life");LARGE([Submissiondatabasee.xlsx]ABK!$B:$B;1)
is there any code can it ?
sheet one named "Alex", its range contain 10001, 10002, 10003, i need to call 10003 and add one= the result is 10004" Looked to this sheet based on two logics " Sheet name" and " first number if serial "10"....
sheet two named "abk", its range contain 440001, 440002, 440003, i need to call 440003 and add one= the result is 440004" Looked to this sheet based on two logics " Sheet name" and " first number if serial "440"....