Thread: Tracking income and invoices for projects - multiple search results

Hi,
This is my first time on this forum and hoping someone can assist. I am creating an speadsheet to track property projects I am working on. I need to be able to search a particular folder reference number (fA12XXXXXX on the 2010 overview tab). I have attached a test version of the document.

I have setup the Misc tab to list all the different income and invoices from each month. I want to be able to enter a project # (eg. fA235292) on the Overview sheet and for it to display ALL of the income and invoices listed against that folder number.

I will also be adding tabs for each month for the next 7 years (as these project are quite lengthy). I know this will add heaps of tabs at the bottom, but not sure how else to overcome this.

Any suggestions or comments would be greatly appreciated.

Lee

Hi Roy,
Thank you for your reply. Is there anyway for the data from each months tab listed in the 'Misc' tab without any gaps? I need to be able to enter the date for each month separately for reporting purposes.

I was trying to use a similar formula as the answer to the below thread but had trouble.

http://www.excelforum.com/excel-gene...ml#post2449269

Sorry to post on this again but have not had an answer to solve this query..

Can what I am trying to do be done or am I way of base?

Thank you

Hi Roy, I have put the data into one table, listed on the 'MISC' tab. As new data is put into each month, it is added to this table. Does it matter is there are blank fields in this table?

Also, could anyone tell me where I went wrong using the answer to this thread? I cannot get rid of the gaps (Tried it on the MISC tab)

http://www.excelforum.com/excel-gene...ml#post2449269

Attached workbook....

Thank you for your help.

Roy, did that attachment work?

Can anyone else view the attached doc?

If so, can anyone else provide some help/assistance/advise?

I really need to finish this doc and cannot get past this.

I need my search function to show ALL results and it is only displaying the first one....

HELP.....HELP......HELP......HELP

I have been trying to get the data into a table with no gaps but do not seem to be having any luck. (Table on the right in the MISC tab).

Unfortunately I dont have much experience making a pivot table. Is there an easy way I can get the data into a table with no blank lines or columns?

What have I dont wrong in the 'P' column on the MISC tab.... I am trying to get this to number the results matching the search criteria. While it is doing that, I want it to remove all the '0' fields and bring the data to the top of the table. Hense creating the list with no blank fields.

Thanks Dave, this does exactly what I need it to do.

If I was to add new sheets (like July 2011, August 2011, etc) how can I ensure this search function picks them up? Is it easy to add more fields to the search database?

Sorry, should have tried it.

Thanks Dave, that is great!