faboboren
11-25-2008, 01:52 PM
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 columnsBefore 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 ??)I have attached file just you can see that..