Excel formula in vba fails
i have a script which worked but now fails.
How to Automatically Filter a Table Based on a Dropdown Selection in Excel?
I am working with a Microsoft Excel spreadsheet and need some help with automating a filter based on a dropdown selection. Here’s the scenario:
$lookup not working with multiple tables and sheets
i have several tables on several sheets I am trying to type in a “Ticket #” on a table “x” in cell c3 and have it reference table “z” on “sheet.Ticket#” to get the name associated with that number (First(b2), Last name(c2)) and place it in A3 in the original table. $lookup is not working for this, need help with making a VBA.
VBA – How do I write this VBA formula properly?
I am trying to create formulas based off a filtered list.
Here are two other ways I’ve tried to make it, but still no success. Both formulas are trying to create the same thing, but neither work. All the variables and dictionary are functioning, I just need to write the formula correctly.