Is "ImportData" the name of the second macro? If so, I would place it there
at the first. After the macro has determined and selected the proper
worksheet, it can then locate the correct cell(s) for inserting the new data.

I am heading home from work but will check back as soon as I can so I can be
sure I am really helping.

Jim


"buzzharley" wrote:

>
> Thanks so much for your help Jim- Where should I put it in the macro? I
> assume it would be in the first macro?
>
>
> Workbook_Open()
> If DatePart("m", Date) = "1" Then
> Sheets("Jan").select ' or however you have named the January sheet
> elseif DatePart("m",Date) = "2" then
> Sheets("Feb").select
> 'through the twelve months
>
> Dim dTime As Date
> dTime = Time
> If dTime >= TimeValue("9:30 PM") And _
> dTime < TimeValue("9:40 PM") Then
> ImportData
> End If
> End Sub
>
>
> --
> buzzharley
> ------------------------------------------------------------------------
> buzzharley's Profile: http://www.excelforum.com/member.php...o&userid=35886
> View this thread: http://www.excelforum.com/showthread...hreadid=559474
>
>