Forum

Hi Riste, You can't sync these slicers because the pivot tables they are attached to have different data sources and therefore different pivot cach...

Hi Graham, You don't need VBA to do this, just use a lookup function like VLOOKUP or XLOOKUP. See attached. Regards Phil

Hi Michael, What is an ATI? It appears that this calculation is using one. In 4.B.1/2 - it's not clear which applies here but it appears you are ...

Hi Carlos, Please post your workbook so we don't have to recreate it. Regards Phil

Hi, Happy to help when we see your file. Did you check this which explains how to attach a file? regards Phil

You're welcome.

Hi Bandi, To populate a ComboBox use the RowSource property. First create a named range for the cells containing the data to go into the list, the...

Hi Lea, I'm confused. You ask that names be split so that first name and last name are on separate rows. But the example you provide in Invert-col...

You're welcome.

Hi Kenneth, A quick search indicates this could be fixed by declaring a sheet object and manipulating that: Sub SetSheet() Dim cp As Workshee...

Hi Chris, Why can't you change the source data into tables? If Excel functions and other tools are designed to work with this data structure, su...

Hi Hussain, If you only want to keep 13 rows why not copy/paste these somewhere safe, delete the entire 2nd list, then cut/paste the 13 rows back a...

Hi Vedant, The W2 you've supplied is completely empty so I don't understand the need for it? Why not just copy the W1 file and rename it W3? Or...