I may have asked this before but I can't easily find it in "My Answered Questions". And in this version I am asking for a slightly different "solution".
I have a bunch of excel files in one folder. Each one has 1 workpage. They all have the same column headers.
I want to combine those files into one workbook. They can each be a different page of the workbook or, even better, they can be combined into one workpage -- since they all have the exact same structure and headers.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…