Find an adresse of a specifc value excel 2007

# 1 Hi, I am a trader and I need a VBA macro that I can find in the text
the information I need and this information must be in the right cell that contains the
response of the search as in the attached, I need the volume into cell c1. I try with the search tool
but only the cell selection and I have not written the result in a different cell. The reason why I need that is because the answer can be in another cell.

# 2 I need a cell with time hh:mm which refreshes every minute

Thank you a lots  expert.xlsx
sharkyboyAsked:
Who is Participating?
 
dlmilleCommented:
1.  The Volume can be done with a Vlookup - no macro needed.

2.  on workbook open event the following sub is called

Sub refreshTimeOnSheet()
    Range("Time").Calculate
    Application.OnTime Now() + 60 / 86400, "RefreshTimeOnSheet"

End Sub

Will update your range "Time" in the worksheet - see yellow cell.

Enjoy!

Dave
Expert-r1.xls
0
 
sharkyboyAuthor Commented:
Wow Good job !!!
0
 
dlmilleCommented:
Please update to this code, or you'll run into problems.  I needed to stop the timer as well when you close the workbook, lol

Cheers,

Dave
Expert-r2.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.