How to Consolidate Several Excel Files into One

Question

Creator

Topic
August 1, 2008 at 10:52 am #2154200

How to Consolidate Several Excel Files into One

Locked

by plexussage · about 14 years, 6 months ago

I have several retail locations that will automatically generate a report and dump it to a CSV file. I wrote a batch file to automatically upload the files to my FTP server at the main office. Now I want to automatically get those CSV files into one workbook with each location’s report in its own worksheet.
We are on Excel 2007.

Any tips?

Thanks!

This conversation is currently closed to new comments.
Creator

Topic

All Answers

Author

Replies
- August 1, 2008 at 10:52 am #2922179
  
  Clarifications
  
  by plexussage · about 14 years, 6 months ago
  
  In reply to How to Consolidate Several Excel Files into One
  
  Clarifications
- August 1, 2008 at 10:57 am #2922175
  
  Try this one out…
  
  by Anonymous · about 14 years, 6 months ago
  
  In reply to How to Consolidate Several Excel Files into One
  
  http://www.office-addins.com/-excel-addins/consolidation-assistant.html
  
  Please post back if you have any more problems or questions.
Author

Replies

Viewing 1 reply thread

Start or Search

Start New Discussion

This policy describes guidelines your organization can follow to track, process and decommission IT equipment. From the policy: SUMMARY An organization’s IT hardware inventory constitutes a significant capital investment in order to perform company operations. Because hardware represents a critical asset and often holds organizational data, it is important for the company to track each ...

Whether an infection is the result of a disgruntled employee, hardware vulnerability, software-based threat, social engineering penetration, robotic attack or human error, all organizations must be prepared to immediately respond effectively to such an issue if the corresponding damage is to be minimized. Because even the best protected networks become infected, all organizations must have ...

Every operating system should be appropriately secured, especially end user workstations which often contain or permit access to company data and upon which most employee job duties are based. To get the maximum security protection out of your Windows 10 deployments follow this checklist from TechRepublic Premium. Also included in this checklist: Security solutions Product ...

Networks

Question

How to Consolidate Several Excel Files into One

All Answers

Clarifications

Try this one out…

Hardware inventory policy

Malware response checklist

Checklist: Securing Windows 10 systems

Cloud data storage policy