Excel 2010 Series question
Closed
Hello,
I have a question. I have an excel spreadsheet with 25 columns of information. There are anywhere from 3500 to 4000 rows of information. The 1st column contains a business unit: PS005, PS006, PS020, etc. These are not sequential. The 3rd column contains an invoice number: 0168316IN. In this case, the 3500 to 4000 rows all contain the same invoice number. Here is my dilemma. Our accounting department needs a unique invoice number for each 500 lines of the same business unit or if a change of business unit occurs. When we change the invoice number, we basically add an "A", "B", "C", etc. after the original invoice number, so in this case, it would be 0168316INA. My dilemma is this is very time consuming to manually do this. Is there any way to run a macro or code to do this for me once I have the document completed. Is there some way to automatically add the "A", "B", "C", etc. for me? I haven't been able to figure out a way so I am asking for help.
Thanks for all the input!
I have a question. I have an excel spreadsheet with 25 columns of information. There are anywhere from 3500 to 4000 rows of information. The 1st column contains a business unit: PS005, PS006, PS020, etc. These are not sequential. The 3rd column contains an invoice number: 0168316IN. In this case, the 3500 to 4000 rows all contain the same invoice number. Here is my dilemma. Our accounting department needs a unique invoice number for each 500 lines of the same business unit or if a change of business unit occurs. When we change the invoice number, we basically add an "A", "B", "C", etc. after the original invoice number, so in this case, it would be 0168316INA. My dilemma is this is very time consuming to manually do this. Is there any way to run a macro or code to do this for me once I have the document completed. Is there some way to automatically add the "A", "B", "C", etc. for me? I haven't been able to figure out a way so I am asking for help.
Thanks for all the input!
Related:
- Excel 2010 Series question
- Microsoft office 2010 free download - Download - Office suites
- Save as pdf office 2010 - Download - Other
- Best scandinavian crime series on netflix - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Microsoft publisher 2010 free download - Download - Publishing
1 response
Yes, create a column that has A, B, C in the first three rows. Then select those three and copy till 4000 rows. This will generate unique A,B,C etc. for you. Then create another column and in that column write a forumla that concatenates the invoice column and the new column with A,B,C etc. This way you have it.
Mar 8, 2012 at 08:48 AM