+ Reply to Thread
Results 1 to 5 of 5

Find last entry for year (excluding current year) Copy and insert Row

  1. #1
    Registered User
    Join Date
    05-03-2009
    Location
    essex
    MS-Off Ver
    Excel 2007
    Posts
    5

    Find last entry for year (excluding current year) Copy and insert Row

    Hi All

    can anyone help start me off in the right direction.

    i Would like to create a piece of vba that would search a worksheet for the last entry in column D:D. for any year excluding the current year. and copy and insert the last row for that year on the next row (or Underneath the last entry for that year).

    It would then be run as a end of year type function. There are more than 500 worksheets but they are all formatted the same that the VBA would need to run on, they are sandwhiced between 2 blank works sheets "start" & "end".

    Below is two examples copied from the sheet fig 1 is as the sheet is at present & Fig 2 is an example of how the sheet might look after the VBA has run.

    Fig1

    jeanie.gif




    Fig 2
    jeanie.jpg




    Thanks in Advance

    Mark

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Find last entry for year (excluding current year) Copy and insert Row

    Hi, can you please Post a excel workbook. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping.

  3. #3
    Registered User
    Join Date
    05-03-2009
    Location
    essex
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Find last entry for year (excluding current year) Copy and insert Row

    Thank you for your prompt reply

    on your advice please see attcahed worksheets




    ~$Book2.xlsm

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: Find last entry for year (excluding current year) Copy and insert Row

    Hi, you've uploaded shortcut.. Please upload a workbook

  5. #5
    Registered User
    Join Date
    05-03-2009
    Location
    essex
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Find last entry for year (excluding current year) Copy and insert Row

    Sorry Just getting used to this Forum, lets seee if this works
    Attached Files Attached Files

+ 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