Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|