Search

What are you looking for?

IT Policy Downloads
Coronavirus
5G
Developer
Top DaaS providers
More
- Security
- Excel tips
- Cloud
- Big Data
- Learn Python: Online training
- Top 2020 DevOps trends
- Top IT salaries
- TechRepublic Academy
- Best VPN Services
- All Topics
- Sections:
- Photos
- Videos
- All Writers
- Editions: US
View full profile
Preferences

Newsletters

Community
Log Out

Search

What are you looking for?
- Sections:
- Photos
- Videos
- All Writers
- Editions: US
- View full profile
  Log Out

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 · 12 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.

1 total post (Page 1 of 1)

+ Follow this Discussion ·

+ Follow this Discussion ·

Thread display: Collapse - | Expand +

All Answers

Collapse -

Try this one out...

by Peconet Tietokoneet-217038187993258194678069903632 · 12 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

1 total post (Page 1 of 1)

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 · 2 years ago
0

Working from home VPN / NAS

DanielCCM · about 13 hours ago
0

My second wireless router keeps disconnecting and has unstable connection

craverdope · about 3 days ago
0

DDNS not working with No-ip

Oren Dekel · about 4 days ago
5

Cat6 pin out and issues

mconnerus · about 4 days ago

Related Forums

Desktop · 25,097 discussions
Laptops · 2,658 discussions
Hardware · 19,021 discussions
Networks · 41,549 discussions
Storage · 2,050 discussions
Peripheral · 2,107 discussions

Budget planning tool

Employee objectives policy

IT hardware procurement policy

Hiring Kit: Autonomous Systems Engineer

Services

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

FAQ
Advertise
Reprint Policy
TR Premium Terms of Service
CA Privacy/Info We Collect
CA Do Not Sell My Info

Explore

Blogs
Downloads
TechRepublic Forums
Meet the Team
TechRepublic Academy

TechRepublic Premium
Resource Library
Photos
Videos

© 2020 CBS Interactive. All rights reserved. Privacy Policy | Cookies | Ad Choice | Terms of Use | Mobile User Agreement

A ZDNet site |

Visit other CBS Interactive sites: