I need your support to re-arrange an excel sheet, listing all values in columns to be in new raws. As is: enter image description here To be: enter image descri
I've used various guides, documentations and tutorials to create a custom formula. Basically the formula takes two parameters ItemID and DateV. =DP(ItemID,DateV
I have a spreadsheet using two sort routines: Sub Sort_Date_From_To() Range("A3:Q10000").Sort Key1:=Range("C3"), Order1:=xlAscending, Key2:=Range("F3"),
I installed "Power Query" in Excel 2013. Works fine. However it doesn't support VBA. No code is generated when I try to make a macro with the macro recorder. Wh
I have following code Sub Example() Dim l1 As Integer Dim l2 As Integer Dim l3 As Integer For l3 = 1 To 2 For l1 = 1 To 2
I have received a request to fill in date based on specific status chosen (cell value) in a column representing that status. For example if I choose a Status "E
I have duplicates lines on each cell, these lines are merely URL address separated by vbLf. I need to remove duplicate lines, but only per each cell on the col
I have an ActiveX Textbox on an Excel worksheet. I need to move this textbox around and change its visibility using VBA frequently as you interact with the prog
I encounter a problem with Microsoft visual basic that variable values in Hebrew are converting to gibberish. Please see the attach picture The computer locale
I tried to find old posts related to this same issue but couldn't find a solution which would fit to my code. I'm trying to add checkboxes to Excel sheet every
I am trying to find out if there is a way to group rows in a table within a database based on the values from multiple columns. My specific problem is that I am
I'm wanting to automate a few things in Excel, problem is I am definitely not a programmer / scripter so this is all foreign to me. I have a list that changes i
I would like to change the response to a meeting, that I have accepted, to tentative and send text like "I'm sorry, but I cannot attend.". Online, I found solut
Dim path as String dim a as string dim b as string a = range("A4") // variable name in cell b = range("A106") // variable of other name in cell Workbooks.Open
I have a procedure called TableNumberSequence that adds a table row, pauses for a second and then adds another. It does this up until what's specified in the co
This is what I want to achieve with the code further down: If I use the RETURN key, the cell right next to the current cell should be selected, rather than the
I am trying to find a specific subject in a shared outlook calendar on a specific date. The subject, the date and the shared calendar is passed as arguments. Th
long time user of the forum but first time I'm actually asking something so please let me know if I'm doing something wrong. So I'm writing a Powerpoint Macro t
I have an ODBC connection to a database set up in Control Panel using a DSN. I can use this to see data from tables and Views in Excel. What I need to be able t
I stole the format from an answer to a similar question : Insert Image into Word by using VBA The problem I am getting is that it keeps not actually setting the