LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Need conditional data from 1 sheet to populate another sheet

Within the same xls file.

I want my new sheet to check a set column in sheet 1 (column W) in this
column I have dates. I want my new sheet (4) to check that column and find
any dates within 30 days of opening the file of this new sheet (for every
time its opened). Then I would like that row that meets this condition to be
pulled over to my new sheet. Ideally Id like to be picky about the
information from that row and not pull the entire row. Am I looking at
something too hard to pull off?

Thanks for any tips
 
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
Populate order sheet with data from work sheet Veronica Johnson Excel Worksheet Functions 4 January 22nd 08 03:29 AM
HOW DO I AUTOMATICALLY POPULATE AN INVOICE ON SHEET 2 FROM SHEET 1 Sonny Excel Discussion (Misc queries) 1 August 26th 06 04:00 PM
How to populate prices in sheet two based on cost in sheet one dstooch Excel Worksheet Functions 0 April 3rd 06 10:56 PM
How to populate one sheet with data from another sheet KH New Users to Excel 1 February 25th 05 06:21 AM
populate cells with data from another sheet Pepe_abu Excel Worksheet Functions 0 January 15th 05 08:51 AM


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