+ Reply to Thread
Results 1 to 4 of 4

Copy paste data, insert rows, insert data and change . to -

  1. #1
    Registered User
    Join Date
    04-11-2010
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    44

    Copy paste data, insert rows, insert data and change . to -

    Ok, i hope the title isn't too long or wrong

    Here's the problem, i need to copy and paste 4 columns from 1 sheet to a new sheet. Column A from old sheet to column B of new sheet, column B from old sheet to column C of new sheet, column C to E and lastly D to D (yes, i purposly switch the columns)

    -This point onwards, all reference will be refering to the new sheet

    After that, i'll change the no. format of column C & E from 123.4567 or 12.3456 to 123-45-67 and 12-34-56, starting from row 3. i had came up with this formula
    Please Login or Register  to view this content.
    but i don't know how to change it to macro.

    Then, i'll delete those rows that has the value of BSTN from column B. Insert 1 row at row 3 and insert 3 rows between the 2 rows that got the same value of column B. And i'll have 4 sets of data. (if i insert 1 row at row 3, it will format the new row with the colour from row 2, anyway to disable that?)

    Lastly, I'll key in "#" at A1 & A2, "DB" at every begining of a new set, "DM" for the data and "DE" at the end of every set all at column A and i'll key in "3201" (which i got it from B1) at column B for every DB.

    Please see the attached excel for the sample and the incomplete macro that i had came up with bit and pieces from this forum and recording myself.

    Thanks for the help
    Attached Files Attached Files
    Last edited by xWiZardx; 04-16-2010 at 01:20 AM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Copy paste data, insert rows, insert data and change . to -

    Hi

    OK, here goes. Think I have it all

    Please Login or Register  to view this content.
    rylo

  3. #3
    Registered User
    Join Date
    04-11-2010
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    44

    Re: Copy paste data, insert rows, insert data and change . to -

    Wow, nicely done! thanks for the help & +1 reputation for you~

  4. #4
    Registered User
    Join Date
    04-11-2010
    Location
    Singapore
    MS-Off Ver
    Office 365
    Posts
    44

    Re: Copy paste data, insert rows, insert data and change . to -

    Oh, by the way, any good ways to use this macro? i'm thinking of saving this as a new excel file and when i got the data that i want to sort, i'll move the sheet to this new excel file with the macro and run the macro

+ 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