How to automatically collate different text into set tables from different tabs

[summer2010]

Hi

How can I automatically collate set text from different tabs into a set table? Using set criteria Name C4:C24 ( and month (E1) in say April’s tab to import into a set table in the inv tab.

In tabs April through to March various text is collected.

In the Inv tab I would like to invoice people for various activities throughout one month.

In Inv tab:

B1: Name taken from April to March tabs C4:C24

E1: Month Invoice is created from ( this will change manually to any month of the year)
A B C D
1 Date Receipt No Activity Amount

In A6: =SUMPRODUCT(--(April!$C$4:$C$27=Inv!B1),--(April!E1=Inv!E1),--(April!B4:B27=Inv!B6))

I know I can’t use sumproduct as it’s text I want brought in separate rows, Not counting all in AprilC4:C27 into one cell.

But I would like all the information for say goldfinch’s purchases in April to be listed separately in the table and then totalled up at the end showing the expenditure and what the expenditure was on.

Is this doable? The easier option would be to use the filter list for the relevant month you want to invoice for, then to copy and paste. But ideally I’d like to only input the name and month.

Your help is most valuable I attach an example

I will be unable to respond until Monday

Thanks in advance for your help, if this is possible

[summer2010]

Is anyone able to offer assistance?

[oeldere]

I would solve this differant.

I made a sheet with all data in it (with a macro).

After that you can filter or use Pivot Table to analyze the data.

See the attached file.

[Glenn Kennedy]

I used INDIRECT to do this. You DO need to make sure that there are NO stray spaces - there was a space after May in the Tab title ("May "), which caused things to fail. Any Q's please get back to me.

[summer2010]

All of these suggestions are way beyond my skill level and I appreciate all your input.

I’ll have a play with both of these. Having a quick look it looks like Glenn Kennedy's suggestion will work best for my needs.

Thank you so much for your feedback, this site is so valuable to myself.

[Glenn Kennedy]

Glad to have helped! It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.