Results 1 to 5 of 5

Macro to follow this simple procedure

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-28-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365
    Posts
    298

    Exclamation Macro to follow this simple procedure

    Hi All,

    I usually do the steps below manually. Wondering if someone can help me with a macro for that:

    1) Select cells from B3 to the last populated cell in the column B
    2) Unmerge cells
    3) Select blank cells (usually I do that going to the HOME tab, then FIND & SELECT, then GO TO SPECIAL, then BLANKS)
    4) In the first blank cell (usually B4), write to be equal to the cell above (so I would insert in B4, "=B3")
    5) Control enter, so it can copy across all blank cells
    6) Copy and past values

    Example sheet attached.

    Thanks very much.

    Rick
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 12-20-2015, 03:55 PM
  2. Simple Procedure
    By ChompGator in forum Excel General
    Replies: 2
    Last Post: 01-03-2008, 02:24 PM
  3. Simple and Bulletproof Save/SaveAs Procedure
    By Lazzaroni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2006, 01:15 PM
  4. [SOLVED] [SOLVED] Trim function as a procedure - a simple example
    By aztecbrainsurgeon@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-26-2006, 12:30 PM
  5. Excel crashes on simple procedure
    By Daves_Solutions in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-14-2006, 01:10 AM
  6. [SOLVED] Shortcut Key to follow a Call'ed Procedure
    By Neily in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2006, 09:15 AM
  7. Is there a simple procedure to set my macros in Excel 2003 to be .
    By shelley in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-22-2005, 06:06 PM

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