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
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
44910485
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: 15 days ago.
Category: Programming
Expert:  Richard replied 15 days 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 15 days ago.
Example.
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 15 days 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 15 days ago.

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

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

thanks

Customer: replied 15 days 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 15 days ago.
let me know if you got it. thanks
Expert:  Richard replied 15 days 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 15 days ago.
ouch. ok