Results 1 to 2 of 2

Replace a blank cell in a column by a specific text using a macro

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2016
    Location
    HYDERABAD
    MS-Off Ver
    2010 PROFESSIONAL PLUS
    Posts
    1

    Replace a blank cell in a column by a specific text using a macro

    Hi All,

    INPUT IN EXCEL : ACCOUNTNO BANKNAME DATE ID

    123456 SBI 2015-09-08 ADR345
    VBI 2014-09-07
    BY CASH UBI 2013-09-08 8U8U8


    OUTPUT REQUIRED: ACCOUNTNO BANKNAME DATE ID
    123456 STATE BANK OF INDIA 08/09/2015 M
    BY TRANSFER VIJAYA BANK OF INDIA 07/09/2014 M
    BY CASH UNION BANK OF INDIA 08/09/2013 M

    ACCOUNTNO COLUMN:HERE WHEN THERE IS A BLANK ,IT SHOULD BE REPLACED WITH BY TRANSFER

    BANKNAME COLUMN :WHEN THE INPUT IS IN SHORT FORM,IT SHOULD BE WRIITEN IN FULL FORM.

    DATE COLUMN : THE REQUIRED FORMAT IS DD/MM/YYYY

    ID COLUMN : THE TOTAL DATA SHOULD BE REPLACED WITH M

    I NEED A MACRO TO REARRANGE DATA IN REQUIRED MANNER`
    Last edited by sai abhilash; 02-07-2016 at 01:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help with adjusting/modifying macro to fit my data
    By thlee1122 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2015, 04:43 PM
  2. Macro: Need help modifying macro, pasting over a row of data
    By idontexcelinexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2014, 11:41 AM
  3. [SOLVED] Macro for Selecting and Modifying Special data in Graph
    By Haidar123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2014, 03:09 PM
  4. Modifying a macro to only clear a cell if it contains data and not a formula
    By ianpwilliams in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2013, 01:09 PM
  5. Need help modifying a macro to open up workbooks and paste filtered data
    By LinkiePoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2012, 04:14 PM
  6. Modifying sort data macro
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2010, 05:43 PM
  7. Modifying VBA to create new macro for recording data
    By sighlent1 in forum Excel General
    Replies: 2
    Last Post: 12-30-2009, 08:26 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