K
kurtwagner
Hello,
I have a problem: I have a monthly sheet (Month.xls) with the number o
the clients in one column, and their info on the following ones. In th
Tab "Exp" I have this:
[image: http://img.photobucket.com/albums/v319/rideronthestorm/Mes.jpg]
I also have another file (Year.xls), in which I must paste the data o
the columns in yellow of the monthly sheet,(paste special: values
transposed). In the Tab "Year" I have this:
[image: http://img.photobucket.com/albums/v319/rideronthestorm/Ano.jpg]
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
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 i
column B of Year.xls, find it in column A of Month.xls, copy the row
from columns C to G and paste them, transposed, in the correct month o
the Year.xls.
How do I do that
I have a problem: I have a monthly sheet (Month.xls) with the number o
the clients in one column, and their info on the following ones. In th
Tab "Exp" I have this:
[image: http://img.photobucket.com/albums/v319/rideronthestorm/Mes.jpg]
I also have another file (Year.xls), in which I must paste the data o
the columns in yellow of the monthly sheet,(paste special: values
transposed). In the Tab "Year" I have this:
[image: http://img.photobucket.com/albums/v319/rideronthestorm/Ano.jpg]
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
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 i
column B of Year.xls, find it in column A of Month.xls, copy the row
from columns C to G and paste them, transposed, in the correct month o
the Year.xls.
How do I do that