+ Reply to Thread
Results 1 to 4 of 4

Copy row from active file to another formated excell file and save as one cell value

  1. 08-16-2013, 01:27 AM #1
    snsuvarna
    snsuvarna is offline
    Registered User
    Join Date
    08-16-2013
    Location
    UDUPI
    MS-Off Ver
    Excel 2010
    Posts
    9

    Copy row from active file to another formated excell file and save as one cell value

    Hi,

    Please help me in creating bellow.

    I have excel file which contains 3000 rows (machine details) with second column containing machine serial no.

    I have another designed receipt to give customer for which I want to copy all the details of each machine and create different files for 3000 machines with Machine serial no as file name (save as).

    File which contains machine detail is serial.xlsx and receipt file is receipt.xls

    I want to copy from each row of serials.xlsx and make save as machine serial no file name.

    From serials.xlsx to Receipt.xls
    copy B2 content F23
    C2 content F25
    D2 content F27
    E2 content F29
    F2 content F31


    After copy SAVE AS file name should be content of F23 (ie Serial no of machine). Like this I want create 3000 receipt of all customers.
    Receipt cell no. will not change.

    Sample of both the files attached.

    Please provide the help.


    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-16-2013, 03:27 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Copy row from active file to another formated excell file and save as one cell value

    Put the RECEIPT sheet into the Serials workbook so they are together. Rename SHEET1 in the Serials workbook to Serials.

    Then try this macro... be sure to edit the SvPath first to where you want the new files to be stored:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JBeaucaire; 02-27-2014 at 11:59 AM.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 08-16-2013, 03:53 AM #3
    snsuvarna
    snsuvarna is offline
    Registered User
    Join Date
    08-16-2013
    Location
    UDUPI
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Copy row from active file to another formated excell file and save as one cell value

    Thank you so much Sir, It has helped me lot. I appreciate you for immediate support from you. great
    Reply With QuoteRegister To Reply
  4. 08-16-2013, 04:18 AM #4
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Copy row from active file to another formated excell file and save as one cell value

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA to save active sheet as new file with save as option
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-14-2013, 10:54 AM
  2. Macro to copy entries from a file (if they satisfy a condition) and save in a new file
    By caleb708 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2013, 06:23 AM
  3. [SOLVED] Copy two page from doc file and save in new doc file with excel creteria.
    By visha_1984 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-25-2013, 08:21 AM
  4. cannot 'save as' file in used excell file
    By badboymalc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2006, 04:00 PM
  5. copy excell file to a CSV file and than to Notepad
    By need to know bob in forum Excel General
    Replies: 0
    Last Post: 08-23-2005, 03:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1