GoKats78
11-05-2008, 05:39 AM
I have a columns of data that contains sequential numbers...sort of..
What I have had is to tabs that contain very similar data but the "identifier" column uses sequential numbers but starts with a different first letter..
Example:
Tab 1 contains data in Column A that is number starting with C08001, C08002, C08003, and so on (this tracks Customer Issues)
Tab 2
Tab 1 contains data in Column A that is number starting with IH08001, IH08002, IH08003, and so on. (this tracks In House Issues)
I have been directed to merge these onto one tab. But I need to maintain the unique first letter for each of the two types of issues.
For example, I have a customer issue and the last C08XXX number is C08111, I need to have the Column A automatically populate with C08111 even when there are a number of In-House issues (IH08XXX numbers) since the last customer issue.
Any thoughts?
What I have had is to tabs that contain very similar data but the "identifier" column uses sequential numbers but starts with a different first letter..
Example:
Tab 1 contains data in Column A that is number starting with C08001, C08002, C08003, and so on (this tracks Customer Issues)
Tab 2
Tab 1 contains data in Column A that is number starting with IH08001, IH08002, IH08003, and so on. (this tracks In House Issues)
I have been directed to merge these onto one tab. But I need to maintain the unique first letter for each of the two types of issues.
For example, I have a customer issue and the last C08XXX number is C08111, I need to have the Column A automatically populate with C08111 even when there are a number of In-House issues (IH08XXX numbers) since the last customer issue.
Any thoughts?