LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Enter date on one worksheet, pull data from another

I'm trying to set up a fomula or macro that will allow me to enter a date on
one sheet, then find the date on another sheet within the same workbook.
Then, copy certain cells within that column and paste them to certain cells
within the sheet which I entered the date to begin with.

What I have is a sheet with a large amount of data (the sheet I want to pull
data from) and another sheet that would showcase only a portion of the data.

The goal is to be able to enter a date in the one sheet and automatically
pull data from the other sheet and paste it where appropriate.
 
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
Enter date, then pull data from another sheet Shoney Excel Discussion (Misc queries) 2 November 9th 07 03:40 AM
Using one worksheet to pull data from many Sara P. Excel Discussion (Misc queries) 1 July 13th 07 10:42 PM
Auto enter date when data in enter in another cell Brian Excel Worksheet Functions 5 December 7th 06 06:44 PM
how do I enter more data to an already made pull down menu Queenyvix Excel Discussion (Misc queries) 1 February 16th 06 08:10 PM
How do I pull a date from a separate worksheet using the IF functi Jerrod Mason Excel Worksheet Functions 8 July 30th 05 06:35 AM


All times are GMT +1. The time now is 09:55 AM.

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

About Us

"It's about Microsoft Excel"