|Subject:||inputbox and vlookup - from a rank beginner|
|Posted by:||Peter (~gleesonpet…@optusnet.com.au~)|
|Date:||Thu, 13 May 2004|
hi......very much a beginner here...but I have managed to put together a sub
that gives me a small table from an output of telesales operators
calls....columns involve "calls made", "#sales", "total$"
Each operator has 2 "2opnumbers" (not always the same each day) so I am now
trying to put together a sub that allows me collate the info from the table
using an input box to allow me to assign a name to each "opnumber"..
from there lookup each op's credits, and sum the two credits for each op
(does that make sense?)
I've tried the following, which doesn't work.
Would someone like to help?
user1 = Val(InputBox("Maureen, First Op#", 1))
user2 = Val(InputBox("Maureen, Second Op#"))
mc1 = "=vlookup(user1,f8:j8,2)"
mc2 = "=vlookup(user2,F8:J8,2)"
Worksheets("opstats 154").Range("n4") = "=sum(mc1+mc2)"