Results 1 to 38 of 38

macro to move data from one cell to the adjacent,then to the third , then to the fourth

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2019
    Posts
    545

    macro to move data from one cell to the adjacent,then to the third , then to the fourth

    I have a workbook with five sheets. on sheet one, i have filled data in colmn C. when i Run the macro it should be moved to cell D.
    on the second sheet, when i run the macro the data in colmn D should move to col E and from col C to D.
    on the third sheet when i run the macro the data in col E should move to col F and D to E and C to D.

    It should be continued in the same way from col M and W ( entirely different items)
    on the fourth sheet the macro should be forced to effect the formulea in different columns which have been feeded.
    on the fifth sheet the macro should erase all the data from specified columns.


    data will be entered in columns C,M and W manually by the user.

    kindly provide macros to automate the process. thanks in advance. kindly see the attachment.
    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. move every fourth line to next column
    By crazyrobin in forum Excel General
    Replies: 3
    Last Post: 05-11-2016, 03:41 AM
  2. Move last word to adjacent cell .
    By Abinash4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2014, 09:32 PM
  3. [SOLVED] Match two celles and fill the third cell with data from the fourth
    By DiskusJon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2012, 01:12 PM
  4. Move Zip code to adjacent cell.
    By smithtec in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2011, 12:05 PM
  5. Move to next cell (not adjacent) for data entry
    By Winon in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-11-2007, 06:48 AM
  6. tab does not move to adjacent cell in excel
    By Karen Boyd in forum Excel General
    Replies: 1
    Last Post: 09-21-2005, 03:05 PM
  7. excel tab key to move to right adjacent cell
    By dwillie in forum Excel General
    Replies: 2
    Last Post: 01-26-2005, 04: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