I would like to take a main workbook and right a code into my current code
that would look at the date on the main workbook and cross refernce that to
the data workbook. The data workbook already has the tabs named for each day
of the month (1,2,3,4...). I have a main worksheet that has the =now()
producing the date in format dd. How do I make this dynamic so that it will
look at different tabs that corrispond with the current date??
This is the current code:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 2/5/2006 by Eric Wagner
'

'
Workbooks.Open Filename:= _
"C:\Documents and Settings\Name\Desktop\LA Test\LA test.xls"
Sheets("1").Select
ActiveWindow.SmallScroll Down:=13
Range("C58").Select
Selection.Copy
ActiveWindow.SmallScroll Down:=-3
ActiveWindow.ActivateNext
Range("G6").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
ActiveWindow.ActivateNext
ActiveWindow.Close
End Sub

--
EW - Analyst