View full profile

Preferences
Newsletters
Community
Upgrade to Premium

More
- Editions:
- United States
- Australia
- United Kingdom
- Japan
Newsletters
Forums
Resource Library

Search Close

What are you looking for?
COVID-19
Developer
5G
IT Policy Downloads
Security
Top DaaS providers
Excel tips
Cloud
Big Data
Learn Python: Online training
Top 2020 DevOps trends
Top IT salaries
TechRepublic Academy
Best VPN Services

TechRepublic |
Forums |
Networks

Networks

Register Now or Log in to post
Welcome back,
- My Profile
- Log out
Recent Activity
FAQs
Guidelines

Question

0 Votes

Locked

How to Consolidate Several Excel Files into One

By PlexusSage · 13 years 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!

Share Flag

This conversation is currently closed to new comments.

+ Follow this Discussion ·

+ Follow this Discussion ·

Thread display: Collapse - | Expand +

All Answers

Collapse -

Try this one out...

by Peconet Tietokoneet-217038187993258194678069903632 · 13 years ago In reply to How to Consolidate Severa ...

http://www.office-addins.com/-excel-addins/consolidation-assistant.html

Please post back if you have any more problems or questions.

Share Flag

Back to Networks Forum

Search our forums

Start or search

Start New Discussion

Start New Discussion

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud
Piracy
Security
Apple
Microsoft
IT Employment
Google
Open Source
Mobility
Social Enterprise
Community
Smartphones
Operating Systems
Windows
Mac
Malware
Tablets
Networking
Browser
Hardware
Software
Web Developerment
Linux
Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.

Search our forums

Related Discussions

0

Linksys Velop: A simple solution for spotty Wi-Fi

tcavadias · 3 years ago
4

Email Service for gambling marketing

Olive Route · about 16 days ago
3

Does Backlinks still matter in SERPs ?

Olive Route · about 9 days ago
3

Unable to port forward

casiosharp · about 6 days ago
1

Basic home networking Q regarding use of a 2nd access point

keirlivock · about 6 days ago

Related Forums

Desktop · 25,183 discussions
Laptops · 2,739 discussions
Hardware · 19,123 discussions
Networks · 41,751 discussions
Storage · 2,074 discussions
Peripheral · 2,142 discussions

Commercial endorsement policy

Comparison guide: Top enterprise collaboration tools

Remote work policy

6 tips for structuring after-hours service support

Services

About Us
Manage Profile
Membership
Newsletters
RSS Feeds
Site Map
Site Help & Feedback

FAQ
Advertise
Reprint Policy
Do Not Sell My Information

Explore

Blogs
Downloads
TechRepublic Forums
Meet the Team
TechRepublic Academy

TechRepublic Premium TechRepublic Premium
Resource Library
Photos
Videos

© 2021 ZDNET, A RED VENTURES COMPANY. ALL RIGHTS RESERVED.
Privacy Policy | Cookie Settings | Terms of Use | A ZDNet site