+ Reply to Thread
Results 1 to 3 of 3

Need macro to jump to specific cell determined by date.

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    Uppsala, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    7

    Need macro to jump to specific cell determined by date.

    I'm new to macros.
    I need a macro that can paste to a cell determined by date. This is complicated by the fact that every dy of the3 year have 13 rows. Example: the rows for November 13 2012 start at row 4123 and end with row 4135.

    So far i have managed to make the macro paste determined by date with the lines below. But then it is only one row for everey day of the year.

    Please Login or Register  to view this content.
    I need to make this work with 13 rows per day or otherwise find some other solution.


    I hope somebody can help me out.

    /Michael


    Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.
    Last edited by arlu1201; 11-13-2012 at 09:48 AM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Need macro to jump to specific cell determined by date.

    Not quite sure this will do you any good, but maybe this modification can help:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-23-2012
    Location
    Uppsala, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    7
    Thanks, but it didn't change anything.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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