Hi Rajan, Here is a suggestion in the attached file. BR, Lionel
Good job Kenneth ! Sorry for the French vesrion of formulas. BR, Lionel
Hi Kenneth, Here is a solution without VBA and only with formulas ; Drop down list et Named area. BR, Lionel
Hi Alan, Here is a VBA solution. 1. In ThisWorkbook, you paste the following two codes. The first code allows you to initialize the shortcut ...
Hi Nathaniel Sawyerr, I have an error trying to download your file. Could you reload it? BR, Lionel
Hi, This solution ? BR, Lionel
Hi, Anything is possible with Excel. But we have too little information to give an answer. Can you order just one of these items? Can you order...
Hi Dave, Sorry for the misunderstanding, I didn't catch the exact request. Mynda gives you a very good solution. And I have another one. BR, ...
Hi Dave, This is the formatting solution for row and column headers. BR, Lionel
Hi Dave, Here's a suggestion. BR, Lionel
Hi, Here is a solution in your file. BR, Lionel
Hello Trevor You can use CTRL+End to see which cell is the last active cell in each tab. If you delete unnecessary rows and/or columns, don't forge...
Hi Mynda, This is my problem. I am part of a company that has a strategy of... blocking updates. So I find myself with an Excel that is getting old...
Indeed, these functions are not available.
Hi Velouria, My version : Microsoft Excel 2016 MSO (16.0.8201.2193) 32 bits. + Subscription: Microsoft Office 365 ProPlus