Tables are a great way to manage Excel data. Excel Video 421 shows how to reference and change a Table using VBA. As we continue our discussion about how to reference data using VBA, it’s worth a few minutes to understand how to work with Tables. If you aren’t familiar with Tables, watch Excel Videos starting with Excel Video 30 to quickly get up to speed. Tables are a great way to sort, filter, and analyze detailed data.
Watch for how to only select the visible cells in a Table and then copy those cells to another tab in the Excel workbook. It’s a great trick you might use with accounts receivable, denials, or other areas where you need to filter and then analyze a specific set of data. I’ll also briefly show you how to select visible cells without VBA if you need to.
