table data

I have a data table for range A1:G2000 as there are a series of formula cells where I want to keep the formula preserved when rows are inserted. This works great, but anytime I select more than 2 cells, even non-formula cells with just text, Excel slows to a crawl. In addition, I have some VBA...

So this might be a silly question .... I have done some research and haven't quite found an answer that either makes sense to me, or is clear enough. I am having an issue with some of my formulas. I have workbook 1 (wb1) and workbook 2 (wb2). In wb1, I have some formulas, let's use Vlookup as...

Hello. I'm looking for a way to duplicate a 'master' Excel table so I can have the exact same table copied multiple times, side-by-side, but with each table sorted and/or filtered slightly differently. The idea is that only the 'master' table be edited and the other tables feed off of it and...

So I have 8 different tables, some with up to 65 columns, others less. Current I have formulas in the columns for those which need formulas. I kind of want to transition away from having the formulas in-cell, where they can be changed, erased, etc., to having them be coded. However, I am...

So I have some code that I have written referencing arrays, named ranges, and ranges. I have taken the workbook and re-designed it to be table based. I figure I will have to re-write the VBA code to reference the table objects instead of the ranges, right? Is there a simple way to do this or...

Hi Friends, Trying to extract table data from multiple urls at once with Excel VBA. Here are sample urls trying to extract from ColumnA <tbody> https://www.abbreviations.com/acronyms/NETWORKING/149 https://www.abbreviations.com/acronyms/NETWORKING/150...

A table of data that holds records of multiple projects. Projects may be duplicated within the table however, when they are, their Total Units are always the same number. Obviously, a problem with this is that I cannot easily provide a sum or subtotal of the Total Units without double counting...

Hello! So I am facing a problem with an excel problematic for my work I can't figure out on my own, even after researching a lot online (or when I try them they don't work). I have attacher the file if it helps: https://we.tl/7hopolpjUV. So I would like to replace à value in a cell by a...