Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"