Results 1 to 10 of 10

Thread: Copy specific data from an excel template and paste in new workbook

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-01-2013, 05:19 PM #1
    excel_1317
    excel_1317 is offline
    Junior Member
    Join Date
    Jun 2013
    Posts
    25
    Rep Power
    0

    Exclamation Copy specific data from an excel template and paste in new workbook

    I have around 100 excel templates in a folder from which I need to extract data from specific cells and put in a separate workbook. Is this something that can be done macro. The logic is MACRO open first template -> Copy Specific Cells -> Paste into new workbook-> Close template-> Proceed open with next template....

    The cells(Summary sheet) which we need to copy are E5, D20, C43, D43, C46, D46, C85, D85, C87 and D87. I am attaching sample template and final output file.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy/Paste Excel Range/Chart into Powerpoint VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 03-13-2014, 02:59 PM
  2. Copy Row To Another Sheet Depending On Existence Of Specific Value In Specific Column
    By peter renton in forum Excel Help
    Replies: 8
    Last Post: 07-01-2013, 03:52 PM
  3. Macro to copy data in specific Columns
    By Howardc in forum Excel Help
    Replies: 0
    Last Post: 04-19-2013, 10:42 AM
  4. Copy webpage and paste it as HTML into an excel sheet using vba
    By LalitPandey87 in forum Excel Help
    Replies: 2
    Last Post: 04-08-2012, 09:42 AM
  5. Copy Existing Sheet, Paste Values from existing workbook into new workbook
    By crcline in forum Excel Help
    Replies: 9
    Last Post: 09-09-2011, 02:30 AM

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
  •  

Forum Rules