Hi all.
i have encountered a new problem again.
This is a piece of raw data (Range B:C) that I need to pull out from the database. I created 2 columns, mainly CODE and REGION. Code is a combination of ENTITY&DEPOT&SUBREGION. Region is generally a VLOOKUP function used to lookup a value from CODE and return me a value from Worksheet ("REFERENCE"), column 5. The problem now is that, I couldnt derive my result for region although the CODE for Worksheet"Result' and "Reference" looks the same. Then, i realise that the problem is... the data generated from the database leave a FEW SPACES on the SubRegion in Worksheet 'Result". Now i need help in clearing the space for my Worksheet ("Result")'s Sub Region field. Bearing in mind that the data for Worksheet ("Results") keeps on changing, but the columns is the same. The Worksheet("Reference") only serves the purpose of reference, it doesnt change. Hopefully there is a procedure that could help to clear the spaces.
Thank you for taking time off to read this.
Hear from you guys soon.
Cheers.