Results 1 to 6 of 6

Thread: Need help editing/adding to a Macro

  1. #1

    Unhappy Need help editing/adding to a Macro



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Everyone! I have a macro I've put together, but I am stuck on some things that I wanted to add to it, and can't figure out how. Here is what I want to add:

    • Add a new tab
    • If the value in column Z is greater than 30, bold that cell’s text
    • Delete empty bottom rows
    • If there is anything in column X, copy the full rows and paste in the 2nd tab
    • Do a spellcheck in column G and fix any misspellings
    • Remove all commas, quotes (“), and apostrophes (‘)
    • If the E column is empty, copy the C column and paste that into the E cell.
    • If cells are blank in column P, copy the value in Column O and paste in the P cell

    any help is appreciated, thanks!

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,573
    Articles
    0
    Excel Version
    365
    …and shall I lay out your clothes for the morning?

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,573
    Articles
    0
    Excel Version
    365
    cross posted without links:
    https://www.excelforum.com/excel-pro...me-things.html
    lauren1979/lantros79, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

    The rules are the same at most forums on this matter.

  4. #4

    RE: Links

    I Apologize! Here is a link to my other live post:

    https://www.excelforum.com/excel-pro...ml#post4690248

    Quote Originally Posted by p45cal View Post
    cross posted without links:
    https://www.excelforum.com/excel-pro...me-things.html
    lauren1979/lantros79, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

    The rules are the same at most forums on this matter.

  5. #5
    Since I don't have access to deletion, can you please delete this post? I apologize for the oversight.

  6. #6
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,663
    Articles
    0
    Excel Version
    2010 on Xubuntu
    As you have asked the same question on (at least ) two different forums under different usernames, it seems to me that you are trying to circumvent the cross-posting rules.

    Therefore I will not delete this thread so that the history of your posting remains on the forum.

    OTOH , I will close it
    Thank you Ken for this secure forum.

Tags for this Thread

Posting Permissions

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