Hi guys,
I have a workbook with several sheets (one for each month) which contain customer names (all in column A) and I need to bring them all together in another sheet (let's just call it sheet1). Then I need to erase the ones that are double (triple and so on) so I have the customer only once in sheet1 (and have them arranged alphabetically would be nice too). Problem is there are 3 types of customers (one pays in Dollar, one in Yen and one in Peso) and I need them separated. Also after the customers name there are these annoying brackets that I need to erase (for that I already have a macro but it would be nice if it could be implemented or something).
Little example (it looks sort of like this):
So C1,3,4 and 5 are double... I need to erase the brackets with the numbers (for which I have a macro) and then have the range from JPY to MXN copied to one sheet and then MXN to USD copied to another sheet and last from USD to the first empty cell to another sheet. Then have them arranged alphabetically (because obviously they're not called C1...) and erase all that are double or more and then have them all copied (JPY)(MXN)(USD) to another sheet where my calculation formulas are...
Seems kind of complicated now that I read it... Maybe there's a better way... Basically I need to list all customers from all months in one list (each of them just once) and do some calculation for which I have formulas. Listing them is the problem... help would be very much appreciated...
Thank you
I have a workbook with several sheets (one for each month) which contain customer names (all in column A) and I need to bring them all together in another sheet (let's just call it sheet1). Then I need to erase the ones that are double (triple and so on) so I have the customer only once in sheet1 (and have them arranged alphabetically would be nice too). Problem is there are 3 types of customers (one pays in Dollar, one in Yen and one in Peso) and I need them separated. Also after the customers name there are these annoying brackets that I need to erase (for that I already have a macro but it would be nice if it could be implemented or something).
Little example (it looks sort of like this):
So C1,3,4 and 5 are double... I need to erase the brackets with the numbers (for which I have a macro) and then have the range from JPY to MXN copied to one sheet and then MXN to USD copied to another sheet and last from USD to the first empty cell to another sheet. Then have them arranged alphabetically (because obviously they're not called C1...) and erase all that are double or more and then have them all copied (JPY)(MXN)(USD) to another sheet where my calculation formulas are...
Seems kind of complicated now that I read it... Maybe there's a better way... Basically I need to list all customers from all months in one list (each of them just once) and do some calculation for which I have formulas. Listing them is the problem... help would be very much appreciated...
Thank you
Last edited: