Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

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,823
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 8 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,823
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 8 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 8 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,823
7,823 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,823 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
Help! I just updated my mac and need to update Microsoft
help! I just updated my mac and need to update Microsoft Office 2011 and am having a hell of a time-- please update me to the most current … read more
John Castle
John Castle
BSC in Computing Network Management and Design
40 satisfied customers
Just purchased Office 365 and having some challenges finding
Second opinion] Good evening. Just purchased Office 365 and having some challenges finding the development tab as I'm attempting to develop a Word template. Your thoughts and advise? … read more
caraleneK
caraleneK
Service Manager
1,884 satisfied customers
On 6-8-18 I purchased Microsoft Office for $163.86. I loved
on 6-8-18 I purchased Microsoft Office for $163.86. I loved it. Then my laptop did an update and completely locked up my laptop and it had to be restarted and I lost my Microsoft Office. Can you downl… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
969 satisfied customers
I purchased a years subscription to 365 but did not get in
I purchased a years subscription to 365 but did not get dick in mail nor the key code to be able to get it to work. … read more
Byron
Byron
IT Support Specialist
Bachelor\u0027s Degree
410 satisfied customers
JustAsk tech BBao helped me last week changing the format of
JustAsk tech BBao helped me last week changing the format of my Microsoft 'word document so I could submit it as assignment to my TEL International Certification course. I have figured out how to drag… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
In a word document, misspellings have a red line under them.
Hello . In a word document, misspellings have a red line under them. How do I get suggested spellings and/or add to dictionary. When I click on red-lined words, nothing happens. This was a recently in… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,436 satisfied customers
Im having trouble in excel writing a formula. 14.2.0. There
There are different dependencies that warrant different equations.In plain english:If A1 is less than or equal to 10, and B1 is "Normal", multiply A1*3.5%. If A1 is less than or equal to 10, and B1 is "Active", multiply A1*5%. If A1 is less than or equal to 10, and B1 is "Athlete", multiply A1*6%. If A1 is GREATER than 10, and B1 is "Normal", multiply A1*2.5%. If A1 is GREATER than 10, and B1 is "Active", multiply A1*3.5%. If A1 is GREATER than 10, and B1 is "Athlete", multiply A1*4.5%.This is the formula I came up with that isn't working:=IF(AND(F2<=10,G2="Normal"),F2*.035,IF(AND(F2<=10,G2="Active"),F2*.05,IF(AND+F210,G2="Normal"),F2*.025,IF(AND(F2>10,G2="Active"),F2*.035,IF(AND(F2>10,G2="Athlete"),F2*.045)Thanks in advance. … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
588 satisfied customers
Microsoft account password. I answered the questions and got
I answered the questions and got emailed the number(###) ###-#### butnow the site doesn't respond. My email is***@******.*** … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,436 satisfied customers
Case 1429426331. Refers to being unable to open word starter
Case(###) ###-#### Refers to being unable to open word starter pack … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
969 satisfied customers
I have reset my microsoft password (windows 10) using my PC
I have reset my microsoft password (windows 10) using my PC and still cannot get into my new surface laptop. … read more
Eric Ewing
Eric Ewing
University IT Manager
181 satisfied customers
How can I find a document thqt just disappeared saying I
How can I find a document thqt just disappeared saying I needed an edtension … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I tried the password for Microsoft on my desktop but it
I tried the password ***** Microsoft on my desktop but it didn't work. Are they not the same? I have not used my laptop in a while and forgot what I set up on it. … read more
Wes
Wes
Consultant
Bachelor\u0027s Degree
372 satisfied customers
Outlook - email Task '[email protected] - Receiving'
Outlook - email Task '*****@******.*** - Receiving' reported error (0x800CCC92) : 'Your email server rejected your login. Verify your user name and password ***** this account in Account Settings. The… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I installed an upgrade of Excel. I can not open the program
My name is***** installed an upgrade of Excel. I can not open the program any more … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Microsoft Word quit unexpectedly. This message after an
Microsoft Word quit unexpectedly. This message after an update. … read more
John Lohr
John Lohr
Owner / Technology Specialist
Teaching Certification
679 satisfied customers
Windows 10? is not letting me reset my password. Dont know,
help upset never was i asked to change my old password ***** 20 years and this is not the computeri need change it my deck top… read more
John Castle
John Castle
BSC in Computing Network Management and Design
40 satisfied customers
IMy wife purchased Office 365 on Saturday, and we tried to
IMy wife purchased Office 365 on Saturday, and we tried to install it. There were problems, specifically, I could not open any MS programs. I worked with one of you folks for several hours trying to g… read more
Cody
Cody
Computer Science
2,357 satisfied customers
I did a lengthy Windows update, later got message that
I did a lengthy Windows update, later got message that windows could auto enhance images, by passed the message but the computer did a restart and now I have a giant image and huge letters , can't log… read more
Moses C
Moses C
Bsc
700 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