Forum Discussion
Need Assistance with Pivot Tables
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
Hi Jankysoft
You might be looking at power query for a solution, you can remove and add columns, and once you have the power query set up once, it can repeat the process just by pressing the refresh button, depending on whether you'll be doing a query by text/csv, or by folder where you just drop the file in a folder or replace the source file in the folder to update your query to generate the final list.
cheers
I saw that as a solution but that looks like the most overkill as it looks like I would be shoehorning in a solution by incorporating at least an addition file to compensate for Excel's lack of features.
Thank you for your assistance, but I think that this all just confirmed to me that Excel is heavily limited to...not sure what but I am trying to be diplomatic as my username already says what I think about the company.
Again, thank you anyways!
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
- Thank you for your reply once again!
Tried pivot tables and it didn't give me a problem this time for some reason!
Thanks again!
