+ Reply to Thread
Results 1 to 6 of 6

I need to write a macro that autopoloulate to different sheet and auto sort

  1. #1
    Registered User
    Join Date
    06-01-2013
    Location
    San Francisco
    MS-Off Ver
    Excel for Mac 2004
    Posts
    3

    I need to write a macro that autopoloulate to different sheet and auto sort

    I've got a multi-tab spreadsheet which has separate tabs for each of a person's clients. I am trying to make it so that when one enters a date and a payment amount in the next available cells on an individual client tab it fills in a slot on another sheet that acts as a repository. Basically, this supersheet/repository will have a date column and then a column for each client by initial. The row will have specific date and specific payment amount. The trickiest part feels like getting payments from different clients who come in on the same date to fill into the same row and for the rows/data to autosort by date. The days on which client sessions happen are not every day of the week and there is only a semi-stable pattern to which days of the week.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: I need to write a macro that autopoloulate to different sheet and auto sort

    Can you post a sample? (Go to Advanced - Click on the paper clip and follow the instructions)
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    06-01-2013
    Location
    San Francisco
    MS-Off Ver
    Excel for Mac 2004
    Posts
    3

    Re: I need to write a macro that autopoloulate to different sheet and auto sort

    Here you go. The sample client tab is initials RO and the Great Repository is where I want info to travel to.(writing this sheet for a friend with titles they feel are accessible).
    Attached Files Attached Files

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: I need to write a macro that autopoloulate to different sheet and auto sort

    Hi AMDanger,

    Try this code in the "ThisWorkbook" module:

    Please Login or Register  to view this content.
    Directions for running the routine(s) just supplied

    Copy the code to the clipboard

    Press ALT + F11 to open the Visual Basic Editor.

    Save your Workbook As Macro-Enabled

    Select “ThisWorkbook" from the Insert menu

    Paste the code in the whitespace of the module

    And you're ready to go!
    Last edited by xladept; 06-01-2013 at 05:04 PM.

  5. #5
    Registered User
    Join Date
    06-01-2013
    Location
    San Francisco
    MS-Off Ver
    Excel for Mac 2004
    Posts
    3

    Re: I need to write a macro that autopoloulate to different sheet and auto sort

    Thank you! I'm still having difficulty:

    I entered the code you sent in the ThisWorkbook file in Visual Basic Editor. When I enter a payment on one of the client tabs, it tells me the Sub or Function is not defined and highlights the first line of code.

    Thank you dearly,
    Annie

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: I need to write a macro that autopoloulate to different sheet and auto sort

    Hi Annie,

    Here's my copy:Income from Clients.xlsm: - I forgot to mention that the tab name RO needed to be changed to R.O. -

+ 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