+ Reply to Thread
Results 1 to 2 of 2

Cells values to be check and replace with specific text

  1. #1
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Cells values to be check and replace with specific text

    I have this date I have 3 Euiprments, I want to make a macro for replace numbers to eduipment name ,where cell contains value 1 till before next cell value =1 will be one equipment no
    see in column G
    All numbers (number of rows of any equipment will be vary time to time

    Srno
    1
    2
    3
    12
    3
    4
    5
    6
    12
    3

    see the attachment
    Attached Files Attached Files
    mast

  2. #2
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Re: Cells values to be check and replace with specific text

    Sorry see bellow ex.

    Srno
    [B]1
    2
    3
    [B]1
    2
    3
    4
    5
    6
    [B]1
    2
    3

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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