+ Reply to Thread
Results 1 to 2 of 2

How to create a command button to transfer CALCULATED data to another worksheet

  1. #1
    Registered User
    Join Date
    04-06-2011
    Location
    Annandale, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question How to create a command button to transfer CALCULATED data to another worksheet

    I need help creating a template that I will use to import data that will be summarized and calculated for certain percentages.

    What I need help on is creating a COMMAND BUTTON that when pressed will transfer the data in the next line on worksheet 1.

    So this is the process.

    - I copy and paste (import) the data to worksheet 3.
    - Using defined names for ranges in worksheet 3, calculations such as total number of data (rows), percentage etc will be calculated in worksheet 2
    - THE COMMAND BUTTON WILL BE ON WORKSHEET 2 that will transfer the result to the next row on worksheet one.

    The point is, the data being pasted on worksheet 3 will constantly change every month but I want to keep a track of month to month change on worksheet 1.

    I hope I explained myself well.

    I've attached the test template

    Thanks for the help
    Attached Files Attached Files
    Last edited by LTY9; 04-06-2011 at 06:03 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: How to create a command button to transfer CALCULATED data to another worksheet

    The Contacts form example has code that you can adapt
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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