Find, Copy and Paste

[Fabian]

Hi,

I am looking for a piece a code doing the following:
I have 4 variables Sales, Discount, Display, and Dist.
Every variable is in 40 columns, each column is a month=160 columns
Before those 160 columns I have 1 column (I) with the period I am interested
to find info. I have 100 rows, every single row could have a different period
I am interested in.
What I am trying to do is for example for my first row (row #3) find on
those 40 columns for each of those 4 variables (160 columns), the period is
in column I. (the periods in the columns are in row # 2). Then copy and paste
the number on those columns in column E (Sales), then the same for Discount
(column F), Display (column G), Dist (column H). Then I want to repeat the
same for 100 rows (the quantity of rows change always, could be 100 or 120 or
??)

 

[Mihi Caru Futuri]

Hi,

I am looking for a piece a code doing the following:
I have 4 variables Sales, Discount, Display, and Dist.
Every variable is in 40 columns, each column is a month=160 columns
Before those 160 columns I have 1 column (I) with the period I am interested
to find info. I have 100 rows, every single row could have a different period
I am interested in.
What I am trying to do is for example for my first row (row #3) find on
those 40 columns for each of those 4 variables (160 columns), the period is
in column I. (the periods in the columns are in row # 2). Then copy and paste
the number on those columns in column E (Sales), then the same for Discount
(column F), Display (column G), Dist (column H). Then I want to repeat the
same for 100 rows (the quantity of rows change always, could be 100 or 120 or
??)

 

[Fabian]

Hi Mihi,

I could not see your post.

Thanks