Microsoft Office

Microsoft Office Questions? Ask a IT Expert for Support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Microsoft Office

I have two excel files. I want to take some data columns from

Customer Question
Excel file #1 and import...
I have two excel files. I want to take some data columns from Excel file #1 and import (populate) them into certain columns on Excel File #2. Is there a way to easily have this done automatically?
Submitted: 5 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 58 minutes by:
1/5/2013
Microsoft Office Technician: Ryan-CTech, Computer Enthusiast replied 5 years ago
Ryan-CTech
Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 541
Experience: Expert VBA Programmer.
Verified
This can be done with a Macro from inside the first Workbook. If you give me the data range from File 1 and where you want it in File 2 I will gladly write you the code :). It would also be a big help you could upload the files to me.

www.wikisend.com

After upload copy the File ID Number or Download link and paste it here.

Thanks
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
I will send you in the am when i get back into the office. Thsnks appreciate it.
Microsoft Office Technician: Ryan-CTech, Computer Enthusiast replied 5 years ago
No problem. :)
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
File number one is 308726

File number two is 297096

Quick explanation of what I'm trying to do. The first file is products I have listed on our website. I would like to upload these products to Amazon.com - ads (which is file number two template in text). Instead of typing each item into file number two, I want a quick and easy way to copy most of the items from the product export file (#1) into the product ad file (#2). I realize I may need to tweek, etc. But just a quicker way than what I'm currently doing.

Thanks in advance.
Microsoft Office Technician: Ryan-CTech, Computer Enthusiast replied 5 years ago
Thanks,

I will have a look and get back to you very soon.
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Thanks - sure do appreciate it!!!
Microsoft Office Technician: Ryan-CTech, Computer Enthusiast replied 5 years ago
So you want to export Excel data to a text file? If so, do you want the entire row added?
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
The data can go excel to excel, and I can convert file number 2 to txt later in the process.

As far as the question regarding the entire row - No that's the tricky part - I need only certain columns from File 1 to go into "matching columns" of file two. IE. Column from file 1 labeled "id" goes into Column in file 2 named "SKU". Column in file 1 "name" goes into column labeled Title in file 2.

I can copy and paste if need be, but thought there was a way to link the two files and take data from one file into the other (excel to excel again). Took a class too many moons ago to remember exactly.
Microsoft Office Technician: Ryan-CTech, Computer Enthusiast replied 5 years ago
Ok,

Can you send me File 2? You sent me a text file. If you could also fill out the data in file 2 with where its coming from in File 1 that will make it a whole lot easier. Just do it for 1 row of data so I can fully understand :)

Thanks

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
OK will do. I'll send over the Excel for File 2 and I'll indicate where the data is coming from in File Number 1.
Microsoft Office Technician: Ryan-CTech, Computer Enthusiast replied 5 years ago
Sounds good. Thanks :)
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
New upload for file 2 Excel is 156838. On row 19 I indicated where in file 1 the data is coming from. Please go all the way to BK and beyond - a few stragglers out there.

Manual indicates I will need to manually put in the data.

Let me know if you need anything else.
Microsoft Office Technician: Ryan-CTech, Computer Enthusiast replied 5 years ago
Ok, I had a look and I dont think I can help with this one. I will Opt out for another Expert. He or She will be along very soon :). Please dont Rate until you get an Answer. Take care.
Ask Your Own Microsoft Office Question
Microsoft Office Technician: Rachel-Mod, Moderator replied 5 years ago
Rachel-Mod
Rachel-Mod, Moderator
Category: Microsoft Office
Satisfied Customers: 5
Experience: Moderator
Verified
Hello,
I’m a moderator for this topic. It seems the Professional has left this conversation. This happens occasionally, and it's usually because the Professional thinks that someone else might be a better match for your question. I've been working hard to find a new Professional to assist you with your question but sometimes finding the right Professional can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
I can probably wait a day or two - over the weekend (Sunday/Monday). On Tuesday, I'll try to do research on my own.

Thanks!!
Microsoft Office Technician: Rachel-Mod, Moderator replied 5 years ago
Thank you for your patience. We will continue the search for a Professional for you.
Rachel
Ask Your Own Microsoft Office Question
Microsoft Office Technician: John D, Bachelor's Degree replied 5 years ago
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified
Hi,

My name isXXXXX and I will be happy to help you with this question

I see that you have placed some column headings in row 19 but File 1 does not have these same headings so it is not clear which data needs to be brought and placed under these headings.

Would it possible to provide the info in the following manner:so I can understand exactly what needs to be copied and where it should be placed

Copy data from column A in 'export' file to column G in the 'ad1' file
Copy data from column B in 'export' file to column J in the 'ad1' file
etc

Once I have this info I will write a macro for transferring the data

Thanks


Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
John I will send tomorrow when I get back to my computer. Thanks!!
Microsoft Office Technician: John D, Bachelor's Degree replied 5 years ago

Sure. Will start on it as soon as I get the clarification

 

UPDATE:

 

Any progress on this!

 

 

Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
Copy data from column C in 'export' file to column B in the 'ad1' file
Copy data from column B in 'export' file to column D in the 'ad1' file
Copy data from column I in 'export' file to column E in the 'ad1' file
Copy data from column F in 'export' file to column F in the 'ad1' file

Copy data from column Y in 'export' file to column I in the 'ad1' file
Copy data from column U in 'export' file to column J in the 'ad1' file

Copy data from column F in 'export' file to column K in the 'ad1' file
Copy data from column B in 'export' file to column L in the 'ad1' file

Copy data from column W in 'export' file to column AJ in the 'ad1' file
Copy data from column Q in 'export' file to column BK in the 'ad1' file
Microsoft Office Technician: John D, Bachelor's Degree replied 5 years ago
Thanks

I followed the exact instructions but I noticed that there are some duplicate lines in the above statements (columns B and column F on the Export). Let me know if you need correct these duplicates

Here you go

Attachment: 2013-01-07_192849_2_files.zip



When you extract the files make sure you save them both in the same folder, then open the Export file only, and click the Go! button to run the macro

Also make sure you have your macros enabled so the macro can run

Hope this helps.

If you have any further questions do not hesitate to ask.

Thank you for remembering to rate the answer if you found it helpful
Ask Your Own Microsoft Office Question
Customer reply replied 5 years ago
I will extract tomorrow and yep there is a duplucate but its intentional. Thanks
Microsoft Office Technician: John D, Bachelor's Degree replied 5 years ago

If it is going to take you much longer please do not forget to rate so I get credit for my time. You can get back to later if you still have any question

 

 

 

 

 

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified
John D and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
Ask John D Your Own Question
John D
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9,666
9,666 Satisfied Customers
Experience: Bachelor of Science - Engineering Consultant

John D 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

701 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 can't recover a really important document that I was
I can't recover a really important document that I was working on … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I'm having trouble with creating an automatic table of
I'm having trouble with creating an automatic table of contents in Word. I think it has something to do with formatting in the document. … read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
There was an update today and since I did it I can't open
There was an update today and since I did it I can't open Word. There was one for PowerPoint and Excel and they are all fine … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
When I type an e mail to a particular person, how do I
When I type an e mail to a particular person, how do I include multiple names recipients . … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
701 satisfied customers
I have a document on one drive that wont open because the
I have a document on one drive that wont open because the file is corrupted. How can I open the document. It represents a weeks work. Would it help to use a different computer? … read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
I have two cars a Hummer & Maserati I was able to access the
I have two cars a Hummer & Maserati I was able to access the Hummer, now I would like to use it on the Marz how do I do it? … read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
I just downloaded outlook 2016 but cannot open it. I get the
I just downloaded outlook 2016 but cannot open it. I get the following message: "Cannot start Microsoft Outlook. Cannot open the outlook window. The set of folders cannot be opened. The outlook data f… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
953 satisfied customers
My spreadsheet appears to be locked. It won' T let me input
My spreadsheet appears to be locked. It won' JA: What application are you using? Customer: t let me input numbers or alph JA: Have you installed any updates recently? Customer: Excel, no JA: Anything … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
We have Microsoft Word on our old computer under Wayne and
We have Microsoft Word on our old computer under Wayne and Beth Raasch Product ID 03***-***-****774-02692. When we tried to load it onto our new computer it asks for a 25 number long ID. This is all w… read more
Kris R
Kris R
IT Manager
Computing
2,629 satisfied customers
My email account has suddenly started asking me for a
My email account has suddenly started asking me for a password ***** when I key in what I know to be the correct passwords … read more
Moses C
Moses C
Bsc
332 satisfied customers
I have a word file of 542 mb. Word won't open it reason it's
Hello there. I have a word file of 542 mb. Word won't open it reason it's larger than 32 mb in size. (However it will open a 330.4 mb file, both of which contain images and text). … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
701 satisfied customers
I bought Word in 2013 for a lifetime, and a few weeks ago it
I bought Word in 2013 for a lifetime, and a few weeks ago it quit working. It won't open. … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
701 satisfied customers
New HP PC. Tried to share a file (failed). Unable to close
New HP PC. Tried to share a file (failed). Unable to close Word. Was using Yahoo mail. Just set up Outlook. Still unable to close Word. Get error about new message. Not sure what to do. … read more
Cris
Cris
58 satisfied customers
I just updated my Office package today, & now I'm missing
I just updated my Office package today, & now I'm missing the Frutiger font I purchased. It shows up in FontBook but not in the MS Word list. Most of my documents have a substituted font. How do I get… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
CAN YOU HELP ME RETRIEVE MY PRODUCT CODE I JUST PURCHASE FOR
CAN YOU HELP ME RETRIEVE MY PRODUCT CODE I JUST PURCHASE FOR MY MICROSOFT OFFICE … read more
Moses C
Moses C
Bsc
332 satisfied customers
Is there a way to recover a document accidentally deleted
Is there a way to recover a document accidentally deleted from recycle bin? … read more
Chris L.
Chris L.
Support Specialist
Vocational, Technical or Trade Scho
147 satisfied customers
I recently re-subscribed to Office 365 as support for One
I recently re-subscribed to Office 365 as support for One Drive on my iPad so that I can use either the iPad or my Mac Book Pro for work. My problem is I can't find all the editing tools I need to typ… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I installed windows 10 update assistant and now I cannot
I installed windows 10 update assistant and now I cannot open Norton or office programs. click-2-run virtualisation handler keeps popping up. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,275 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