+ Reply to Thread
Results 1 to 2 of 2

Macro to cut and paste data in below row contaning single digit

  1. #1
    Registered User
    Join Date
    09-25-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    88

    Macro to cut and paste data in below row contaning single digit

    Hello everyone!
    In sheet1 in column B i have TID i want each TID should cut and paste in below row contaning single digit.
    The output which i require is showing in sheet2 in column B.
    Any help would be greatly appreciated!

    Regards,
    upa
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    184

    Re: Macro to cut and paste data in below row contaning single digit

    Hi Dear,

    This is not a huge task that you need a macro.You can get the desired output just by inserting a new cell below TID & shift cells below.
    Easy and Fast.

+ 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. Color a single digit in a mult-digit number cell
    By Phyllis in forum Excel General
    Replies: 8
    Last Post: 09-30-2022, 04:22 PM
  2. [SOLVED] How to subtract single cells with double digits into a single digit of a single cell.
    By greenfox74 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-11-2021, 02:05 AM
  3. Need formula to extract a single digit per column from time data
    By purelutz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-22-2017, 10:29 PM
  4. Replies: 12
    Last Post: 03-05-2016, 03:03 PM
  5. Macro to identify 3-digit and 4-digit numbers as valid dates
    By gojakie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2015, 08:16 AM
  6. [SOLVED] LOTTERY FILTER#4, Find if 1 Digit Sum of 2 Digit or 3 Digit, Single Cell w/ dash
    By david gonzalez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2014, 12:57 AM
  7. Macro to add space to single digit
    By abraham30 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-11-2013, 03:39 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