ravikr2678
11-02-2007, 12:21 PM
Hi All,
Need some help.
I have an excel sheet which is updated every week with new column values.
The sheet contains 3 names which keep repeating for every week's data.
some like this.
..............abc..........abc1..........abc2..........xyz..........xyz1... .......xyz2
............6/20/07......6/27/07......7/4/07.......6/20/07.....6/27/07......7/4/07
east..........0.2............0.4...........0.2............0.3............0. 5...........0.3
west..........0.1............0.3...........0.4............0.2............0. 5...........0.9
north..........0.2............0.4...........0.2............0.3............0 .5...........0.3
south..........0.2............0.4...........0.2............0.3............0 .5...........0.3
Here abc and xyz are two products and the data is added every week.
You can see the dates are repeated for products.
that means for product 'abc' and 'xyz' on date 7/4/07 two column are added at respective places, however those
columns are not side by side.
So now I need the data with respect to product and zone, for a the last two weeks. 'i.e' for 'east' zone, for
'abc' product on week 7/4/07, the data is 0.2
and for 'xyz' on east zone it's 0.3,
I need this data 0.2 and 0.3 in sheet2. so that i can make a chart using it.
It's a Urgent requirment. and i have no much idea on VBA coding.
Any Help is greatly appreciated.
Thanks in advance.
Need some help.
I have an excel sheet which is updated every week with new column values.
The sheet contains 3 names which keep repeating for every week's data.
some like this.
..............abc..........abc1..........abc2..........xyz..........xyz1... .......xyz2
............6/20/07......6/27/07......7/4/07.......6/20/07.....6/27/07......7/4/07
east..........0.2............0.4...........0.2............0.3............0. 5...........0.3
west..........0.1............0.3...........0.4............0.2............0. 5...........0.9
north..........0.2............0.4...........0.2............0.3............0 .5...........0.3
south..........0.2............0.4...........0.2............0.3............0 .5...........0.3
Here abc and xyz are two products and the data is added every week.
You can see the dates are repeated for products.
that means for product 'abc' and 'xyz' on date 7/4/07 two column are added at respective places, however those
columns are not side by side.
So now I need the data with respect to product and zone, for a the last two weeks. 'i.e' for 'east' zone, for
'abc' product on week 7/4/07, the data is 0.2
and for 'xyz' on east zone it's 0.3,
I need this data 0.2 and 0.3 in sheet2. so that i can make a chart using it.
It's a Urgent requirment. and i have no much idea on VBA coding.
Any Help is greatly appreciated.
Thanks in advance.