+ Reply to Thread
Results 1 to 4 of 4

Button takes info from Sheet 1, transcribes to Sheet 2, info deletes on Sheet 1

  1. #1
    Registered User
    Join Date
    12-02-2016
    Location
    New York
    MS-Off Ver
    MS Office 2010
    Posts
    3

    Button takes info from Sheet 1, transcribes to Sheet 2, info deletes on Sheet 1

    Hi all!

    I fear that I have a basic VBA question / issue:

    Sheet 1 is a user form (pretty, easy to use, great!)
    Sheet 2 houses all raw data.

    When info is typed into Sheet 1, press button and all info transcribes to cells on Sheet 2 and deletes from Sheet 1 so that the user form can be used again. Having trouble with Shift Down so that when new information is added, it's transcribed to the row below raw data on Sheet 2.

    The code I have to take data from Sheet 1 to Sheet 2 works, but is overly complicated. I am new at this so I'm not trying to be fancy BUT there must be something better than the code I have now! I also cannot figure out how to shift down on Sheet 2 to allow for additional information to be added. Help!

    Here is the code I'm using now with Update being the name of the button:

    Please Login or Register  to view this content.
    Anyone have any ideas? Thank you also for your help! Much appreciated

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Button takes info from Sheet 1, transcribes to Sheet 2, info deletes on Sheet 1

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 12-02-2016 at 03:13 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    12-02-2016
    Location
    New York
    MS-Off Ver
    MS Office 2010
    Posts
    3

    Re: Button takes info from Sheet 1, transcribes to Sheet 2, info deletes on Sheet 1

    Thank you very much for the code! It works perfectly

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Button takes info from Sheet 1, transcribes to Sheet 2, info deletes on Sheet 1

    You're welcome. Thanks for the feedback.

+ 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. [SOLVED] Macro button that grabs info and sends to Sheet 2 with date.
    By 100n3y in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2015, 08:56 AM
  2. Replies: 3
    Last Post: 04-12-2015, 04:01 PM
  3. Replies: 1
    Last Post: 04-11-2015, 02:16 AM
  4. Replies: 3
    Last Post: 05-12-2014, 02:58 PM
  5. Copying Info From One Sheet & Posting Below Info on Another Sheet
    By Biegs101 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-13-2013, 11:39 AM
  6. Copy certain info in one sheet to a new sheet to a different area and rename new sheet
    By Elmarie_Potgieter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-14-2013, 05:34 AM
  7. Make a sheet with selectable info, send email using info selected
    By DwayneHeight in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2007, 12:18 PM

Tags for this Thread

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