Results 1 to 3 of 3

Copy, Paste and Sort with VBA

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2010
    Location
    Gothenburg, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    6

    Copy, Paste and Sort with VBA

    Hello,

    I have attached one dummy file with the problem and wanted result. I have a long list with different materials and price changes, and I need to sort them as it is in file. Copy all data for one material (sometimes only one row, and sometimes 5 or 10 rows) and paste it at other sheet. Then sort data by date (descending). Last date comes first and all data from that row follows, Then it comes next date with data.

    Then I take second material and paste all data into other sheet with one empty row between last material. Sort it same way and jump to next.

    I tried to solve it by myself but I am stuck

    Thanks in advance.
    Attached Files Attached Files

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