Results 1 to 2 of 2
  1. #1
    BrisNed
    Guest

    Selecting Last Value in a cloumn of values

    I am trying to program a small pay sheet and want to set a date field value as the last date value entered in a particular column.
    At present I am entering this value manually onto the pay sheet. This value is then pulling in the values for the other values such as net, tax and gross etc.
    I would also like to have a macro to print out the pay sheets for all the staff that worked in that particular week.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Selecting Last Value in a cloumn of values

    If your dates are consecutive, that is the most recent is the latest entry in the column, then =MAX(A:A) should return the required date if the column used is A. You can of course confine it to a specific range within the column , e.g. = Max(A2:A53)

    As to the print macro, that would depend the structure of the rest of your worksheet, but should be possible. If you could provide a sample file with dummy data, I am sure somebody would help.

    Andrew C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •