Copy data from from Left of cell

Closed
Report
-
 MIraj943 -
Hello,

This is my scenario. I have a list of users. Column A has their name. Column B has their phone number. Column C has their current status. If they choose Vacation then an input box should ask for how much time they are requesting.

Their name, phone number and, their requested time should be placed in another sheet.

So far I have this,

If Range("C4").Value = "Vacation" Then
answer = InputBox("Please select one of the amounts: 1. <= 1 Hour, 2. <= 2 Hours, 3. <= 3 Hours, 4. <= 4 Hours, 5. > 4 Hours.")
If answer = 1 Then
Sheets("Status").Range("C1") = "Requested <= 1 Hour"
End If
End If

I cannot figure out how to copy the info from Column A and B. Also I have other sheets and the same info has to be added to the last row of the "Status" sheet.

Any help would be greatly appreciated.

Thanks,

Miraj943

2 replies

Posts
24
Registration date
Friday August 15, 2008
Status
Member
Last seen
May 19, 2009
12
hello,

have you tried doing it with the help of macros ?
0
No, I am trying to do it all with VB.
0