Last seen: May 28, 2025
emails are not the way. It does not allow for all in the forum to understand the issue. Attach a file to this forum. Click on the link below to att...
Trying to understand what you want the end result for the data in the two tables to look like. Can you please supply a mocked up version for the data...
Provide us with a file of sample data 15 records or so and then mock up what you want the result to look like for the records provided. It will make ...
Why not just filter them out?
Would be very helpful if you uploaded a sample data file (no pictures please) showing your existing data and a mocked up results of what you expect.
This sounds to me that you would be better served with a Relational Data Base Management System. You could do this in MS Access and generate queries ...
No file has been attached. Think you might have missed the upload step after attaching.
If I am understanding correctly, then attach this line of code to a command button ActiveWorkbook.RefreshAll
You could save the Excel file as a PDF and then email or share on a network.
Cannot determine what your issue is. Two tables seem to have relationships and you have created a PT. What are we missing in your explanation?
How about supplying us with a sample file that we can analyze. You have not provided enough data.
I would pivot the data in Power Query let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Pivoted Column" = Table.Pivot(Table.Tr...
Look at this link for a solution to split multiple columns at once. Power Query--Split Multiple Columns at one time | MrExcel Message Board
Here is a good link to learn about PQ
As I stated in the file Alan, merely changing the number format does not help. Interesting because when I did the reformatting it came up as zero...