Results 1 to 11 of 11

Update several cells based on entry

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2011
    Location
    Tall, Lebanon
    MS-Off Ver
    Excel 2003
    Posts
    14

    Update several cells based on entry

    Hello again

    pls take a look at these two sheets


    how can I change the contents of one cell or a range of cells in a column based on
    two cells ( here i.e. : ldate & Type) & update the found range of cells with a certain amount???


    (all the cells in the column Amt will change if we have in sheet 1 the type A & date < 1/1/2003 - of course we have a link in the nb because we have 2 sheets)

    Thank you
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by JStud; 01-10-2011 at 04:19 PM.

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