I have a sheet containing invoices for all projects (one invoice per row). I'd like to have a separate sheet which returns all the invoices listed against a single project code (with each invoice still on its own line - basically a filter with the criteria set by a cell reference). Is there a lookup which can do this? A…
We list all our projects in a master sheet, and then all invoicing information in another and all cost information in a third. I'd like to create a front page where you select the project name, and then it pulls information from all three sheets into a more useful and more userfriendly format. Currently, you have to scan…
