Results 1 to 4 of 4

Macro copying and inserting to another sheet in sort order

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-20-2014
    Location
    Greece
    MS-Off Ver
    20 yr. old Excel 2002!
    Posts
    710

    Macro copying and inserting to another sheet in sort order

    Hi
    Being ignorant in VBA, I would like help creating a macro that would copy data which in column A are ="xyz" from sheet1 A:H and INSERT it (shift cells down) in sheet2 specific cell in sort order B,C,D and in sheet3 specific cell in sort order D,B,C.

    Thanks

    edit: The insertion must be pasted as Values.
    Last edited by drgkt; 12-18-2015 at 06:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-29-2014, 01:50 PM
  2. Copying 2 colums from one sheet and inserting them into another.
    By caj5888 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-02-2013, 02:49 AM
  3. Replies: 1
    Last Post: 05-23-2013, 10:16 AM
  4. Inserting new Rows & copying formulas in protected sheet
    By amlal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2012, 11:19 AM
  5. sort top five cells in order from other sheet
    By lostinexcel9 in forum Excel General
    Replies: 1
    Last Post: 11-02-2010, 11:05 PM
  6. Macro to Sort Based on order of a different sheet
    By _Ryan_ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2010, 12:47 PM
  7. Macro for copying and inserting a row
    By owainbaber in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-19-2010, 03:44 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