import data from a non existing datafile
 

i like to make workbook where i con import data from workbooks.
Those workbooks are monthly new, every day is new.

The first date is the first tabsheet.
The second day is the second tabsheet.
Now i need info from those 2 sheets en when the nbext day is there i like to
have from that sheet data.

This dat is needed tofollow up data comparing en calculating so that we know
whats going on.

I like tht this new workbook see to all days that was and the days the come,
this for the month and for a year.

is this possible.

thx in advance.

import data from a non existing datafile
 

On Jul 31, 12:51*pm, "Albatros" wrote:
i like to make workbook where i con import data from *workbooks.
Those workbooks are monthly new, every day is new.

The first date is the first tabsheet.
The second day is the second tabsheet.
Now i need info from those 2 sheets en when the nbext day is there i like to
have from that sheet data.

This dat is needed tofollow up data comparing en calculating so that we know
whats going on.

I like tht this new workbook see to all days that was and the days the come,
this for the month and for a year.

is this possible.

thx in advance.

I recommend importing to ONE sheet with the data column as col A. Then
use filters and SUBTOTAL(109 etc for your analysis.

"If desired, send your file to dguillett1 @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."