+ Reply to Thread
Results 1 to 3 of 3

Entering data on "Main" sheet and sending to appropriate sheet

  1. #1
    Registered User
    Join Date
    06-19-2009
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    15

    Entering data on "Main" sheet and sending to appropriate sheet

    Hello everyone, I currently have 4 sheets in a workbook. They are... "Main", "Safety", "1 Week Response" and "Routine" I would like to enter data into the "Main" and have it automatically send that data to the corresponding sheet name. Example: On the "Main" sheet I enter in row 1 column "A" the number 520; column "B" I enter Safety. Then I want to push a macro button that sends this data to sheet "Safety" in the next available row.

    Can anyone help?

    Mike
    Last edited by mikesjd110; 09-23-2009 at 11:50 AM. Reason: Solved

  2. #2
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Re: Entering data on "Main" sheet and sending to appropriate sheet

    This code might be useful:

    Please Login or Register  to view this content.
    Find the attached workbook. Make sure you enable macros.

    Regards,
    Karan
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-19-2009
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Entering data on "Main" sheet and sending to appropriate sheet

    That's it. Thanks for the help

+ 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