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 ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

Somewhat complicated excel question. trying to format a

Customer Question

Somewhat complicated excel question.
JA: What programs and versions are you using?
Customer: trying to format a workbook for construction material ordering.
JA: What is your ideal outcome? How can we solve this for you?
Customer: Excel for mac 2011 version 14
JA: Anything else you want the programmer to know before I connect you?
Customer: I am looking for an entire line from one worksheet to populate onto another worksheet, within a workbook. But only if this line has a value associated with it Basically a summary sheet that only will only populate with lines that have values
Submitted: 10 months ago.
Category: Programming
Expert:  Richard replied 10 months ago.

Hi there and welcome

so basically the workbook needs to add values from one sheet to another if a certain value is present

Is this correct?

Customer: replied 10 months ago.
If I put a value of 1 anywhere on line 11 on sheet 3, this should bring the whole line over to a summary sheet.
If there is no value associated with a line on any sheet, this should not be brought over to the summary sheet
Customer: replied 10 months ago.
Not values, but the entire line, text and all.
It will be used as an order sheet for electrical materials. Only want materials that are needed for the job to populate the summary page
Expert:  Richard replied 10 months ago.

Can you attach the sheet so I can see it more clearly please

Customer: replied 10 months ago.
Its not complete. I will send over what we have. Thanks
Expert:  Richard replied 10 months ago.


Customer: replied 10 months ago.
Another example:I have 5 sheets of differing types of material. If I want to order 5 items for a project, I just want those 5 items to show up on a summary page.
Customer: replied 10 months ago.
let me know if you got it. thanks
Expert:  Richard replied 10 months ago.

ok, I have due to time constraints, I will have to opt out of this question

You do not need to do anything, you will be notified when another expert takes over

Thank you

Customer: replied 10 months ago.
ouch. ok