LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need VB formula to retrieve data dave Excel Worksheet Functions 1 December 29th 11 06:19 PM
Retrieve whole row of data manxman Excel Worksheet Functions 9 May 5th 09 03:19 AM
retrieve peer data Elaine Excel Worksheet Functions 3 May 6th 07 12:53 AM
Retrieve multiple data rows data from a very long list and copy t mathew Excel Discussion (Misc queries) 1 September 13th 06 08:24 PM
Retrieve data Matt W via OfficeKB.com Excel Discussion (Misc queries) 1 July 14th 05 06:40 PM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"