Recent content by chriscorpion786

Brilliant & Super helpful. I went through each step line by line, debugging, understanding and learning at the same time from your file and your steps mentioned here. Thank you Frank!

Thanks Frank, it worked. Great! The Combined step is where you have used a custom function, could you explain that, bit difficult for me to decipher it. Is there no UI method through Power Query that we can do this ?

By the way, I have posted the same question in Mr.Excel forum as per the link below: https://www.mrexcel.com/board/threads/power-query-pivot-every-alternate-row.1274334/

Hi , In the custom column, I have store names and every alternate row contains the word T&F, I need to pivot the rows where T&F along with the "Yes/No" in the value column. The end result should read: Custom Value T&F Dubai Mall-DM1-1404 Yes No Much appreciated for a solution in Power...

Thank you, both recommendations work...

Thank you, your recommendation works..

Hello ALL, I have a macro that filters dates by month and year based on cell values. I have dates that range from the year 2020 till year 2030. Now the strange part is that all years filter properly except for any dates that lie within the year 2030 I have the below code and could'nt find a...

Hi, Your recommendation to remove the worksheetfunction works fine, I used application and now it dosen't throw an error. Many thanks, learnt a lesson here.:)

Hi, thanks for replying, I removed the worksheetfunction as Marc L explained and now when I download it and enable editing it works fine. Thank you,

Hi All, I made a macro file with a worksheet selection change events, whenever i send it to my colleagues over the internet by mail, when they open it, they have to enable editing, after enabling editing it throws this run time error '91' object variable or with block variable not set , once...

Hi Chandoo, Is it possible you could do some tutorials on mouse hover events on charts.... thanks, Mustafa

Hi there, I have an excel dashboard and a combo box that select the users name, below are some charts that update accordingly. I dont want the end user to mess around with the charts so i need to lock all the cells and charts in the dashboard. If i lock all the cells, and hover my mouse over...

Thanks so much.....Luke......that makes my life a little easier..... Mustafa

Hi Luke, It worked...thanks so much...if you dont mind can you explain this code: Range(Cells(i, "C"), .Offset(0, 1 + .Value)).Value = _ .Value * .Offset(0, 1).Value im a beginner, so i need to understand and practise this myself...... Thanks so much....why does VBA seem so difficult...