Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,522
Default 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."
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
import data from txt file to an existing excel file shaji Excel Discussion (Misc queries) 1 September 12th 09 04:15 PM
import data into existing excel file Erik Excel Discussion (Misc queries) 0 January 15th 09 03:55 PM
import existing module JNW Excel Programming 10 May 18th 07 10:28 PM
Is it possible to import external data into existing pivote table helen shuchman Excel Discussion (Misc queries) 0 March 2nd 06 04:00 PM
import excel data into existing excel report Viggoros Excel Worksheet Functions 1 January 11th 06 03:29 PM


All times are GMT +1. The time now is 03:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"