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...
Trying to extract table data from multiple urls at once with Excel VBA.
Here are sample urls trying to extract from
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...
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...