I have a spreadsheet with two workbooks. One with data and one with an output form.
The data contains various information such as customer, check number, amounts and date check was received. Once a month I would like to collect the data based on the date (month) and display it on my report and print it off separate. I have a Validation cell setup to choose which month I want the data for but have been unable to find an article detailing how to setup a formula to pull the range of cells based on date into my report sheet.
So....
* Database contains information including multiple entries per month or even multiple entries per day. Potentially 14 columns of data.
* Report form needs to display 6 columns of data based on date. Need to be able to display all rows containing information for each month selected in data validation box.
I try to research before posting and I believe I am missing something blatantly simple.
The data contains various information such as customer, check number, amounts and date check was received. Once a month I would like to collect the data based on the date (month) and display it on my report and print it off separate. I have a Validation cell setup to choose which month I want the data for but have been unable to find an article detailing how to setup a formula to pull the range of cells based on date into my report sheet.
So....
* Database contains information including multiple entries per month or even multiple entries per day. Potentially 14 columns of data.
* Report form needs to display 6 columns of data based on date. Need to be able to display all rows containing information for each month selected in data validation box.
I try to research before posting and I believe I am missing something blatantly simple.