Good day,

I have a workbook containing a worksheet that holds data for each day on a seperate line. Each row contains a new date & corresponding data.

Part of my macro that extracts the data from from one excell sheet into access is as follows:-

With Worksheets(1)

For i = 8 To 146 '<############## UPDATE( lines to extract)
dteDate = Cells(i, 1)
If Format(dteDate, "yyyy-mm-dd") <> "" Then
'-------------------------------------------------------------------------------------------
' Insert Daily Droduction into Field well
Call InsertDlyPrd("Field Name", _
dteDate, _
Cells(i, 22), _
"NA", _
Cells(i, 30))
'-------------------------------------------------------------------------------------------
End If
Next i


In this way i can specify which lines to extract.

However, now my data has grown so much that I have to span the data for each day across multiple sheets.

Is it possible to run my macro & loop it through specified sheets whilst still being able to specify which lines to extract? If so how?

My spreadsheet still only holds data for each day per row but this spans across mutiple sheets.