Adding Spacific Date Range

**rmorganpier45** · 02-06-2014, 09:31 PM

I have a form with multiple tabs. The main tab has a list of daily activity
Example:

Sea Farmer 1/1/2014 500 lbs
Seafarmer 1/16/2014 600 lbs
Seafarmer 2/1/2014 300 lbs

One of the other tabs would be Sea Farmer. I have the formulas IF('Main'!B3="Sea Farmer",'Main'!C3,"") to select and copy the information from the main tab to match and copy to the matching tab but i only want a selected date range. For example i would need any cell with Sea Farmer copied to the tab Sea Farmer but only if it meets the specified date range 1/1/2014 to 1/31/2014

Can anyone help? Im not sure if I have explained this right so let me know if you need more information.

Thanks

**davesexcel** · 02-06-2014, 09:35 PM

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic