+ Reply to Thread
Results 1 to 1 of 1

copy abbreviated format add a , add a cells value and paste to only blank cells

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    FL
    MS-Off Ver
    Excel 2013
    Posts
    123

    copy abbreviated format add a , add a cells value and paste to only blank cells

    Hello I'm trying to create a macro to shorten this process for me.
    I need to copy over the Source code, but in an abbreviated format(see below)

    A/R Adjustments Journal A/R AdjuJou
    Accounts Payable AccPay
    Direct Bill DirBill
    Direct Bill Invoice Receivable DB InvRec
    Direct Bill Receipt DB Receipt
    Direct Bill Disbursements DB Disburs
    Disbursements Journal DisburJour
    Financial Management Journal FinManJou
    Payables Adjustment PayAdjust
    Payables Check PayCheck
    Receipts Journal RecJour
    Sales Journal SalJour
    Received Payable RecPay

    then i want to add a , and a space and also copy over the client code. After all that i want to past in only the cells that have blanks(see attached)
    Attached Files Attached Files

+ 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. [SOLVED] Copy/Paste Loop Needs to Recognize Blank Cells
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2013, 11:50 AM
  2. Testing for blank cells within Copy / Paste Array
    By MizM in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2013, 11:39 PM
  3. [SOLVED] vba to copy non blank cells and paste to other worksheet
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 06:22 PM
  4. [SOLVED] copy/paste macro to selected blank cells
    By fumc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2012, 10:08 PM
  5. Copy and paste macro-blank cells thereafter.
    By Bikernick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2006, 12:00 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