Search results for query: *

Workbook is sent over by the customer so that we can enter their orders into our system. When they send over the file with multiple orders/items, I need to be able to add a line number to each row. Line numbers are sequential based on the PO Number where a new PO number would restart the...

PrevWorkDay is a date. If the date is NOT a Friday, I would like to filter to show all dates besides PrevWorkDay (this works correctly in the Else statement). If PrevWorkDay IS a Friday, I would like to filter to show all dates besides PrevWorkDay, as well as that following Saturday, and that...

I have a command button inside of a macro-enabled template that when clicked, does some events, saves as a .csv file, then quits/closes. I am receiving a Type Mismatch error. I've removed all extraneous code, leaving only the portions that I see as being responsible for the error. the file saves...

Sub VLookup() Dim lastRow As Long lastRow = Range("A" & Rows.Count).End(xlUp).Row Dim Desc_Row As Long Dim Desc_Clm As Long Dim lastSourceColumn As Integer Dim lastSourceRow As Long Workbooks("Generate Vendor Doc for Item Submission.xlsm").Sheets("Sheet1").Activate '''Get last row and last...

Please see attached image. Top portion shows chart as I would like the colors to remain when the slicers are used. Bottom portion shows an example of what happens when slicers are used. 3 headings on left are the 3 sales persons, showing their top 5 customers each. I understand that when a...

Hello! I have a Clustered Bar PivotChart showing the top 50 sales items. Of course, 50 items at once is far too many to show on a chart. Yet, I am tasked with showing the top 50 sales items graphically. My thought would be to have a slicer to where I could select 1 - 10, 11 - 20, 21 - 30, 31 -...

Is there a way to Average a PivotTable column, but to exclude factoring in zeros from the raw data? Example: Raw Data Quantity Sales Cost Profit %Profit 1 $10 $4 $6 60% 3 $30 $12 $18 60% 2 $20 $8 $12 60% 0 $0 $0 $0...

Hello! I am utilizing a PivotTable for sales analysis. I have rows showing the item being sold and columns summing the sales from my raw data table. Within the raw data table, I also have a cost and price of each single item. While having the PivotTable show the summed totals, I would also like...