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 NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

Needing help to pull data from an Excel report into a word

Customer Question

Needing help to pull data from an Excel report into a word document. Basically to create a pull ticket for PTA spirit wear order fulfillment. The spreadsheet contains columns of merchandise with the style & size in the header row. Only the quantity is in the cells. I only want the items with a quantity to show up in the document & if there's a quantity, include the header to indicate size.
Submitted: 2 months ago.
Category: Microsoft Office
Customer: replied 2 months ago.
I used Mail Merge Manager in Word to pull in the Excel cell headers that could contain quantities. Cells that are 0 are actually blank so only those with a # will pull through. What I need to see is if I can somehow add if there is a quantity, it also adds the heading title.
Expert:  Bhavik Joshi replied 2 months ago.

Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.

Expert:  Bhavik Joshi replied 2 months ago.

Could you please attache the your excel file and some sample output file.I will try to pull the way you want.

Customer: replied 2 months ago.
here's the spreadsheet I'm pulling the data from along with a sample of the report we did last year. I have the word doc set up to do this, but don't want to include the items that are not part of the order. We have 12 items, but most only purchased a couple of things. I only want their ordered product to show up on their packing ticket.
Customer: replied 2 months ago.
for some reason it won't let me attach the word doc saying it's too large so I've included a screen shot of how I have it set up. Right now, these would show each of the 12 item headings regardless if they ordered. Last time, I had to go into the spreadsheet to include the size in each cell that contained a qty. Surely there has to be a better way!