Hi,

I have a worksheet which contains 3 tables, each of the same dimension (i.e. headings). Below is a slab of code which inserts a column and performs a trim and concatonate function of the three adjacent cells (being column C, D and E). Once done, it performs a vlookup function with another worksheet where the vlookup function applies to a number of columns.

My problem is that I'm trying to tidy up this code and make it more universal so that I don't have to constantly edit the code everytime the dimensions of the tables adjust slightly.

Futher, the trim concatenate function is tied together with the search function where it searches for the word currency and offsets to the next column. Is there a more clever way of writing this as the number of tables can change and I don't want to haev to copy and paste the same bit of code depending on the amount of tables for any particular week?

Thank you very much.

Please Login or Register  to view this content.