Thread: retrieve data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lolly[_2_] Lolly[_2_] is offline
external usenet poster
 
Posts: 28
Default 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