Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office
This answer was rated:

I have multiple CSV (or Excel) files with data. E.g.

Jan.xls, Feb.xls, ... Dec.xls. They...
I have multiple CSV (or Excel) files with data. E.g. Jan.xls, Feb.xls, ... Dec.xls. They all have the same type of data and they all have the same column headings. How can I combine multiple excel files (e.g. 12 separate files for Jan - Dec) into one excel file for the year (e.g. 2016.xls).Windows 10, Excel 2016
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 13 minutes by:
10/10/2017
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 7,377
Experience: Computer Software Specialist for more than 10 years
Verified

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

You can do this by using the MOVE OR COPY command in your Excel. Here are the steps:

  1. Open a new file and then save it as 2016 or something descriptive you want. DO NOT close that Excel file
  2. Now open ALL of the files that you want to copy or move.
  3. Work on the Jan.xls file (means activate the Jan.xls window). Make sure that the NAME of the sheet is unique. For instance, you can rename it to Jan2016. When done, right click on the sheet name, then click on "Move or copy..."
  4. In the Move or Copy dialog box, under TO selection box, click and select the file you created in Step 1. It could be the file named 2016.xls. (This is the reason why you need to keep that file open so that you can see it in the TO selection box).
  5. Then make sure to click to check the option that says "Create a copy" if you want to COPY the sheet to the file in Step 1 to consolidate them. But if you forget to check that option the sheet will be MOVED there.
  6. Then click the OK button
  7. A copy of the sheet will be moved to the file you created in Step 1.
  8. Do these steps to all Excel files you want to copy to the main and consolidated file.
  9. When done moving/copying the needed sheets, SAVE the file.

I hope that helped.

Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!

If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.

Thank you!

Best regards,
Jess

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
Great! Is there a macro that I can use to do this with a bunch of account information?

Unfortunately, there is not. But if you can build such macro, that is entirely possible.

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 7,377
Experience: Computer Software Specialist for more than 10 years
Verified
Jess M. and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
Customer reply replied 4 months ago
Hmmm, I tried following the steps for making a copy - but I do not see the TO selection box.

Here is my screen shot:

http://filesxpress.com/d-8eafc988

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
thank you.
Was this answer helpful?
Ask Jess M. Your Own Question
Jess M.
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 7,377
7,377 Satisfied Customers
Experience: Computer Software Specialist for more than 10 years

Jess M. is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

7,377 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I purchased Office 365 Personal with the new PC I bought
I purchased Office 365 Personal with the new PC I bought from the retailer. I tried to download the app with the Key from the card using my Microsoft account. The website would't accept my password **… read more
Justin Johnson
Justin Johnson
Training and Development Contractor
1,560 satisfied customers
How do I find my Microsoft office 365 product key if I don't
How do I find my Microsoft office 365 product key if I don't have the package? … read more
Samuel Kresslein
Samuel Kresslein
Associate\u0027s Degree
289 satisfied customers
I have an excel question, is that something you can help
Hi I have an excel question, is that something you can help with? … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I got OFFICE 2016 installed on my MAC PRO 2017 (2TB), and
I got OFFICE 2016 installed on my MAC PRO 2017 (2TB), and having some questions about my outlook. … read more
Joshua Gransbury
Joshua Gransbury
A.A.S
3 satisfied customers
In a document that has modified and saved several times, why
in a document that has modified and saved several times, why do I see cursors with double ended arrowheads. Further the cursor seems to stick or not mover forthrightly … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Are you from microsoft or or a third party actor who's going
Are you from microsoft or or a third party actor who's going to charge me? … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I have Microsoft Office, including Microsoft Word. However,
I have Microsoft Office, including Microsoft Word. However, I just recieved an email with a Word document as an attachment. When I try to open it I get a message from Adobe Acrobat saying that the doc… read more
ChrisC
ChrisC
PC Technician
Associate Degree
660 satisfied customers
I need my virus protection renewed and since you are not
I need my virus protection renewed and since you are not using (kaversky?) anymore, I can't get my computer to give me the new antivirus you recommend. … read more
Martin
Martin
Network Engineering Diploma
143 satisfied customers
All apps - including Microsoft office - were lost last week,
All apps - including Microsoft office - were lost last week, apparently when Microsoft was attempting to update my computer without my attention. … read more
D.Sandlin
D.Sandlin
Support Technician
6,708 satisfied customers
I'm trying to open Microsoft word 2016 and it will not open.
Hi I'm trying to open Microsoft word 2016 and it will not open . I just signed up for Microsoft office after purchasing my new laptop. … read more
Cody
Cody
Computer Science
1,844 satisfied customers
I have two questions: how do I delete a file in word 10 from
I have two questions: how do I delete a file in word 10 from the computer … read more
Jason Jones
Jason Jones
AAS Information Technology
6,321 satisfied customers
I have upgraded to Windows 10 and can no longer get Windows
I have upgraded to Windows 10 and can no longer get Windows Media Player which I had previously. What's wrong.? … read more
Jess M.
Jess M.
Computer Support Specialist
7,377 satisfied customers
I am downloading microsoft office 365 personal. I have a
I am downloading microsoft office 365 personal. I have a lenovo T7 processor and its been 1.5 hurs and is not finished yet. cll me at … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I RECEIVED a notice that my mrcosoft account has problems
hello i RECEIVED a notice that my mrcosoft account has problems could you help me? … read more
Jess M.
Jess M.
Computer Support Specialist
7,377 satisfied customers
I have Microsoft Office Home & Business 2016 on Windows 7
I have Microsoft Office Home & Business 2016 on Windows 7 when I Start>computer and attempt open a file I get the message "this action is only available for products that are currently installed" … read more
Cody
Cody
Computer Science
1,844 satisfied customers
Word keeps freezing. I cannot do more than one function and
Word keeps freezing. I cannot do more than one function and it freezes. I just installed Office 2016 on my MacOS , 10.13.13. I have spent 4 hours trying to do small office task. I cannot do my work an… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Some of my Microsoft Word documents cannot be opened. I get
Some of my Microsoft Word documents cannot be opened. I get a message that reads: "The requested operation requires elevation." … read more
Kamil Anwar
Kamil Anwar
IT Consultant / Systems Engineer
Bachelor\u0027s Degree
444 satisfied customers
I'm unsure which icon to click to get word processing? I
I'm unsure which icon to click to get word processing? … read more
Cody
Cody
Computer Science
1,844 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x