Results 1 to 5 of 5

Change List Depending on Cell Entry

Threaded View

zimbo109 Change List Depending on Cell... 03-24-2010, 04:09 PM
NBVC Re: Change List Depending on... 03-24-2010, 04:13 PM
zimbo109 Re: Change List Depending on... 03-24-2010, 04:16 PM
NBVC Re: Change List Depending on... 03-24-2010, 04:22 PM
zimbo109 Re: Change List Depending on... 03-24-2010, 04:24 PM
  1. #1
    Forum Contributor
    Join Date
    02-05-2010
    Location
    Exeter, England
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    180

    Change List Depending on Cell Entry

    I have 2 WS "Estimate" & "Rate Table" sheets1 & 2 accordingly. The rate table has rates in column E. What I would like to achieve is that when a user enters a postcode in "Estimate" C19 this runs a calculation on "Rate Table" Column E depending on the postcode entered (picking up on just the first 2 letters of postcode i.e CT4 5RT

    Something Like (in my pigeon code!)

    If Sheets"Estimate" LEFT (C19,2)= " inserting many postcodes" then
    Sheets "Rate Table" Column E *75%,90%,95%,100%,110%,120%
    Last edited by zimbo109; 03-24-2010 at 04:25 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