+ Reply to Thread
Results 1 to 3 of 3

Help for creating code to enter previous month

  1. #1
    Registered User
    Join Date
    08-13-2009
    Location
    Glasgow
    MS-Off Ver
    Excel 2016,2016,365
    Posts
    92

    Help for creating code to enter previous month

    Hello,

    I am trying to enter in AE2 the date as dd/mm/yy in the previous month and fill to bottom.

    Any ideas?

    Thanks

    Ross

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,457

    Re: Help for creating code to enter previous month

    Any ideas?
    Absolutely none.

    You have the advantage of knowing what your workbook/worksheet/formulae/data look like and what you are trying to achieve and why. We have none of that information.

    With 70 posts, you might be expected to know that you'll need to provide some information if you want help.


    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Help for creating code to enter previous month

    Alter LR to suite
    Please Login or Register  to view this content.
    If days in previous month then
    Please Login or Register  to view this content.
    Last edited by jindon; 03-12-2019 at 08:47 AM.

+ 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] VB Code to enter 1st day of the month in Monthly sheet
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2018, 10:12 AM
  2. [SOLVED] Amend code to show previous month
    By flupsie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2018, 06:40 AM
  3. Amend code to show previous month
    By flupsie in forum Excel General
    Replies: 0
    Last Post: 01-31-2018, 02:06 AM
  4. VBA code adjustment to include only current month and previous month automatically.
    By ElmerFud in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-05-2015, 03:02 PM
  5. Replies: 1
    Last Post: 07-06-2015, 04:43 PM
  6. Macro using vlookups comparing 2 months paysheet(previous month and current month)
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2012, 03:45 AM
  7. Replies: 4
    Last Post: 03-19-2012, 08:58 AM

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