Hello group! I'm doing an Excel spreadsheet in which I posed the following problem, I put a sample of what I have and a sample of what you need to get.
Sheet1 A1: Subject Format: Text A2: Document Code format: AAA-BBB-99 999-L-00001 AAA-BBB-99 999-F-00001 AAA-BBB-99 999-T-00001 AAA-BBB-99 999-E-00001 AAA-BBB-99 999-M-00001 99 999-AAA-CCC-L-00001 99 999-AAA-CCC-F-00001 99 999-AAA-CCC-T-00001 99 999-AAA-CCC-E-00001 99 999-CCC-AAA-M-00001 99999 Where is the project code (no change) AAA-BBB-CCC and AAA are the different destinations there are 6 different L, F, G, E, F are Letters, Fax, Transmitals, E-mails, Moms This is how it should be mounted Excel Now I put an example of how it should be: We started in A2 A2: B2 Invoice Mail: 99999-AAA-BBB-E-00001 A3: B3 Mail Invoice: 99999-AAA-BBB-E-00002 A4: B4 Mail Invoice: 99999-AAA-CCC-E-00001 A5: B5 Mail Invoice: 99999-AAA-BBB-E-00003 A6: B6 Mail Invoice: 99999-AAA-CCC-E-00002 A7: Letter Rejected B7: 99999-AAA-BBB-L-00001 I mean, there we have 3 emails from AAA to BBB the counter is what changes. We also have 2 emails from AAA to CCC the counter increases. We also have a letter from AAA to BBB is 1 meter. I want to know what counter number for each case would be next. That is, having somewhere that if cell A8, I included an email from AAA to BBB would put the 00,004 which is the corresponding. I you can lend a hand? If you need more information I will be here. Greetings and thank you very much! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel