Just on my way out, but will respond to all three questions when I get back later this afternoon. ...
AliGW thats fantastic!!
i have a couple of questions
See if this PowerQuery solution suits your needs.
M Code:
let Source = Excel.CurrentWorkbook(){[Name="TBLREADINGS"]}[Content],
Hi Ali thank you so much for responding. I've attached a redacted copy of the actual spreadsheet with comments and a tab with a mock up. Really really...
rantanwang Today, 08:38 AM
can a pivot table show my data in the way i need it?
Well, of course it depends, but as your master workbook must contain TBLREADINGS, it should be as easy as creating a blank query and copying in my code....
AliGW Today, 01:38 PM