retrieve data
My query
sheet1 data looks like this
A B c D E F
Head 1 2 3 4 5---------
1_5 23 34 5 6 7-------------
In Col B,C,D-- we have values for each week data and goes thru the whole
year till IV.
In sheet2
A b c d e f---
1-5 Value
I want in sheet2 the data to be displayed for two months. It counts the
across the whole column
find the last empty colmmn and get the data for last two months which is
there. It is variable becoz everymonth data
comes in.
Write now I am using vlookup to do that but it is a very tedious process.As
the months increases.
Any help would be greatly appreciated.
thanx in advance.
--
Kittie
|