Search results for query: *

Skip, As always, you've given an excellent solution with a great explanation. Thank you, sir! It works like a charm!

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...

Thank you both!

Indeed! Thank you, Andy. I just passed right over that! As for the filter...now it is filtering to only show Sunday's date. Is my operator incorrect, perhaps? I've tried xlAnd and xlOr, both resulting in only showing Sunday's date. To reiterate, I need to show all dates besides Friday...

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...

No other procedures. My example above, I've removed everything that I could without affecting the problem. I did a couple more tests this morning and may have found the cause. It seems I was receiving this error upon pressing the command button while still having a cursor inside of a cell (the...

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...

Thanks, Skip. Here is the code you asked for... Sub ChangeTop10to50() ActiveSheet.PivotTables("PivotTable1").PivotFields("Item / Item Description"). _ ClearAllFilters ActiveSheet.PivotTables("PivotTable1").PivotFields("Item / Item Description"). _ PivotFilters.Add2...

That sounds interesting, Skip. I will certainly give that a go. Thank you!

Thanks for the reply, combo! I am aware that all of the labels are not showing and that they can be formatted to all fit. However, I would like to not have to show ALL 50 at one time, because every thing becomes quite condensed and hard to read. I would like to make this one chart on a...

Hi Skip! My apologies on referring to a "Clustered" Bar Chart. You are correct in that I am not even utilizing the "Clustered" feature of the chart. It is simply a Bar Chart. I would still like to use a Bar Chart if possible as I like how the data is represented with a vertical hierarchy as...

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 -...

It needs to be there as, within the report, I am comparing this year's sales against last. So elsewhere, in another column, there are sales for the prior year where there were zero for this year. I only need to show %Profit for this year. Above was just an example of a portion of the data - my...

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...

Thank you Skip! That's it! Such a simple solution. I fear I tried to complicate it far too much.

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...