Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need VB formula to retrieve data | Excel Worksheet Functions | |||
Retrieve whole row of data | Excel Worksheet Functions | |||
retrieve peer data | Excel Worksheet Functions | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
Retrieve data | Excel Discussion (Misc queries) |