View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shoney Shoney is offline
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.