View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Lauer John Lauer is offline
external usenet poster
 
Posts: 2
Default How to copy row data from Sheet2 to Sheet1 based on Conditional Date

Developing using Excel 2007, but need to be compatible with 2003.

Problem:

Workbook has two sheets. Sheet two contains data, columns A thru M.
Column C is formatted for Date values. Not all rows contain a value in
column C. Data begins in row 2.

Sheet One has 3 'Option Buttons (form Control), labeled Contract date,
Effective Date, and End Date. When contract date is selected, Need
data on sheet two, column C (Date is contained here) to be queried
with a conditional filter... If date < today's date + 14 days ... If
true, copy column C thru M of that row to Sheet One beginning at cell
C13. Continue until all data rows have been tested.

If another 'Option Button' is selected, results from first query are
replaced by results from second query.