Last seen: Mar 5, 2025
Thank you Mynda!
Could you use that code in a For Each loop? dim ws as Worksheet for each ws in thisworkbook ws.PrintOut ws.Range("A1").Value=ws.Range("A1"...
Phil gives a good way to do this in this video. If you need further assistance please upload an example file complete with an example of your desired ...
PQ was promoting the headers in each file and then combining the files, which was creating your issue with multiple headers. By deleting the promote h...
Try this on for size, and see how it works for you. 🙂
Hi Jim, I'm happy to help! Let me answer your questions as best I can. 1. It gives them "_[number]" the same reason an excel table does, it can't h...
Hi Tom, There is no file attached. After attaching your file click on 'Start Upload' and wait for the grey checkmark before posting.
Hi Jim, You can't see the third child because your names are different. In your source file, the column name is "First Name_216" and "Last Name_217...
Looking at this with fresh eyes, it looks like it might be a table structure thing. Are tables structured the same in all your sheets? Is there some d...
My first thought, and obvious so I'm sure you already went there but, did you check your source data? Did you future proof your query, could be someth...
No workbook attached, be sure to hit 'Start Upload' and wait for the grey check mark after attaching workbook. I did work on it but had issues and ...
Hi Tyrone! Use your raw data, age group in rows sex in columns and then you can group your ages by right-clicking > Group > adjust your start...
That was a fun challenge! Thank you for the opportunity to learn how a new function works! I was able to figure out a formula using sumproduct(freq...
I would agree with the unpivoting solution Alan provided. I understand your boss's leeriness at remembering to click refresh as I make worksheets for ...