Hello,

I have a problem: I have a monthly sheet (Month.xls) with the number of the clients in one column, and their info on the following ones. In the Tab "Exp" I have this:


I also have another file (Year.xls), in which I must paste the data of the columns in yellow of the monthly sheet,(paste special: values, transposed). In the Tab "Year" I have this:


To determine the offset for the month in which I want it to be pasted, in the monthly sheet I have a cell in the Tab "Start", cell A3, where I put the number of the month. For September, for example, is 9.

I want a macro for Month.xls that will look for the clients number in column B of Year.xls, find it in column A of Month.xls, copy the rows from columns C to G and paste them, transposed, in the correct month of the Year.xls.

How do I do that?