Offset And Resize

I have 3 workbooks, the first one contains the data and the second is the �Table1� containing "Normal records" and the third is the �Table 2� containing only "900 Records". Tables 1 and 2 will be linked to Access�..

Here�s my issue�.

From workbook 1, I would like to copy data from certain cells that contain data to Table 1

From workbook 1, I would like to copy data from certain cells that contain 900 service records data to Table 2

In workbook 1, I have identified which information i want to keep by using the following formula,