Hi

I need a macro that will create 4 headings in the following columns

T2 = column and cell

T2: Istenant U2: IsorderNone V2: IsorderRef W2:IsOrderforOther

I then need the macro to copy data from the same spreadsheet and place the corresponding data into the above columns. I need to specify the columns where the data lives in which I need to copy from, not the range. E.g. T2:T500 – it needs to be based on the column..e.g. T:T

Important: I need the macro to stop inputting data at the last line of data from where its copying from.

Please advise, much appreciated

Thanks