VLookup in VBA, and All Borders

[tommagpieconsultants]

Hi, I am new to VBA and have a couple of urgent issues.

I have a number of worksheets in a spreadsheet. Data from a report is loaded to worksheet 'data'. The number of rows can vary. The code below is what I have created (with a bit of help) to get the data into T2, and to put the information in the right place. It also calculates the total in column M.

The major problem I have is that, starting with row 3, I want to look up the item number found in column 'E' and search worksheet 'Support'. The item number can be found somewhere in column 'A' in 'Support'. I need to bring the value in column 'B' in Support (that relates to that item number) and store it in column 'A' in worksheet 'T2'. I then want to repeat this process for every row in 'T2' up to and including the last row.

I also need to be able to put 'all borders' around range A3:AI & 'lastrow'.

I put this code together in the VBA for sheet 7, but I think this may be in the wrong place ('T2' is sheet8 and 'Support' is sheet10).

Below is the code to date (it includes a lot of 'commented out' efforts. Any help would be truly appreciated.

Regards

--------------------------

Please Login or Register  to view this content.

[stnkynts]

Hello and welcome to the forum. Could you upload an example workbook which clearly demonstrates what you are trying to accomplish.