(New User) Creating a report from Multiple sheets under workspace

(New User) Creating a report from Multiple sheets under workspace

Hi everyone, I am trying to create a report that can be sent via email on a weekly basis consisting of the information listed in the attached. I am thinking there must be a way i can get these sheets to be emailed in pdf to myself once its updated by the required person. Any suggestions?

Best Answer

Answers

  • Thanks Genevieve. I was able to create the report needed.

    I am wondering now how can i go about creating a master file of all of the product names summarized from the individual sheets. I am thinking another report; however I am getting the same name repeating multiple times, any suggestions?

  • Hi Sherrelle,

    I'm glad that helped! In regards to gathering all the product names, do you mean you want to pull all the names from all of your sheets, but if there's a duplicate only display one?

    As you've found, Reports will show you all of the rows across different sheets that meet your criteria, so if the same product is listed on multiple sheets it will bring each of these in as individual rows. There isn't currently a way to combine these through a Report.

    Will these product name columns be updated over time, or is this your static list of products? You could copy/paste these names into one large sheet then use a formula to check for duplicates and delete them (or Sort the sheet alphabetically and then delete duplicate names).

    Then if you were looking to combine data for each product (such as an overall QTY to be ordered), you could use a cross-sheet SUMIF formula to add together all of the quantities across your many sheets for that one specific product. Is that what you were looking to do?

Sign In or Register to comment.