+ Reply to Thread
Results 1 to 2 of 2

Stuck with vba

  1. #1
    Registered User
    Join Date
    01-12-2020
    Location
    California
    MS-Off Ver
    2016
    Posts
    53

    Angry Stuck with vba

    The attached file represents a list of procedures; M represents tooth range which could be 1-8 UR, 9-16 UL, 17-24 LL and 25-32 LR (called quadrants); that is identified in columns W, X, Y, Z
    The problem I am having is with OralSurgery module; it's visible what it does and how it does it, it identifies one first entry, copies it in the schedule proposal and delete it from the source; then if other entries for the same identifier exist in column A, that are in the same quadrant, it adds the numbers listed in column M (in the source), it column AE (at the destination); also when it does that, it needs to exclude lines that have any entry in column R;

    It kind of works only halfway and I don't see where's the mistake; it should put in column AE of the destination the following: 31, 29, 28, 27, 26, 25 (because they are all in the same quadrant as the first entry found (LR); but it should not add 31 and 32 because an entry exists in R
    Willing to transfer 20 points for a solution.
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Stuck with vba

    Administrative Note:



    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Stuck on the [ ]
    By jarett in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2019, 06:39 PM
  2. [SOLVED] Stuck in VBA
    By Roeldh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2016, 08:31 AM
  3. Really stuck!!!!!
    By beccac247 in forum Excel General
    Replies: 1
    Last Post: 07-18-2014, 09:08 AM
  4. Stuck at work and stuck on a count function
    By gregfetzer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2012, 12:47 AM
  5. Im so stuck
    By Thunderbird in forum Excel General
    Replies: 1
    Last Post: 04-21-2011, 12:48 AM
  6. Help, please, I'm stuck
    By Harvest in forum Excel General
    Replies: 4
    Last Post: 06-11-2008, 06:10 PM
  7. [SOLVED] Stuck with an =IF
    By Mark R... in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2006, 12:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1