Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Looking for someone very familiar with excel for help with…

Customer Question
Looking for someone very...

Looking for someone very familiar with excel for help with vlookup and simple macros

Technician's Assistant: What's the make and model of your computer? And what version of Excel are you using?

Macbook pro 2012 Excel 99-2004

Technician's Assistant: When did you purchase your Apple? What troubleshooting have you tried?

2012. I just don't want to learn how to make this spreadsheet work, I want it to work and move on to other business issues.

Technician's Assistant: Anything else you want the Microsoft Office Expert to know before I connect you?

No, I really need to show him the file to see if they can help or not.

Submitted: 11 months ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 5 minutes by:
9/19/2017
Microsoft Office Technician: Richard, Software Specialist replied 11 months ago
Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 47,537
Experience: Over 15 year experience resolving Microsoft Office Issues
Verified

Hi there and welcome

Attach the file to this question please and tell me what you need done.

Thank you

Ask Your Own Microsoft Office Question
Customer reply replied 11 months ago
Basically I am trying to pull information from the non-returning customer tab to different tabs based upon column A info. The 06 sheet will be for 5160 label mailmerge, the 06p is a list with just the phone numbers. Want to mechanize it so I can monthly drop the info into the non-returning customer tab, manipulate it to get rid of useless info, and then output different sheets of label addresses and phone list.1. on tab 06, E3 When those return a "O" due to no number, i need them to return a blank instead, so when I print it soesnt register.2. On tab o6 as well, on A2 i have now just did a conditional format to make it turn white, but when I print its still wanting to pring the number. Want that number to disappear as well without affecting the lookup3. On tab 06 as well, after line 102 it keeps the information there and when I go to print it just keeps printing even though it doesn't show up.Then I would like to make the output easier thru macros.
Microsoft Office Technician: Richard, Software Specialist replied 11 months ago

ok, what do you mean output easier through macros, please be detailed in everything you require from me here

Ask Your Own Microsoft Office Question
Customer reply replied 11 months ago
Did you get the file? Understand the basic concept and what Im trying to fix?
Microsoft Office Technician: Richard, Software Specialist replied 11 months ago

ok, it is a bit more work then I have time for at the moment, I will opt out for another expert to take over.

You do not need to do anything you will be contacted when they take over

Thanks

Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 11 months ago
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,216
Experience: 20 years experience providing remote computer support
Verified

give me a few minutes to take a look at your file and see if I understand your request.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 11 months ago

yea, i think you will need a macro to fix these issues. let me see if I can get a basic understanding of this.

You want to basically take columns B-J from the first sheet and copy them into new sheets, naming each sheet after the last 2 digits of the number in column A, and any time the last 2 digits in column A are the same it goes in that sheet?

Is that the basic concept.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 11 months ago

i'm sorry, I must have missed your response.

Was this something you were still interested in help with?

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 The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,216
2,216 Satisfied Customers
Experience: 20 years experience providing remote computer support

The-PC-Guy 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

2,216 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 want to be able to list all the people in Column A that
I want to be able to list all the people in Column A that have a Yes in Column C. So I'd like to see (John, Mary, Harry) … read more
Divyansh Pagaria
Divyansh Pagaria
Bachelor\u0027s Degree
4 satisfied customers
I am looking for a VERY SIMPLE spreadsheet that includes a
I am looking for a VERY SIMPLE spreadsheet that includes a milestone tracked, decision, risks, issues and assumptions that will generate a VERY SIMPLE status report. By way of example, the risk and is… read more
Steve
Steve
Consultant
Bachelor
69 satisfied customers
I am looking for a way to compare two excel spreadsheets and
Hi, I am looking for a way to compare two excel spreadsheets and get an output of cell matches and non matches. For example spreadsheet 1 has the last name of Jones on row 13 and spreadsheet 2 has a l… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,133 satisfied customers
Have a data like this: Col1 Col2 Col3 C1 R1 V1 C1 R2 V2 C1
Have a data like this: Col1 Col2 Col3 C1 R1 V1 C1 R2 V2 C1 R3 V3 C2 R1 V1 C3 R2 V2 C3 R3 V3 C4 R3 V3 C5 R2 V2 C6 R2 V2 Need to pivot this to something like this (with value cells filled in with format… read more
Bruce Wilner
Bruce Wilner
Master of Engineering
30 satisfied customers
Is there a way to send different portions of an excel
hello. is there a way to send different portions of an excel worksheet to different ms outlook recipients?… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
Accounting spreadsheet in EXCEL & Macro problem: My
Accounting spreadsheet in EXCEL & Macro problem:My payroll spreadsheets which I designed in 2005 for my own use have not been usable for the macro problem -- the original computer is gone and I didn't… read more
Bhavik Joshi
Bhavik Joshi
Computer Science and Engineering
941 satisfied customers
How can I improve my business with MS Office? Which apps in
How can I improve my business with MS Office? Which apps in particular will allow me to progress my sole proprietorship without hiring anyone else. In other words how can I be most efficient with data… read more
Joseph Varner
Joseph Varner
Bachelors of Science
51 satisfied customers
I was building a nice presentation after importing data .csv
i was building a nice presentation after importing data .csv into Excel. i saved often and a dialog box asked do you really want to save .csv and I said yes. after several hours of tables and pivot ch… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
I have developed files excel and powerpoint, I'm able
I have developed files for both excel and powerpoint, I'm able to use Macros to protect and put in expiration dates for the excel files, but haven't figured out how to set expiration date in Power Poi… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
I need to animate a sine curve using only Excel, and send us
I need to animate a sine curve using only Excel, and send us the workbook. So, when opening the workbook the curve needs to move.… read more
Christopher Love
Christopher Love
65 satisfied customers
Microsoft Excel. I have a monthly report that i recieve
Microsoft Excel. I have a monthly report that i recieve in the way of 20 separate excel files. i would like to know if there is a way to take data from these 20 files and merge it into one. maybe thru… read more
fbeltramini
fbeltramini
23 satisfied customers
This is a MS Access & Visual Basic question. I have
This is a MS Access & Visual Basic question. I have an MS Excel spreadsheet that I am currently using for data entry purposes for my job. I would like to migrate the functionality of this Excel spread… read more
Bryan
Bryan
735 satisfied customers
I need to write an Excel Macro to calculate interests on several
I need to write an Excel Macro to calculate interests on several principal amts. My interest period is different for each principal amt. In most cases, there are multiple interest rates within an int … read more
Richard
Richard
Software Specialist
47,537 satisfied customers
How to set searches within excel to default always to the top
How to set searches within excel to default always to the top of spreadsheet for multiple sheet searches… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I have created a rather complicated spreadsheet to which I
I have created a rather complicated spreadsheet to which I download my stock holdings data from my brokerage firm. Many cells in my spreadsheet are linked to other cells in other spreadsheets. Current… read more
Ryan-CTech
Ryan-CTech
Manager
279 satisfied customers
In Excel 2010, how do you copy formulas from one spreadsheet
In Excel 2010, how do you copy formulas from one spreadsheet to another without it creating a link in the pasted into spreadsheet?… read more
LeGin
LeGin
Unit Manager
Bachelor\u0027s Degree
13 satisfied customers
I need a macro for assigning a fee to client portfolios. There
I need a macro for assigning a fee to client portfolios. There are breakpoints at different levels. Fees are assigned as follows: Portfolio Size Fee $0 - $249,999.99 - 2% $250,000 - 499,999.99 - 1.75%… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
You did such a great job with the last question concerning
You did such a great job with the last question concerning volumetric error in elipsoid that I am coming back to you with another question. I hope this fits withing your expertise. I am evaluating som… read more
Chirag
Chirag
Master\u0027s Degree
55 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