Results 1 to 7 of 7

Thread: [RESOLVED] Ranges and lookups using vba.

Threaded View

  1. Jan 22nd, 2010, 05:53 AM #1
    sgrya1
    sgrya1 is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2006
    Location
    London, UK
    Posts
    817

    Resolved [RESOLVED] Ranges and lookups using vba.

    Attached is what I want to do. I want to use vba to summarise the costs.

    This might seem lazy of me but I can do this (not easily) but it would take around 30-40 lines.

    I'm sure it can be done in 5 or 6 lines by setting two ranges and looking the data up. I just am not familiar with doing it.

    I have a whole timesheet project that has so far been done very clumsily in my eyes. Be great if I could tidy the whole thing up by shrinking the code and making it work faster.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width