Recent Activities

  • Mirinjawbro

    Post

    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
  • ortho75

    Has received the trophy Yearling.
    Trophy
    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…
  • EnginerdUNH

    Like (Post)
    \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.
  • EnginerdUNH

    Post
    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…
  • EnginerdUNH

    Thread
    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…
  • ppcash

    Posted the thread MAX date with conditions.
    Thread

    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
  • kathy125

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • cristinamerry

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • lexisbet

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • royUK

    Post
    You don't need VBA to run MailMerge.
  • royUK

    Post
    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…
  • Mary Taylor

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • Mirinjawbro

    Post
    (Code, 59 lines)







    thanks so much
  • stacy09

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • jackrootaj

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • peterjhonaj

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • jackandersonaj1

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid