I need a Excel spreadsheet sorted
- or -
Post a project like this2003
$109
- Posted:
- Proposals: 18
- Remote
- #2178687
- PRE-FUNDED
- Awarded
MS Office Expert | Virtual Assistant | Internet Researcher | Basic IT Helping Hand
Dhaka
PPH TOP Website & App Developer✮LOGO & Graphic Designer✮Content Writer✮Translator
Dubai
14494732247736243332824329012428781241630524130862397619239288623327462274804
Description
Experience Level: Expert
This is what I need done its for a pull list. My orders for the day need to be sorted and added up below is what I need done. Attached is an example of the spreadsheet. It needs to be automatic like running a macro or something. like it goesand gets the excel file sorts it then prints it out.
1. All products with the same ProductID, Product Name, Product Notes and UPC grouped together on one-line item adding up the quantity of that line item
2. All Products with just the same ProductID, Product Name and UPC with NO notes in the product note field grouped together on one-line item adding up the quantity of that line item.
NOTE: Do not group line items with product notes with line items that have no product notes even if the productid, Product Name is the same.
3. Remove the OrderID column
4. After all sorting is complete make it printable fit to page either PDF or excel.
1. All products with the same ProductID, Product Name, Product Notes and UPC grouped together on one-line item adding up the quantity of that line item
2. All Products with just the same ProductID, Product Name and UPC with NO notes in the product note field grouped together on one-line item adding up the quantity of that line item.
NOTE: Do not group line items with product notes with line items that have no product notes even if the productid, Product Name is the same.
3. Remove the OrderID column
4. After all sorting is complete make it printable fit to page either PDF or excel.
Projects Completed
10
Freelancers worked with
10
Projects awarded
35%
Last project
12 Apr 2024
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies