This updated version checks if the promo reference exist else it will prompt an error message. Hope this is what you are looking for.
Hi Cindy Give this a try. Just enter the promo code in the Dashboard sheet and click Go.
Hi Jian Guan Do the following 1) Select then range A2:D17 2) Select Conditional Formatting - Highlight Cells Rules - Greater Than 3) In th...
Hi Sarfraz See if this is what you want. Just double click on the Pivot Table to generate the report you requested.
Hi Sarfraz Can you post a sample of what your expected result will like when you double-click?
Hi Estella I have attached a sample for you to see. To view the conditions, select the range then click on Conditional Formatting-Manage Rules-E...
Hi Sarfraz There is no attachment.
Hi Mel I found 3 solutions for you. One uses the SUMIFS. The another used the INDEX+MATCH array formula and the last one is non-array INDEX+MATCH. ...
Hi Philippe The grey borders are the gridlines image from your source sheet. Just hide the gridlines in the source sheet and the grey borders will ...
No problem. Glad that helps.
Hi Jason I have no problem to copy and paste as value then with the value still selected, paste the format. It looks similar to your copy 3.
Hi give this a try Private Sub Workbook_Open() Worksheets("Sheet2").ListObjects("OrientationLog").AutoFilter.ShowAllData End Sub
If a PT Style have been applied , copy paste value with formatting doesn't seem to work (in Excel 2010).
Hi Mynda Your method will also copy the data.