Search : in
By :

Fetch multiple data from excel

Last answer on Sep 30, 2009 1:34:57 am BST ritz, on Sep 29, 2009 4:39:27 am BST 
 Report this message to moderators

Hi geeks,

I require your help in following query. I have a table table called project

It contains following items
E1 F1 G1 H1
Activity Name No of Days Start Date End Date
Requirement gathering 10 28-Jan-09 10-Feb-09
BRS IT 1 11-Feb-09 11-Feb-09

Based on the table, please help me with a macro which does following....
1) checks system date-- if system date is 9-Feb-09, then macro understands that it has to look at Requirement gathering activity.
2) once done it should count no of days starting from start date to system date excluding saturdays & sundays.

thanks frnds
ritz

Configuration: Windows XP
Firefox 3.0.11

Best answers for « fetch multiple data from excel » in :
How to split data into multiple worksheets? ShowHow to split data into multiple worksheets? Issue Solution Note Issue I hope someone can help! I have a .csv file open with excel that contains a large amount of data that has been merged together so that each data set follows each...
How to compare 2 excel sheet and combine uniq data? ShowHow to compare 2 excel sheet and combine uniq data? Issue Solution Note Issue I have 2 excel sheets , A and B. There are redundant data in both sheets as well as uniq. All i want is to combine both with no redundant records. (A+B...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Data transmission - Multiplexing ShowIntroduction to multiplexing Multiplexing refers to the ability to transmit data coming from several pairs of equipment (transmitters and receivers) called low-speed channels on a single physical medium (called the high-speed channel). A...
Ask your question Reply

1

venkat1926, on Sep 29, 2009 10:57:21 am BST

Quote
if system date is 9-Feb-09, then macro understands that it has to look at Requirement gathering activity.
unquote
what is the logic. Is it because end date is nearest to system date (that is today) wheras the BRS IT end date is not nearest date.

   
Reply to venkat1926

2

ritz, on Sep 29, 2009 3:26:50 pm BST

Venkat, it sud check start date >= system date >= end date. Once macro identifies that it is in between a particluar start and end date. A for loop sud start
for i= start date to system date
check if date is sunday or saturday , if no then counter ++
next start date..

here i just want to know take the count of days between start date aND systen date.

thanks
Ritz

   
Reply to ritz

3

 venkat1926, on Sep 30, 2009 1:34:57 am BST

Post a very small extract of your data.

   
Reply to venkat1926
Ask your question Reply
They need your help