View Single Post
  #1   Report Post  
Azrael
 
Posts: n/a
Default Whats the best way to...


Azrael Wrote:
Unfortunatley Access is not available. Since it is only 4 data cells and
a date to be recorded I was hoping that it would be a fairly easy thing
to do.


Answering my own question, I have found that:
Sub ps()
'
' ps Macro
' Macro recorded 9/12/2005 by David Carroll
'
'
Range("A7").Select
Selection.Copy
Sheets("Sheet2").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub

I then made a command button and attached the macro to it. This is not
the actual macro that I used (cell numbers are different), but this is
close. I then added code so that it pasted the copied information into
the next row to keep a running total.


--
Azrael