Search results

Hi, Sub TransposeRange() 'Updateby20140312 Dim rng As Range Dim InputRng As Range, OutRng As Range xTitleId = "KutoolsforExcel" Set InputRng = Application.Selection.Range("A1") Set InputRng = Application.InputBox("Range(single cell) :", xTitleId, InputRng.Address, Type:=8) Set OutRng =...

Hi Again, I have tried adding another item but that is not reflected in the output...

Hi, So I would need to copy this M code at the end of my current M code? Assuming I already have s file with a Power Query code on it? I would also need to tweak it so it will fit my needs! TY

Thank you all, I will see what's easier for me to use. BTW- Is it possible to use a UDF in a personal macro workbook?

Hi, I in the attached file I have a column of stores id and a column of related items belonging to each store. I would like to create a loop which will go through each cell in the id column and will concatenate to items if both items belong the same store. Thank you!

Hi, How can this code be changed so that only the row of the active cell will be selected? Thank you, >> Use Code -tags << Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim LocalSelect As String With Target If .Count = 1 Then LocalSelect = .Address & "," & .row & ":" & .row &...

Becuse I didn't quite understand it, only after my second posting. SORRY

*If so

So the first code is enough to enable/disable events? If, so ignore my previous message. TY

Thanks but how does it enable the user to turn events on/off? What about vbyes and vnno within a message box?

Hi, I would like to create a macro that toggles events on and off. Thank you for your help in advance.

So basically in order to compete this task I would to tun 3 sub routines? TY!

And another tweak please, what if I want the sheed to sent in PDF format?

Hi, Further to this post, will it work on a group of selected worksheets and not just the active one? TY

Hi, If I want to create a measure to show only sales of the latest day available in my data set. Can I use something like this, CALCULATE([TOTAL SALES], MAX(DATES(DATE)])? TY, Shay

Thank you, I have another question on Power Query connections, but I will post post it separately from this thread.

Hi, I have an Excel workbook which contains about 12 worksheets and 12 Pivot Tables respectively. The database for those pivot tables is externally connected (with Power Query). Now, the file size is about 3MB, is there any way to reduce it? I read online that binary files can't be read by Power...

Or an If statement

I mean values of course, sorry. Ok I will try to recrord it. Not sure I would need a variable though.

Hi, If I would like a to create a code to create a code to replace one measure with another and vice versa, will a simple recording do the trick? I want this code for a specific pivot on my workbook and not to the other pivot tables. TY, Shay

But shouldn't I get exactly 100 rows? Otherwise what is the definition for left outer join? It keeps all records from left table

Hi, Let's say I have 100 rows in my left table and 5 rows in my right table. Under which circumstances I will get more than 100 rows after the merge? TY

I have only one table that I added to the Data Modal, and yes, it has a date column. Thanks

Hi, I am trying to build a DAX expression to help me check, for each of the following months- 10/2017 through 09/2018 if there was sales ofat least one USD in the previos 12 months. For example, for 10/2017, the expression checks month 10/2016 till 09/2017. Also, the the formula shold check if...

What do you think about this workaround?