transposition

Hello, I'm very much new to the world of VBA but I have a transposing problem I need help on! I'm working with a large excel file - columns A through to I give details on a company, these are all consistent throughout the 9,000 or so rows. Columns J onwards (up to a maximum of column EF)...

Hi all I am new to the MrExcel community and am working on a fuzzy matching assignment. I managed to copy the Levenshtein Distance VBA code from https://stackoverflow.com/questions/4243036/levenshtein-distance-in-vba and it gave me the result I wanted. For instance if I compared "Osama Ben...

Good night on you! Sitting with tight deadline and trying to help colleague who got stuck. It is about compiling economic information about 500 companies and contacts. However, in order for the contacts to be able to imported to a database later, they must be set up differently than the...

Hi all, I was wondering if it is possible to transpose data in rows, where each entry is separated by the same line of text. The problem for me is that each data entry contains different amount of rows for each company so cannot simply separate at every e.g. 6th row... Therefore, I need a macro...