LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 7th 07, 04:44 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
Posts: 11
Default Function on Sheet1 based on data on Sheet2

Hi, I am trying to forecast approved vacation for employees on sheet1 based
on information from sheet2. What I have is a summary page sheet1 with a list
of employees names in column A, a cell that populates Todays date. On sheet2
I have the following:

Columns B to AF the days of the week and the appropriate date for that
month. In the row above each would have the prospective month in this format
Jan-07 until all months are listed. For each month there are 11 rows with
employees names.

what I want to do is use date for Monday of each week and project who will
be on vacation for the next 2 weeks and summarize it on sheet1. Is this
possible? I had posted this same question in the programming section but did
not get any answers so I would really appreciate any help on this.



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 some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 07:05 PM
Creating function to insert data based on criteria Tami Excel Worksheet Functions 1 August 18th 06 10:42 PM
How To Retrieve Data from Sheet2 into Sheet1 compconnj Excel Worksheet Functions 3 March 21st 06 07:56 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM

All times are GMT +1. The time now is 11:02 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017