+ Reply to Thread
Results 1 to 7 of 7

Copy data from specific Cell into new file

  1. #1
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    170

    Copy data from specific Cell into new file

    Dear Excel FOX

    I have a long sheet where so many information, i want whenever i enter any thing in AA2 or AA3 or AA4 etc.
    a new file create and A2 or A3 or A4 date copy from orginal file and paste there.
    Got me or should i more elaborate it ......

    REgards

  2. #2
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Copy data from specific Cell into new file

    Could you please upload the sample file with at least 10 rows data and one more thing you just want to add new workbook for every column you mentioned here?
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  3. #3
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    170

    Re: Copy data from specific Cell into new file

    Thanks alot for ur response.
    File is attach for ur understanding.
    Thanks again.
    Regards
    Attached Files Attached Files

  4. #4
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Copy data from specific Cell into new file

    I have seen your file. It is still confusing for me, just tell me one more thing.....
    If you enter any data in A2,B2,C2,D2 or E2, then it should be paste into new workbook.
    I guess this is not a good idea, you should do one thing....I can create a button which will copy the whole active row data and paste it to new sheet.
    Like if you have cursor in A2 then it will copy whole the data in front of A2 and paste into new workbook....

  5. #5
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    170

    Re: Copy data from specific Cell into new file

    Actully i have to give specific info to other departmernts.
    so when ever i enter in aa1 or ab2 then spcific rows data copy in new file or existing file

    got me ??

  6. #6
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Copy data from specific Cell into new file

    I am not sure but I have just written the following code......
    If you want to change something in this.....please explain accordingly.....

    Please Login or Register  to view this content.
    Cheers....

  7. #7
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Copy data from specific Cell into new file

    If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I need to copy data from various workbooks into one master file, specific data
    By madhumith13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2013, 09:14 AM
  2. [SOLVED] Get file path from a cell, run a check to see if the file has a specific sheet if yes copy
    By Martha44 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2013, 03:35 AM
  3. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 AM
  4. [SOLVED] Macro to copy only specific data from a txt file to an excel file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 48
    Last Post: 04-13-2012, 02:11 AM
  5. Copy data from one file to another at specific location
    By s_anr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2009, 03:27 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