Time and Output

R

Reign

Hi everyone,

This might be a silly question and if it is then please just let me
know.

I'm currently designing a call centre input system but am having alot
of trouble as I'm fairly new to this sort of thing.

I have cell A1,A2,A3,A4,A5 have labels and then B1 etc I input the
information in and here is where the problems occur.

I want to click a command button and have that information clear but
copied onto another sheet and just keep filling. or onto a text file.

From here I will be also having a time function which I will be
inputting and having it averaged out but I want the time that I input
to be put into a different sheet so I can keep track for that day.

Is this possible to do and if so please point me in the right direction
as I said it's a stupid one but I need something like this.

Thanks
 
S

Sandy Mann

I don't really understand your explanation of what it is that you are trying
to do but, taking it one step at a time, to move the data form Sheet1 to
Sheet2 try something like:

Sub MoveIt()

Dim LastCol As Long
Dim LastRow As Long

LastCol = Sheets("Sheet2").Cells(1, Columns.Count). _
End(xlToLeft).Column + 1

LastRow = Sheets("Sheet1").Cells(Rows.Count, 2). _
End(xlUp).Row

Sheets("Sheet1").Range(Cells(1, 2), Cells(LastRow, 2)). _
Cut Destination:=Sheets("Sheet2").Cells(1, LastCol)

End Sub

activated by a button from the Forms Toolbar.

If that is the first thing that you wanted then post back with another
attempt at explaining what it is you want to do next.


--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top