Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import data from txt file to an existing excel file | Excel Discussion (Misc queries) | |||
import data into existing excel file | Excel Discussion (Misc queries) | |||
import existing module | Excel Programming | |||
Is it possible to import external data into existing pivote table | Excel Discussion (Misc queries) | |||
import excel data into existing excel report | Excel Worksheet Functions |