Could you show us the formula?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"EA4Life" wrote in message
...
I have 2 workbooks that I want to pass data through. One workbook has a
data
entry sheet for 16 different operation lines. Data is entered into that
workbook for the day and then totalled. There are 365 duplicates of this
chart in the workbook each cooresponding to a date. The 2nd workbook
pulls
the totals from the 1st workbook and stores the totals by date. I am
using
the Vlookup function to pull the data according to date.

My problem is that I have all my formulas in the 2nd workbook to pull the
data from the 1st workbook, but the next set of totaled data is 35rows
down.
Is there a way to change the formula in the 2nd workbook so I can just
drag
the formula down and it only pull data every 35th row? If that will not
work
then the whole processes will have to be manual as I am not going to type
in
the formula (365*16*72*2) times...

Thanks in advance for the help guys!