Finding external Excel files and crating a dashboard.

T

trumb1mj

Problem:

I have a folder where Excel files(.xls) are frequently being added and
updated. I need to build a "dashboard" type Excel file that can:

1) look in this folder
2) find any Excel files
3) take a totals row from these files
4) add the totals rows in a single row on the Excel file I am creating.
 
M

mrice

It would be worth recording this sequence to get m ost of the necessary
code. Then you can amend this with a section which uses the
DIR(Path*.xls) statement to get the list of files. Then just loop the
macro around.
 

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

Similar Threads

Excel Import External Data by Date Automatically 0
MS Query SQL File Location 3
Excel Query setup 0
Finding total # of records in an Excel file without scrolling 5
Importing CSV file with more than 65535 rows to Excel 2007 9
Dynamic Excel data into locked Word form 0
Excel Excell .xls File Growing Fast 0
Import Multiple XML Files into Excel 3

Top