Recent Activities

update ------ the code attached works fine, it goes through all locations and saves as needed

however these 150 locations (files) now have to be sent to the managers. we do not want them to be able to select the dropdown in C2 once its been saved and…

Reached 1 year of membership at OzGrid

Good afternoon,
I have tried to insert an xlookup function within another xlookup function to determine the latter's value. The result comes back blank. I expect it is not possible to piggy back on off the other but wanted to check. If anyone has any…

\this is how I would do it. Look at the Yellow cells.

Each yellow cell in the table uses SUMIF to calculate the total.

The required amount is found using HLOOKUP and the value in G2.

Data Validation in G2 endures only the correct values can be picked.

That works out extremely well for me! Thank you!! Also, I realize that I meant to put this thread under the formulas section so thank you also for answering it despite the fact that I put it in the wrong area. The only change that I made with what you…

Hi,

I have an array(1 to 5) variant type variable and am trying to create a macro that will check to see if all spots within the variant array are filled or not. Is there a way that I can accomplish this with a simple if statement like:
if there are no…

The simplest way would be to Use AdvancedFilter with some VBA to move the ubique data to a different location then use the temporary data to load the ListBox. My website has a page with examples of loading unique values to a ComboBox with an example…

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

Please I need help. Excuse my English, I use Google translator.

I need a formula to…

Hi

There is a lot of topics on the web, how to get unique values from a excel worksheet, into a listbox in Userform
All is about single column listbox.

My problem is after I found the unique values I also want to display the entire row off the…

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

You don't need VBA to run MailMerge.

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure…

Reached 1 year of membership at OzGrid

(Code, 59 lines)







thanks so much

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid