Hi
I was wondering if you could help me.
I basically need to instruct excel to automatically plot the cell
value of a given cell, each day at set time.
So the two values would be the cell value and the date.
The cell value on same days may be the same as the previous day.
I thought using Excel's Ontime function may help performing a Macro
that does this periodcially.
In the root module of the workbook I've added:
Private Sub Workbook_Open()13:00:00"), "MyMacro"
End Sub
On the spreadsheeet that has the value in A1 I've added the following
code to a new module:
Sub MyMacro()
Application.OnTime TimeValue("13:00:00"), "MyMacro"
Range("A1").Select
Calculate
ActiveWorkbook.Save
End Sub
I have no experience of writing macros whatsoever and need help on
writing a macro ("My Macro") that will look up the cell value, e.g.
A1, and add this to a list of cell values that have been obtained
alredy from previous days to a separate sheet.
Any help would be appreciated.
Many thanks
Pravin
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
