Copy data from from Left of cell

Closed
Miraj943 - Sep 23, 2008 at 07:19 AM
 MIraj943 - Sep 23, 2008 at 04:13 PM
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
Related:

2 responses

starsailors.me Posts 24 Registration date Friday August 15, 2008 Status Member Last seen May 19, 2009 12
Sep 23, 2008 at 01:21 PM
hello,

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