{"id":133,"date":"2024-03-16T21:09:42","date_gmt":"2024-03-16T21:09:42","guid":{"rendered":"https:\/\/rayerden.com\/index.php\/my-projects\/"},"modified":"2024-08-15T16:34:16","modified_gmt":"2024-08-15T16:34:16","slug":"my-projects","status":"publish","type":"page","link":"https:\/\/www.rayerden.com\/index.php\/my-projects\/","title":{"rendered":"MY PROJECTS"},"content":{"rendered":"\n    \n    <section class=\"u-clearfix u-section-2\" id=\"sec-bb34\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <div data-interval=\"5000\" data-u-ride=\"carousel\" class=\"u-carousel u-slider u-slider-1\" id=\"carousel-0b39\">\n          <ol class=\"u-absolute-hcenter u-carousel-indicators u-carousel-indicators-1\">\n            <li data-u-target=\"#carousel-0b39\" class=\"u-active u-grey-30\" data-u-slide-to=\"0\"><\/li>\n            <li data-u-target=\"#carousel-0b39\" class=\"u-grey-30\" data-u-slide-to=\"1\"><\/li>\n            <li data-u-target=\"#carousel-0b39\" class=\"u-grey-30\" data-u-slide-to=\"2\"><\/li>\n            <li data-u-target=\"#carousel-0b39\" class=\"u-grey-30\" data-u-slide-to=\"3\"><\/li>\n            <li data-u-target=\"#carousel-0b39\" class=\"u-grey-30\" data-u-slide-to=\"4\"><\/li>\n            <li data-u-target=\"#carousel-0b39\" class=\"u-grey-30\" data-u-slide-to=\"5\"><\/li>\n            <li data-u-target=\"#carousel-0b39\" class=\"u-grey-30\" data-u-slide-to=\"6\"><\/li>\n          <\/ol>\n          <div class=\"u-carousel-inner\" role=\"listbox\">\n            <div class=\"u-active u-carousel-item u-container-style u-image u-slide u-image-1\" data-image-width=\"1600\" data-image-height=\"1001\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/Data-Mining-Techniques-15.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-1\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-2\" data-image-width=\"1200\" data-image-height=\"675\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/sql-nedir.png&quot;);\">\n              <div class=\"u-container-layout u-container-layout-2\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-3\" data-image-width=\"1920\" data-image-height=\"1080\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/Data-Science-Exercises.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-3\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-4\" data-image-width=\"900\" data-image-height=\"500\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/Microsoft-Access-Microsoft-Office-dev-Database-Veritaban-Proje-Tasarm-Yaptrma.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-4\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-5\" data-image-width=\"1000\" data-image-height=\"616\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/shutterstock_488322949-19.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-5\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-image u-slide u-image-6\" data-image-width=\"512\" data-image-height=\"288\" style=\"background-image: url(&quot;https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/unnamed3.jpg&quot;);\">\n              <div class=\"u-container-layout u-container-layout-6\"><\/div>\n            <\/div>\n            <div class=\"u-carousel-item u-container-style u-slide\">\n              <div class=\"u-container-layout u-container-layout-7\">\n                <img decoding=\"async\" class=\"u-image u-image-default u-image-7\" src=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/08\/ChatGPT_1.jpeg\" alt=\"\" data-image-width=\"392\" data-image-height=\"220\">\n              <\/div>\n            <\/div>\n          <\/div>\n          <a class=\"u-absolute-vcenter u-carousel-control u-carousel-control-prev u-spacing-5 u-text-grey-30 u-carousel-control-1\" href=\"#carousel-0b39\" role=\"button\" data-u-slide=\"prev\">\n            <span aria-hidden=\"true\">\n              <svg viewBox=\"0 0 477.175 477.175\"><path d=\"M145.188,238.575l215.5-215.5c5.3-5.3,5.3-13.8,0-19.1s-13.8-5.3-19.1,0l-225.1,225.1c-5.3,5.3-5.3,13.8,0,19.1l225.1,225\n                    c2.6,2.6,6.1,4,9.5,4s6.9-1.3,9.5-4c5.3-5.3,5.3-13.8,0-19.1L145.188,238.575z\"><\/path><\/svg>\n            <\/span>\n            <span class=\"sr-only\">Previous<\/span>\n          <\/a>\n          <a class=\"u-absolute-vcenter u-carousel-control u-carousel-control-next u-spacing-5 u-text-grey-30 u-carousel-control-2\" href=\"#carousel-0b39\" role=\"button\" data-u-slide=\"next\">\n            <span aria-hidden=\"true\">\n              <svg viewBox=\"0 0 477.175 477.175\"><path d=\"M360.731,229.075l-225.1-225.1c-5.3-5.3-13.8-5.3-19.1,0s-5.3,13.8,0,19.1l215.5,215.5l-215.5,215.5\n                    c-5.3,5.3-5.3,13.8,0,19.1c2.6,2.6,6.1,4,9.5,4c3.4,0,6.9-1.3,9.5-4l225.1-225.1C365.931,242.875,365.931,234.275,360.731,229.075z\"><\/path><\/svg>\n            <\/span>\n            <span class=\"sr-only\">Next<\/span>\n          <\/a>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-clearfix u-section-3\" id=\"sec-84f5\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <h1 class=\"u-align-center u-text u-text-1\"><b>What do you find under my projects section?<\/b>\n          <span style=\"font-size: 1.25rem;\">\n            <br>\n            <span style=\"font-weight: 700;\">I add to this section from time to time various Excel files to illustrate the type of work that I do using Excel as part of&nbsp;an integrated Microsoft&nbsp;development&nbsp;platform for custom spreadsheet and&nbsp;tool design and&nbsp;process automation.&nbsp;&nbsp;<span style=\"font-weight: 400;\"><b>The content here will be&nbsp;growing over time with relevant&nbsp;examples for VBA macros, Excel functions and&nbsp;similar items illustrating processes that needs to be tackled with during a typical Excel based reporting project.<\/b>&nbsp;<b>Give it a try by clicking on the Sample Excel macros and Misc Files links located on the left navigation bar or click on below images.<\/b>\n              <\/span>\n            <\/span>\n          <\/span>\n        <\/h1>\n      <\/div>\n    <\/section>\n    <section class=\"u-clearfix u-section-4\" id=\"sec-8a4d\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <div class=\"u-expanded-width u-list u-list-1\">\n          <div class=\"u-repeater u-repeater-1\">\n            <div class=\"u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-top u-container-layout-1\">\n                <img decoding=\"async\" alt=\"\" class=\"u-expanded-width-lg u-expanded-width-md u-expanded-width-sm u-expanded-width-xs u-image u-image-default u-image-1\" data-image-width=\"680\" data-image-height=\"376\" src=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/automated-any-excel-by-using-vba-macros-with-low-price.jpg\">\n                <p class=\"u-text u-text-1\">This page provides sample Excel macros, this is a growing list.&nbsp; I place macros that in my opinion makes the life of the person who has to work with Excel and need to find some code solutions to make more useful and powerful spreadsheet applications.<\/p>\n                <a href=\"https:\/\/www.rayerden.com\/index.php\/my-projects\/#sec-9beb\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-hover-none u-text-white u-btn-1\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-top u-container-layout-2\">\n                <img decoding=\"async\" alt=\"\" class=\"u-expanded-width-lg u-expanded-width-md u-expanded-width-sm u-expanded-width-xs u-image u-image-default u-image-2\" data-image-width=\"1920\" data-image-height=\"1080\" src=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/personalization-network-segmentation-targeting-customer-ss-1920.jpg\">\n                <p class=\"u-text u-text-2\">On this page I simply added some personal stuff where I used Excel to support my hobbies or interests while having a little fun with Excel.<br>\n                  <br>\n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/index.php\/my-projects\/#carousel_6dd1\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-hover-none u-text-white u-btn-2\">learn more<\/a>\n              <\/div>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-clearfix u-section-5\" id=\"sec-9beb\">\n      <div class=\"u-clearfix u-sheet u-valign-middle u-sheet-1\">\n        <h4 class=\"u-align-center u-text u-text-default u-text-1\">\n          <span style=\"font-weight: 700; font-size: 2.25rem;\">EXCEL VBA\/MACRO SAMPLE FILES<\/span>\n          <br>\n          <br>On this page one can find some useful Excel macros to automate spreadsheet&nbsp;tasks, file operations,&nbsp;calculation logic and data flow control etc. Files that are displayed here are downloadable, I&nbsp;pick these files&nbsp;from my work projects, tasks and&nbsp;assignments&nbsp;where&nbsp;I had to use them&nbsp;when I was grappling with challenging&nbsp;data problems.&nbsp;&nbsp;I bring either directly from my work files as a scaled down version for privacy concerns to illustrate the function or formula or use a re-created version of the topic&nbsp;to explain the concept on a sample working file.&nbsp;If the sample file is created originally by another site, person or company on title section this situation&nbsp;is clearly indicated and referenced to. \n        <\/h4>\n      <\/div>\n    <\/section>\n    <section class=\"u-clearfix u-section-6\" id=\"sec-ec33\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <div class=\"u-expanded-width u-list u-list-1\">\n          <div class=\"u-repeater u-repeater-1\">\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-1\">\n                <p class=\"u-text u-text-1\">XLOOKUP Function<br>Samples provided on each tab showing different ways of using the new XLOOKUP function. This function became available during the summer of 2019 and provides a whole lot more versatility than the VLOOKUP. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/XLOOKUP-Explained.xlsx\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-1\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-2\">\n                <p class=\"u-text u-text-2\">Active Cell Coloring<br>Macro changes the active cell color to yellow and when left it reverts back to its original color.<br>\n                  <br>\n                  <br>\n                  <br>\n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/ColoredBoxes.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-2\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-3\">\n                <p class=\"u-text u-text-3\">Discount Function<br>User defined discount functions applied as a regular built-in spreadsheet function to calculate the discounted amount.<br>\n                  <br>\n                  <br>\n                  <br>\n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/CustomFunctions.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-3\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-4\">\n                <p class=\"u-text u-text-4\">TVM - Time Value of Money Calcs<br>Some basic financial calculations are provided on this example. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/SampleFinancialCalcs.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-4\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-5\">\n                <p class=\"u-text u-text-5\">INDEX MATCH Example<br>INDEX MATCH is a lot more powerful function than VLOOKUP. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/SampleINDEX_MATCH.xlsx\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-5\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-6\">\n                <p class=\"u-text u-text-6\">Excel Tips and Tricks<br>Many practical and useful Excel tips and tricks can be found on this document. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/95ExcelTipsv4.pdf\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-6\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-7\">\n                <p class=\"u-text u-text-7\">Absolute to Relative Value Conversion - From OzGrid<br>This macro was created by OzGrid for business applications and could be highly useful on a huge page of data that needs to be converted between absolute to relative addresses depending on the types of operations that need to be applied on the same range of data. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/Absolute_RelaltiveConversionMacro.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-7\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-8\">\n                <p class=\"u-text u-text-8\">Array Formula Example<br>Array functions are entered as [Ctrl+Shift+Enter] key combination into a cell not only by hitting the Enter key alone. Their power is looking into a range defined in the formula for the given criteria to perform the desired operation. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/ArrayFormula.xlsx\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-8\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-9\">\n                <p class=\"u-text u-text-9\">Display Respective Values<br>VBA on this file looks at the values in the range and show their corresponding values on the target or destination tab. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/ShowRespectiveValues.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-9\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-10\">\n                <p class=\"u-text u-text-10\">Indirect Function<br>Change the value in the yellow cell and see how the column values respond accordingly with the use of INDIRECT function. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/INDEX_MATCHSAMPLE.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-10\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-11\">\n                <p class=\"u-text u-text-11\">Extract and Display File Names<br>Macro on this file gets and displays he file names in the selected drive and folder. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/FileListingMacro.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-11\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-12\">\n                <p class=\"u-text u-text-12\">Dynamic Range Pivot Table Update<br>Macro updates the pivot table range for dynamically changing ranges. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/DynamicRangePivotSample.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-12\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-13\">\n                <p class=\"u-text u-text-13\">Totals by Cell Color<br>VBA to calculate totals by cell color. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/SumbyColor.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-13\" target=\"_blank\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-14\">\n                <p class=\"u-text u-text-14\">Refresh Multiple Pivots<br>VBA code on this file refreshes multiple pivot tales with dynamically changing data ranges. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/SamplePivots.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-14\" target=\"_blank\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-15\">\n                <p class=\"u-text u-text-15\">Compare Two Ranges for Changes<br>VBA in this file compares two ranges and if they are not identical creates another file indicating the cell in red where change occurred. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/RangeComparison1.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-15\" target=\"_blank\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-16\">\n                <p class=\"u-text u-text-16\">Email File Sender<br>VBA on this file emails the named files on the list from their original location to their corresponding email addresses on the list. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/ExcelMailTest.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-16\" target=\"_blank\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-17\">\n                <p class=\"u-text u-text-17\">Create Access Table from within Excel<br>Click on the button on the tab and it will create an Access file and append the data on the tab to a table in this Access file. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/CreateAccessTable.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-17\" target=\"_blank\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-18\">\n                <p class=\"u-text u-text-18\">Extract Year from Text<br>On this file GetYear function which is a user defined function acting like another built-in Excel function extracts the year from a text in a selected cell where ever that year is mentioned within the text. Using string functions in this case don't help unless you know where that year is located in the cell. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/ExtractYearFromText.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-18\" target=\"_blank\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-19\">\n                <p class=\"u-text u-text-19\">Combo Box Auto Feed for Selections<br>VBA code in this file feeds the associated items form the raw data set per the selection in the first column. On the properties of the Combo Box object, the linked range properties is left blank and it is populated dynamically after the selection is made in the first column. To make sure that code works after opening up the file make a selection in the first column in any of those boxes then check the items that get displayed on the associated drop down box positioned next to that selection. On file open when you get a prompt click yes to continue. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/ComboBoxSelections-Copy.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-19\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-20\">\n                <p class=\"u-text u-text-20\">Delete Rows Per Citeria<br>VBA in this file deletes all the rows designated as Delete. This is done without manually filtering for the criteria and carefully deleting only those rows from the range and gives flexibility if this operation is to be done repeatedly after each load of new data set. 2nd tab is the original data set. On file open when you get a prompt click yes on it. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/DeleteRows-Copy.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-20\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-21\">\n                <p class=\"u-text u-text-21\">To create a personal ribbon with only the desired menu items available.<\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/CustomExcelMenus.txt\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-21\" target=\"_blank\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-bottom-lg u-valign-bottom-md u-valign-bottom-xl u-valign-top-xs u-container-layout-22\">\n                <p class=\"u-text u-text-22\">Excel XLOOKUP Example<br>This file has various working examples to illustrate how to use XLOOKUP function instead of VLOOKUP which offers a whole lot more power and versatility for spreadsheet based analysis. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/XLOOKUP-Explained1.xlsx\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-22\">learn more<\/a>\n              <\/div>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-clearfix u-section-7\" id=\"carousel_6dd1\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <h4 class=\"u-align-center u-text u-text-default u-text-1\">\n          <span style=\"font-weight: 700; font-size: 2.25rem;\">EXCEL FOR PERSONAL INTEREST<\/span>\n          <br>\n          <br>I place files on this page not necessarily work related but of personal interest such as soccer, movies, workout tracking&nbsp;etc. and these files are&nbsp;not grouped by any classification.&nbsp;&nbsp;The site uploads Excel files with xlsx extension by default&nbsp;so if a file of interest is not opening it is because it has macros in it&nbsp;and requiers a download and save as with xlsm extension on your desktop.&nbsp; For this inconvenience I apologize. \n        <\/h4>\n      <\/div>\n    <\/section>\n    <section class=\"u-clearfix u-section-8\" id=\"sec-9941\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <div class=\"u-expanded-width u-list u-list-1\">\n          <div class=\"u-repeater u-repeater-1\">\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-top-sm u-valign-top-xs u-container-layout-1\">\n                <p class=\"u-text u-text-1\">2010 World Cup Soccer Fantasy<br>This file was tracking betting during the World Cup at 2010 at work amongst four people.<br>\n                  <br>\n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/WC2010FantasyMasterFile.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-1\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-top-sm u-valign-top-xs u-container-layout-2\">\n                <p class=\"u-text u-text-2\">Euro 2012 Soccer Championship<br>This file was created to track the European soccer championship matches. \n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/Euro2012Predictions.xlsx\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-2\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-top-sm u-valign-top-xs u-container-layout-3\">\n                <p class=\"u-text u-text-3\">World Cup 2018 Russia<br>This file has details of this world cup. When you get a prompt on opening the file click yes.<br>\n                  <br>\n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/WC2018FantasyMasterFile-Copy.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-3\">learn more<\/a>\n              <\/div>\n            <\/div>\n            <div class=\"u-align-center u-container-style u-list-item u-repeater-item\">\n              <div class=\"u-container-layout u-similar-container u-valign-top-sm u-valign-top-xs u-container-layout-4\">\n                <p class=\"u-text u-text-4\">Netflix Viewing Tracking<br>\n                  <br>\n                  <br>\n                  <br>\n                  <br>\n                <\/p>\n                <a href=\"https:\/\/www.rayerden.com\/wp-content\/uploads\/2024\/03\/NetflixRentalHistory.xls\" class=\"u-active-none u-border-hover-palette-2-base u-border-none u-border-palette-2-light-1 u-btn u-button-style u-custom-color-1 u-file-link u-hover-none u-text-white u-btn-4\">learn more<\/a>\n              <\/div>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/section>\n    <section class=\"u-clearfix u-custom-color-1 u-section-9\" id=\"sec-8656\">\n      <div class=\"u-clearfix u-sheet u-sheet-1\">\n        <h1 class=\"u-text u-text-default u-text-1\"> www.rayerden.com<\/h1>\n        <div class=\"u-social-icons u-spacing-10 u-social-icons-1\">\n          <a class=\"u-social-url\" title=\"facebook\" target=\"_blank\" href=\"https:\/\/www.facebook.com\/ray.erden1\/\"><span class=\"u-icon u-social-facebook u-social-icon u-icon-1\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-f041\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-f041\"><circle fill=\"currentColor\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M73.5,31.6h-9.1c-1.4,0-3.6,0.8-3.6,3.9v8.5h12.6L72,58.3H60.8v40.8H43.9V58.3h-8V43.9h8v-9.2\nc0-6.7,3.1-17,17-17h12.5v13.9H73.5z\"><\/path><\/svg><\/span>\n          <\/a>\n          <a class=\"u-social-url\" title=\"twitter\" target=\"_blank\" href=\"https:\/\/twitter.com\/unbiasedview\"><span class=\"u-icon u-social-icon u-social-twitter u-icon-2\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-7286\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-7286\"><circle fill=\"currentColor\" class=\"st0\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M83.8,47.3c0,0.6,0,1.2,0,1.7c0,17.7-13.5,38.2-38.2,38.2C38,87.2,31,85,25,81.2c1,0.1,2.1,0.2,3.2,0.2\nc6.3,0,12.1-2.1,16.7-5.7c-5.9-0.1-10.8-4-12.5-9.3c0.8,0.2,1.7,0.2,2.5,0.2c1.2,0,2.4-0.2,3.5-0.5c-6.1-1.2-10.8-6.7-10.8-13.1\nc0-0.1,0-0.1,0-0.2c1.8,1,3.9,1.6,6.1,1.7c-3.6-2.4-6-6.5-6-11.2c0-2.5,0.7-4.8,1.8-6.7c6.6,8.1,16.5,13.5,27.6,14\nc-0.2-1-0.3-2-0.3-3.1c0-7.4,6-13.4,13.4-13.4c3.9,0,7.3,1.6,9.8,4.2c3.1-0.6,5.9-1.7,8.5-3.3c-1,3.1-3.1,5.8-5.9,7.4\nc2.7-0.3,5.3-1,7.7-2.1C88.7,43,86.4,45.4,83.8,47.3z\"><\/path><\/svg><\/span>\n          <\/a>\n          <a class=\"u-social-url\" title=\"instagram\" target=\"_blank\" href=\"https:\/\/www.instagram.com\/erdenray\/\"><span class=\"u-icon u-social-icon u-social-instagram u-icon-3\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-8a2b\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-8a2b\"><circle fill=\"currentColor\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M55.9,38.2c-9.9,0-17.9,8-17.9,17.9C38,66,46,74,55.9,74c9.9,0,17.9-8,17.9-17.9C73.8,46.2,65.8,38.2,55.9,38.2\nz M55.9,66.4c-5.7,0-10.3-4.6-10.3-10.3c-0.1-5.7,4.6-10.3,10.3-10.3c5.7,0,10.3,4.6,10.3,10.3C66.2,61.8,61.6,66.4,55.9,66.4z\"><\/path><path fill=\"#FFFFFF\" d=\"M74.3,33.5c-2.3,0-4.2,1.9-4.2,4.2s1.9,4.2,4.2,4.2s4.2-1.9,4.2-4.2S76.6,33.5,74.3,33.5z\"><\/path><path fill=\"#FFFFFF\" d=\"M73.1,21.3H38.6c-9.7,0-17.5,7.9-17.5,17.5v34.5c0,9.7,7.9,17.6,17.5,17.6h34.5c9.7,0,17.5-7.9,17.5-17.5V38.8\nC90.6,29.1,82.7,21.3,73.1,21.3z M83,73.3c0,5.5-4.5,9.9-9.9,9.9H38.6c-5.5,0-9.9-4.5-9.9-9.9V38.8c0-5.5,4.5-9.9,9.9-9.9h34.5\nc5.5,0,9.9,4.5,9.9,9.9V73.3z\"><\/path><\/svg><\/span>\n          <\/a>\n          <a class=\"u-social-url\" target=\"_blank\" data-type=\"YouTube\" title=\"YouTube\" href=\"https:\/\/www.youtube.com\/channel\/UCNN_MT-0jUwoeMo5MLTZRxw\"><span class=\"u-icon u-social-icon u-social-youtube u-icon-4\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-7aeb\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-7aeb\"><circle fill=\"currentColor\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M74.9,33.3H37.3c-7.4,0-13.4,6-13.4,13.4v18.8c0,7.4,6,13.4,13.4,13.4h37.6c7.4,0,13.4-6,13.4-13.4V46.7 C88.3,39.3,82.3,33.3,74.9,33.3L74.9,33.3z M65.9,57l-17.6,8.4c-0.5,0.2-1-0.1-1-0.6V47.5c0-0.5,0.6-0.9,1-0.6l17.6,8.9 C66.4,56,66.4,56.8,65.9,57L65.9,57z\"><\/path><\/svg><\/span>\n          <\/a>\n          <a class=\"u-social-url\" target=\"_blank\" data-type=\"LinkedIn\" title=\"LinkedIn\" href=\"https:\/\/www.linkedin.com\/in\/ray-erden-m-a-business-economics-71b3a43\"><span class=\"u-icon u-social-icon u-social-linkedin u-icon-5\"><svg class=\"u-svg-link\" preserveAspectRatio=\"xMidYMin slice\" viewBox=\"0 0 112 112\" style=\"\"><use xlink:href=\"#svg-9ef2\"><\/use><\/svg><svg class=\"u-svg-content\" viewBox=\"0 0 112 112\" x=\"0\" y=\"0\" id=\"svg-9ef2\"><circle fill=\"currentColor\" cx=\"56.1\" cy=\"56.1\" r=\"55\"><\/circle><path fill=\"#FFFFFF\" d=\"M41.3,83.7H27.9V43.4h13.4V83.7z M34.6,37.9L34.6,37.9c-4.6,0-7.5-3.1-7.5-7c0-4,3-7,7.6-7s7.4,3,7.5,7\n            C42.2,34.8,39.2,37.9,34.6,37.9z M89.6,83.7H76.2V62.2c0-5.4-1.9-9.1-6.8-9.1c-3.7,0-5.9,2.5-6.9,4.9c-0.4,0.9-0.4,2.1-0.4,3.3v22.5\n            H48.7c0,0,0.2-36.5,0-40.3h13.4v5.7c1.8-2.7,5-6.7,12.1-6.7c8.8,0,15.4,5.8,15.4,18.1V83.7z\"><\/path><\/svg><\/span>\n          <\/a>\n        <\/div>\n      <\/div>\n    <\/section>\n    \n    \n    \n  \n","protected":false},"excerpt":{"rendered":"<p>Previous Next What do you find under my projects section? I add to this section from time to time various Excel files to illustrate the type of work that I do using Excel as part of&nbsp;an integrated Microsoft&nbsp;development&nbsp;platform for custom spreadsheet and&nbsp;tool design and&nbsp;process automation.&nbsp;&nbsp;The content here will be&nbsp;growing over time with relevant&nbsp;examples for VBA &hellip; <a href=\"https:\/\/www.rayerden.com\/index.php\/my-projects\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;MY PROJECTS&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":9,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-133","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/pages\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":5,"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/pages\/133\/revisions"}],"predecessor-version":[{"id":222,"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/pages\/133\/revisions\/222"}],"wp:attachment":[{"href":"https:\/\/www.rayerden.com\/index.php\/wp-json\/wp\/v2\/media?parent=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}