+ Reply to Thread
Results 1 to 6 of 6

Need help editing a macro and adding some things

  1. 07-04-2017, 01:13 PM #1
    lantros79
    lantros79 is offline
    Registered User
    Join Date
    07-04-2017
    Location
    Albany, Oregon
    MS-Off Ver
    Office 2016
    Posts
    3

    Unhappy Need help editing a macro and adding some things

    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
    Reply With QuoteRegister To Reply
  2. 07-04-2017, 02:39 PM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Need help editing a macro and adding some things

    We will go faster if you attach a short Excel sample file.
    Can you do it ...?
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  3. 07-04-2017, 02:46 PM #3
    lantros79
    lantros79 is offline
    Registered User
    Join Date
    07-04-2017
    Location
    Albany, Oregon
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Need help editing a macro and adding some things

    Here is a sample file, thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-04-2017, 04:30 PM #4
    cytop
    cytop is offline
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Need help editing a macro and adding some things

    I have a macro I've put together...
    I think PCI was alluding to the fact you have existing code (as well as data) - it would be helpful (to anyone who decides to try and help you) to actually see that workbook complete with both code and data.
    Reply With QuoteRegister To Reply
  5. 07-04-2017, 05:08 PM #5
    lantros79
    lantros79 is offline
    Registered User
    Join Date
    07-04-2017
    Location
    Albany, Oregon
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Need help editing a macro and adding some things

    I have attached a word doc with the full code for this doc. Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 07-04-2017, 06:23 PM #6
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,862

    Re: Need help editing a macro and adding some things

    crossposted: https://www.excelguru.ca/forums/show...ing-to-a-Macro

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    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)

Similar Threads

  1. Editing/Adding Conditional Formats to Macro
    By Caedmonball19 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-22-2013, 03:36 PM
  2. Adding things that just aren't there.
    By RemanBill in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2013, 10:40 AM
  3. Selecting 1 or more items from a list view example I found here and adding a few things
    By KurtN in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2012, 01:17 PM
  4. Macro Buttons for Editing and Adding Inventory
    By Philrulesw in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-10-2012, 06:26 PM
  5. [SOLVED] adding Hyperlink and editing this Macro
    By Paybac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2008, 06:24 PM
  6. Adding row without messing things up.
    By Iotrez in forum Excel General
    Replies: 1
    Last Post: 08-10-2006, 07:00 PM
  7. [SOLVED] Hyperlinks doing weird things when adding columns or rows
    By hssmith in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-30-2005, 12:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1