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: 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.
 
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
copy data from sheet2 to sheet1 when sheet2 has variable # of rows Anne Excel Discussion (Misc queries) 6 February 27th 09 09:48 PM
Automatic populate Sheet2 with data from Sheet1 based on criteria. Saurabh Khanna. Excel Discussion (Misc queries) 2 December 30th 08 01:19 PM
fetch the data from sheet2 & place it in sheet1 based on the locat Ren Excel Programming 5 January 12th 08 07:45 AM
Function on Sheet1 based on data on Sheet2 Sony Excel Worksheet Functions 0 February 7th 07 04:44 PM
copy data from sheet1 based on criteria in sheet2 to sheet3 Fred Excel Programming 3 May 25th 04 01:46 PM


All times are GMT +1. The time now is 06:41 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"