How JustAnswer Works:

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

Ask Lindie-mod Your Own Question

Lindie-mod
Lindie-mod,
Category: Microsoft Office
Satisfied Customers: 5
Type Your Microsoft Office Question Here...
Lindie-mod is online now
A new question is answered every 9 seconds

I have an excel spreadsheet with production information for a nursery.

Customer Question

I have an excel spreadsheet with production information for a nursery. The main production sheet has many columns but there are some columns that show in which week certain tasks need to be done. I want to create a new sheet that will only show those rows that have a week number in a range that match my entered week value.
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  John D replied 2 years ago.

Hi,


I will be happy to help you with this. Do you have the file available that you could send (let me know if you need help uploading files on this site)

 

Customer: replied 2 years ago.
How do I upload?
Customer: replied 2 years ago.
Attached the file
Expert:  John D replied 2 years ago.

Ok go to http://www.wikisend.com/ and upload the file (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.

 

If the file has sensitive information let me know before you upload it

 

Customer: replied 2 years ago.
File ID: 370520
Customer: replied 2 years ago.
Relist: Answer came too late.
Expert:  John D replied 2 years ago.

I got the file, thanks

 

Ok which column should determine if the row will be included in the new sheet.

 

 

Customer: replied 2 years ago.
Columns B through J
Expert:  John D replied 2 years ago.

So that means if there is ANY value in columns B thru J then that whole row will be copied, correct?

 

 

 

Customer: replied 2 years ago.
Correct. There could be more than one column in a row with the same week number
Expert:  John D replied 2 years ago.

hmm. Looking at the current table all 20 rows will have to copied since there is no row that has ALL the cell in column B to J blank. Doesn't make sense.

 

I think you need to walk me through one example and tell what exactly needs to be copied

 

 

Customer: replied 2 years ago.
Are you looking at the Master_List worksheet?
If I enter 14 in the EVL_Action worksheet cell A2, row 2 of the Master_List should show up in the EVL_Action worksheet row 3. If there are more than one row with the number (eg 30) then all those should show up on the EVL_Action worksheet
Expert:  John D replied 2 years ago.

Where did you tell me all that before, or was I supposed to have guessed it? Why should it take 10 or so posts to get this crucial info.

 

.At this point you should consider accepting and I will continue with the work

 

 

 

 

Customer: replied 2 years ago.
I am not here to be chewed out by you. You have the file and I would assume that you can quickly drill down to what the issue is. You could have asked a mor pointed question earlier on. If this is your style of customer service I am not interested in working with you.
Customer: replied 2 years ago.
Relist: Other.
Very unhappy with the attitude of this Expert. I am not paying to be chewed out but to get an asnwer. Pls. refund my money or get me someone who knows what customer service is
Expert:  John D replied 2 years ago.

No problem. Good luck

 

Customer: replied 2 years ago.
When will the funds be refunded?
Customer: replied 2 years ago.
Relist: Other.
Not happy with Expert
Customer: replied 2 years ago.
Relist: Other.
Not happy with Expert
Expert:  Lindie-mod replied 2 years ago.
Hi, I’m a moderator for this topic and I wonder whether you’re still waiting for an answer. If you are, please let me know and I will do my best to find an Expert to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!
Customer: replied 2 years ago.
Yes, I am still waiting for an answer.
Expert:  Lindie-mod replied 2 years ago.
Sometimes, finding the right Expert can take a little longer than expected and we thank you greatly for your understanding. We’ll be in touch again shortly.
Customer: replied 2 years ago.
I used Simit in August and he was very professional and got to the point very quickly. If he is available please ask him to assist me. Thanks for your help
Customer: replied 2 years ago.
Should I p;ost the question again and word it differently to see if there is someone interested in earning some money. This thread seems to have died.
Expert:  Lindie-mod replied 2 years ago.
Hi

If you like, I can close it if you would like me to.

Thanks :)
Customer: replied 2 years ago.
Yes please close and make the funds available for a new post. Thanks

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 Customer New York
< Last | Next >
  • 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 Customer New 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!!!! Alex Los 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. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, 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. Esther Woodstock, 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. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional