Hi All
I have another tricky puzzle I'm trying to solve (or tricky for me anyways).
I have a workbook with about 30 sheets. The first sheet has a list of customer numbers in the first column. All other columns in this sheet use the vlookup to pull data from the other sheets of the workbook.
In the first columns, there are three types of data, numeric, alpha, and alpha numeric. The column is sorted into an ascending order. for example;
23
45
58
1A
C1
E1
ON
X3
All of the numeric values can have a lookup individually, but I need to write something that allows me to total 1A and ON together, and total everything that is alpha numeric together so they all appear on the same line. It's a little beyond my VB coding skills at the moment! I can send an example spreadsheet with the existing code if anyone thinks they can help?
Also, I'm using Excel 2003
I have another tricky puzzle I'm trying to solve (or tricky for me anyways).
I have a workbook with about 30 sheets. The first sheet has a list of customer numbers in the first column. All other columns in this sheet use the vlookup to pull data from the other sheets of the workbook.
In the first columns, there are three types of data, numeric, alpha, and alpha numeric. The column is sorted into an ascending order. for example;
23
45
58
1A
C1
E1
ON
X3
All of the numeric values can have a lookup individually, but I need to write something that allows me to total 1A and ON together, and total everything that is alpha numeric together so they all appear on the same line. It's a little beyond my VB coding skills at the moment! I can send an example spreadsheet with the existing code if anyone thinks they can help?
Also, I'm using Excel 2003
