Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I am trying to have a workbook that pulls data in from other…

Customer Question
I am trying to...

I am trying to have a workbook that pulls data in from other workbooks to automatically sort when new data is entered. I have 6 columns of information and I need column 5 to sort from largest to smallest when new data is entered.

Technician's Assistant: What kind of computer do you have?

HP - using excel

Technician's Assistant: Have you installed any updates recently?

Yes, installed Power Query

Submitted: 10 months ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 6 minutes by:
9/29/2017
Microsoft Office Technician: AnswersByEric, Computer Support Specialist replied 10 months ago
AnswersByEric
AnswersByEric, Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 5,206
Experience: Over 10 yrs of electronics support and software development.
Verified

Good afternoon! Would you mind uploading a copy of your workbook that you need the column sorted by large to small, that way I can look at it in Excel, fix what you want, and send it back, also telling you how I did it. There is an option here to send me a file.

Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask NewITZone Your Own Question
NewITZone
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
90 Satisfied Customers
Experience: I have been using Office Pro for 10 years and implemented applications for business use.

NewITZone 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

842 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

653 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
I have an excel document that has a data tab that is linked
I have an excel document that has a data tab that is linked to a sql table. I want a tab that if the user selects a scenario from the data tab it pulls in all the data associated with that scenario. … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I have office personal (cloud based it seems) and cannot get
I have office personal (cloud based it seems) and cannot get an excel spreadsheet with pivotTable reports that refresh when filters change or that use external data ranges (also called query tables) t… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
Excel Trying to pull together data from one sheet to another
Excel Trying to pull together data from one sheet to another sheet. source data is a report with rows for accounts and multiple columns for different departments. Need to pull data from source sheet o… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
the ability to list in one worksheet all the tabs in a workbook
the ability to list in one worksheet all the tabs in a workbook - then will provide the ability to reference any of the worksheets to create a table pulling information from the different worksheets… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
My file has 7 columns. Each "section" of data is 5-6 rows.
My file has 7 columns. Each "section" of data is 5-6 rows. I'd like column E to be in data order from A-Z. How can I do this if the data to order is 5-6 rows apart?… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Situation: We use an excel workbook that contains a table with
Situation: We use an excel workbook that contains a table with customer data on worksheet 1. In the following worksheets we have yearly calculations of our progress based off the customer data. Proble… read more
cvd4311
cvd4311
Computer Analyst
Bachelor\u0027s Degree
727 satisfied customers
I have a spreadsheet containing 193 rows of data. I have 30
I have a spreadsheet containing 193 rows of data. I have 30 columns with headers into which I entered data for those rows. I have paned the headers. Iwant to sort the data in column "B" smallest to la… read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
1) I need to create a query function in excel that would take
1) I need to create a query function in excel that would take a list of columns of data all of which have a product identifier called an ASIN and query separate spreadsheet database to grab UPC codes … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
OK I have a new question I need answered before I can apply
OK I have a new question I need answered before I can apply your Macro - I can attach my workbooks once I see the paperclip option - basically what I need is for one workbook sheet to pull data cells … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I have a spreadsheet that has some formatting and I am having
I have a spreadsheet that has some formatting and I am having difficulty with IF then statements and producing the actual number if it is true AND then copying that result to another worksheet… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I have a series of workbooks. There is a main workbook that
I have a series of workbooks. There is a main workbook that contains the base data (186 rows of names, addresses, etc.). I have a column with in that (the main) workbook that has a drop down menu that… read more
Brandon M.
Brandon M.
System Administrator
Vocational, Technical or Trade Scho
2,143 satisfied customers
Hi, I need a formula (not visual basic) to sort data in 2
Hi, I need a formula (not visual basic) to sort data in 2 columns with ties being possible. Precedence given to column 1 (alphabetic) then column 2 (largest to smallest)and then column 3 (largest to s… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
Help! Im in a .xlsx doc. My spreadsheet which has simple
Help! I'm in a .xlsx doc. My spreadsheet which has simple summation calculations in columns won't click and drag updated calculations. Instead it repeats the calculation from the previous column even … read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
Two related questions. I have about 10,000 lines of data in
Two related questions. I have about 10,000 lines of data in two excel spreadsheet, about 5,000 each. The data in each spreadsheet is 95% idential. I need to compare the two speadsheets and pull out th… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am working on a process to select the best fitting carton
I am working on a process to select the best fitting carton for our product line. I have a table all items item with the length, width, height and cube for each item in separate fields. I also have a … read more
Steve The IT Guy
Steve The IT Guy
Master\u0027s Degree
54 satisfied customers
Windows 7, Excel 2010. I have created an excel spreadsheet
Windows 7, Excel 2010. I have created an excel spreadsheet that provides a score for each individual, the team total score and the individual highest score. Page one displays the individual, highest s… read more
Ryan-CTech
Ryan-CTech
Manager
279 satisfied customers
Working with Excel 2010 and when I filter, my drop down is
Working with Excel 2010 and when I filter, my drop down is not recognizing all values within my column.… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
In same workbook, there are 6 worksheets. On Worksheet 1,
In same workbook, there are 6 worksheets. On Worksheet 1, Columns A through H have individual cell information entered or calculated (entered data or calculated data depends upon the Column Data Type)… read more
John D
John D
Bachelor Degree in Engineering
342 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