Need Assistance with Pivot Tables

I am trying to create a directory of businesses for a category of social services for a local NPO that I am volunteering at, and I would also like to include a Spanish section due to Spanish-speaking...

excel

Yea_So
Jun 20, 2021
Hi Jankysoft ,

How are you going to shoehorn into a solution that involves an additional file, when you can do a query on the same table that is already in your workbook?

You can do a query by Table/Range, image below I have a table/range with 53,000+ rows:
I remove the columns I do not want in the report or pivot table, I can rearrange the columns, I can filter out any rows I do not want to be in the report, and if there is additional information, all I have to do is paste it at the bottom of the table and the excel table will just dynamically (automatically) add it into the table and automatically propagate into the report (via the refresh) button and bam! it's included the next time I have to print the report. Does that not sound like convenience to you?

cheers

StoneKiwi

Iron Contributor

Jun 16, 2021

Do you want to send through an example of what you have now and what you want?

Jankysoft
Copper Contributor
Jun 18, 2021
StoneKiwi Yes, thanks!

So I basically want to take this:

And have it automatically input into printable version like this: (with asterisks representing a conditional yes and nos)

As well as conditional for Spanish-speaking staff to output a table like this: (with asterisks representing a conditional yes and nos)
I want to do it in Excel, but the problem with using conditional formulas is that the Excel workbook becomes too clunky to use, especially at the NPO where they use all virtual machines.

So I wanted to see if I could use Excel through Pivot Tables or something else, and what would be the best way to go about that.

Thanks again because the tutorials online have created more problems than they have solved!

Forum Discussion

Need Assistance with Pivot Tables

Resources