+ Reply to Thread
Results 1 to 16 of 16

data transfer from one sheet to another with button

  1. #1
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    data transfer from one sheet to another with button

    Hi all,
    can anybody tell me how to transfer data from sheet 1 to Sheet 2. please see the attached sample sheet. when i OK button click all the data as per desired transfer to another sheet. i use =ref technique but not possible every time.
    also click OK button remove data from PO-Entry ready to for another data record.
    all yellow highlighted cell will be removed data.
    Attached Files Attached Files
    Last edited by majidsiddique; 02-13-2019 at 08:39 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Transfer DATA AUTO

    Post title now descriptive. Thanks
    Last edited by Pepe Le Mokko; 02-13-2019 at 09:27 AM.

  3. #3
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: Transfer DATA AUTO

    hi Pepe,
    i really when post in this forum, very much focus to thread title, i dont know where is the problem. if you say so i change it.

  4. #4
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: Transfer DATA AUTO

    Hi, Pepe Le Mokko,
    any help?

  5. #5
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: Transfer DATA AUTO


  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Transfer DATA AUTO

    You have several cells highlighted in yellow on the PO-Entry that don't exist in the PO-Detail. Do you want all the yellow cells transferred to PO-Detail or only the existing 8 columns in PO-Detail? If you want all the yellow cells transferred, you will have to add columns for then in PO-Detail.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  7. #7
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: Transfer DATA AUTO

    Hi Mumps1,
    Thanks to reply, you are right but i need only data required mention on PO Detail sheet. rest of other yellow highlighted cell are not too much important. you can see the snap but if i want to transfer them to increase more column add in PO detail sheet so kindly mention coding. otherwise detail is enough in PO detail sheet.
    Attached Images Attached Images

  8. #8
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: Transfer DATA AUTO

    For clarification:
    Do you want to add the 5 cells you highlighted with a red border to the PO-Detail sheet? Also, do you want to clear all the yellow cells in PO-Entry or just the cells that were transferred to the PO-Detail?

  9. #9
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: data transfer from one sheet to another with button

    Hi,
    Red border cell are not important to move, its optional, other yellow cell data will be tranfered po detail sheet, then press button data tranfer and clear all yellow cell contents ready for new data entry.

    Thanks

  10. #10
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: data transfer from one sheet to another with button

    Try this macro. If you need to add columns to PO-Detail, then attach a revised workbook with the additional columns.
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: data transfer from one sheet to another with button

    Hi Mumps,
    you are great, really fantastic.
    kindly tell me i need more columns data in po detail sheet. please see the revised attached file and see the more column data required.

    Thanks.
    Attached Files Attached Files

  12. #12
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: data transfer from one sheet to another with button

    Try:
    Please Login or Register  to view this content.

  13. #13
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: data transfer from one sheet to another with button

    Hi Mumps1
    its working perfect to transfer data but not clear the contents of PO entry sheet. please the snaps, if i am doing wrong please tell me?
    Thanks.
    Attached Images Attached Images

  14. #14
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: data transfer from one sheet to another with button

    It works for me. Try the attached file. Just click the "PO-Detail" button.
    Attached Files Attached Files

  15. #15
    Forum Contributor
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2013-365
    Posts
    500

    Re: data transfer from one sheet to another with button

    Hi Mumps1,
    i am very thankful to you, really great work, BUT i extremely sorry to say you that i am facing still same issue as well. i dont no why is this happening.
    your precious coding is working perfect. glad,
    Thanks a lot. in this VBA solution, i totally depend on you because i dont have enough knowledge to change any thing in coding or detect error.
    at all, thanks a lot. i dont know after this thread solved, can i ask more thing in extra in this issue?
    Thanks again Mumps1,

  16. #16
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,777

    Re: data transfer from one sheet to another with button

    Did the file I attached work properly for you including clearing the contents of PO entry sheet?

+ 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. Auto transfer data from one tab to another the graphs and auto update
    By Elsa_Lion22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2014, 02:15 PM
  2. Auto Data Transfer to Different Worksheet
    By tim.garrett in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2012, 10:02 AM
  3. auto transfer data to sheet2
    By patupat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2012, 08:09 AM
  4. auto-transfer data
    By rajat20001 in forum Excel General
    Replies: 12
    Last Post: 04-20-2009, 12:03 AM
  5. [SOLVED] Auto Data Transfer
    By Freshman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2006, 12:55 AM
  6. Auto Data Transfer
    By Freshman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-28-2006, 11:55 PM
  7. Auto Data Transfer
    By KRAMER in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2005, 02:06 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