Auto fill cells based on a date range given

**timmy1254** · 12-08-2011, 04:15 PM

Hi,

I have a sheet that I copy and paste up to 400 rows of monthly production data into from another source. I then have a number of different zones that the production originated from and I assign a period of time to each zone. I would like the production data to auto fill under each specific zone if it falls in the date range specified. I have included the sheet I am working with. It is completely set up and I filled this one in manually. I will enter all of the data highlighted in yellow and I would like all of the data highlighted in blue to auto fill. I cant seem to find the right code or shortcut for this. Any help would be greatly appreciated!

Thanks
Jon

**timmy1254** · 12-08-2011, 04:17 PM

I forgot to mention there is a simple calculation converting Barrels to thousand Barrels and thousand cubic feet to billion cubic feet within the data I am trying to have auto populate. I know this shouldn't be much of a problem but just wanted to make sure anyone recognized it.

Thanks