import data from a non existing datafile

A

Albatros

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.
 
D

Don Guillett

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 liketo
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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top