+ Reply to Thread
Results 1 to 11 of 11

Automate cells data

  1. 02-06-2009, 11:39 AM #1
    LarryC
    LarryC is offline
    Registered User
    Join Date
    10-15-2007
    Location
    Charlotte, NC
    MS-Off Ver
    2003
    Posts
    50

    Automate cells data

    Good morning everyone!

    I have a spreadsheet that I need one thing automated on it (for now). It is a tracking sheet for our QA coordinators. What happens is they have a list of medical charts that are incomplete, when they mark the column complete with an "x" then the cell that contains and "x" under the Team Leaders name should disappear.

    I have a code similar but I don't know who to use and array in the code.

    This is what I used to change the date of a fields automatically (I recieved this from someone on line here)
    Please Login or Register  to view this content.
    I have attached a spreadsheet for you to check out.

    Any help would be appreciated!

    Larry
    Attached Files Attached Files
    Last edited by LarryC; 02-11-2009 at 09:51 AM. Reason: SOLVED.... YAY!
    Reply With QuoteRegister To Reply
  2. 02-06-2009, 01:58 PM #2
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Automate cells data

    Maybe

    Please Login or Register  to view this content.
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
  3. 02-06-2009, 02:46 PM #3
    LarryC
    LarryC is offline
    Registered User
    Join Date
    10-15-2007
    Location
    Charlotte, NC
    MS-Off Ver
    2003
    Posts
    50

    Re: Automate cells data

    THANK YOU! that solved it!

    How do you mark it as solved?

    Larry!
    Last edited by LarryC; 02-06-2009 at 02:48 PM. Reason: trying mark it solved.
    Reply With QuoteRegister To Reply
  4. 02-06-2009, 02:51 PM #4
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Automate cells data

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save
    Reply With QuoteRegister To Reply
  5. 02-06-2009, 06:13 PM #5
    LarryC
    LarryC is offline
    Registered User
    Join Date
    10-15-2007
    Location
    Charlotte, NC
    MS-Off Ver
    2003
    Posts
    50

    Re: Automate cells data

    Hi VBA Noob!
    I am very satisfied with the answer! Having said that, they added a few things here and there on the form and asked for another "automatic" population of cells.

    I took you code, read through it, understand it and tried to re-write something similar for the "extra" stuff they threw in there. The problem I have is with the new code not changing once the cell has an "x" in it. It changes once you "go back" to the cell, everything is right.

    There is that one "extra" step in there that is wierd.

    Can you look at it?
    My modified code for the first part....works fine!
    Please Login or Register  to view this content.
    Moved you code to this function areaThis is where the extra step is somehow)
    Please Login or Register  to view this content.

    I have attached the new spreadsheet to demostrate what I am talking about.
    Thanks!

    Larry
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 02-06-2009, 06:37 PM #6
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Automate cells data

    The 2nd code is 
    Please Login or Register  to view this content.
    ad not a
    Worksheet_Change
    so will only run when you select the cell.

    You need to merge the two under the
    Worksheet_Change
    VBA Noob
    Reply With QuoteRegister To Reply
  7. 02-09-2009, 12:45 PM #7
    LarryC
    LarryC is offline
    Registered User
    Join Date
    10-15-2007
    Location
    Charlotte, NC
    MS-Off Ver
    2003
    Posts
    50

    Re: Automate cells data

    Okay VBA Noob,
    I have tried a few different ways and I KNOW it is an easy fix but I can't seemt to get it.

    How may nested statements can be inside the "With...end With"?

    I tried this...(2 with Target Statments)...doesn't work:
    Please Login or Register  to view this content.
    Tried this but the second part doesn't work"

    Please Login or Register  to view this content.
    Any suggestions? I am really trying to understand this and it is super frustrating becaus I KNOW I am missing something easy.

    Larry
    Reply With QuoteRegister To Reply
  8. 02-10-2009, 10:54 AM #8
    LarryC
    LarryC is offline
    Registered User
    Join Date
    10-15-2007
    Location
    Charlotte, NC
    MS-Off Ver
    2003
    Posts
    50

    Re: Automate cells data

    Could anyone out there help with this? nested loops within the "With...end With"?

    Larry
    Reply With QuoteRegister To Reply
  9. 02-10-2009, 07:03 PM #9
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Automate cells data

    Not sure what you wanted by try this select case

    Change numbers to columns numbers you are dealing with

    Please Login or Register  to view this content.
    VBA Noob
    Reply With QuoteRegister To Reply
  10. 02-11-2009, 09:49 AM #10
    LarryC
    LarryC is offline
    Registered User
    Join Date
    10-15-2007
    Location
    Charlotte, NC
    MS-Off Ver
    2003
    Posts
    50

    Re: Automate cells data

    THANKS VBANoob!!

    I had to modify it a bit but it works great! Thank you!

    Here is my modified bit:

    Please Login or Register  to view this content.
    Thanks Again!

    Larry
    Reply With QuoteRegister To Reply
  11. 02-11-2009, 10:00 AM #11
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Automate cells data

    LarryC,

    Good to see you got it working

    VBA Noob
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1