excel & vba 2013

I have a PowerPoint presentation that is linked to an Excel sheet containing data that is refreshed monthly. I have written a macro that will refresh the data in the excel sheet, but I'm struggling to automate the updating of the links in the PowerPoint. When I open up the PowerPoint...

I am looking for some help with the following, I have two columns (BA and BD) where I set up (VBA code at the bottom, used with permission) a multi selection drop-down for each cell. The values available are (-,--,Ø,+,++) so that cell BA2 shows several of the symbols in a comma separated list...

I've looked everywhere and cannot work out the way to reference the sort key in my dynamic range. I believe it's relatively easy but my VBA still not up to it. I have a dynamic range that I want to sort using a column within the range. The range is A18:AR25, refers to...

I have these codes If Application.WorksheetFunction.VLookup(Cells(i, "AI").Value & Cells(i, "AH").Value, Sheets("WS rules").Range("D75:E284"), 2, 0) = "Y" Then If Cells(i, "O").Value = "2" Or Cells(i, "O").Value = "3" Or Cells(i, "O").Value = "4" Or Cells(i, "O").Value = "5" Or...

I have several Excel sessions open. Each open workbook has only one worksheet. I'd like to write a macro that copies the worksheets from all open Excel sessions and paste them into a new workbook as worksheets. Example: I have 4 excel sessions (excel workbooks) open. Each have one worksheet in...

GM Excel Crew, I am having trouble and I need some expert advice. I am recreating a PnL statement using a Pivot table. It gives me lots of flexibility for my needs for analysis. However, there is one problem that is driving me nuts. In this PnL there are lets say 50 accounts. Of course its...

The code from this forum is what I used as a starting point. I am trying to modify it to copy multiple sheets and paste them all as values, instead of just one sheet. I copied multiple sheets using worksheets(array(1,2,3)).copy I think the problem is With ActiveSheet.UsedRange because it is...

First, thanks a million to all who are here to share their expertise and to spend their time to solve the coding related problems of others. You have no clue how much you've helped me so far w/ my job. Problem: My macro doesn't do what I want. I have an excel file w/ multiple columns. What I...

Hello. This is a sample from the spreadsheet which have following columns: Date, Conditions, Day Part and Comments; Conditions have 3 values: Bad, So-So, OK Day Part have 4 values: Morning, Afternoon, Evening, Night I want to dynamically create radio buttons and check boxes which I should use...

Hi there, ") Is their a way to change an item ( for instance "Groupname") in the properties menu for let's say 9 option buttons at the same time ? Thanks a lot ! Regards, Andres

Hi, I want to perform below mentioned action in each of the two sheets but could not succeed. Can you please help. Cells(6, column1 + 1).Value = "Total1" Cells(6, column1 + 2).Value = "Total2" Cells(6, column1 + 3).Value = "Total3" Cells(6, column1 + 4).Value = "Total4" Cells(6, column1 +...

Hello, all. I hope someone can help me. It's probably quite a simple solution but I have literally no knowledge of VBA or the more advanced workings of Excel. I have a spreadsheet that lists customers and attempted phone calls made to them. When we make contact, a date is input in column "M"...

Hi I am using the following code to convert text to numbers. However, it is rather slow. Any idea how to speed it up? Cheers! (part of a longer code) With ThisWorkbook.Sheets("Lager").Activate Range("C3:C1000").Select On Error Resume Next For Each xCell In selection...

Hello, I'm trying to find a way to pull the value of an item in my VBA code to get stored each time a loop runs if certain conditions are met. I have established that ShiftTime = "" at the beginning of the loop and then a value is calculated at the end of the loop, before moving on to the next...

Hi there, I'm facing an issue and i don't even know if it's possible to fix. Context: I'm calculating allowances. The amount is per paid day, so I need to know how many days each employee has been in a country. While I know the total number of days. it's supposed to be a salary so I need...

Hi I am trying to replace a forumla with its results with the following code (in a table): Sub formtoval() With ThisWorkbook.ActiveSheet .Range(Range("D30"), Range("D30").End(xlDown)).Value = .Value End With End Sub However it gives me run-time error "438" Any idea? Eivind

Hi Friends, I have a huge list of Names which includes first, middle, last names and along with their titles, education etc., for example Tina DeRubeis van Zyl May Wen-Li Rebecca Hodson, CPA, MST David P. Kraus, Jr. Heather Findon, CPA James C. Lawson, JD, CPA, MST Bruce Feinstein, C.P.A...

Hello Everyone I have a user data entry form with the listbox , I would like someone please help me with the VBA code to edit data directly from list box without any buttons. please see my code below. Thanks in advance Private Sub UserForm_Initialize() txtDate.Value = Format(Date...

Hello! I'm really struggling with this issue using VBA in Excel. For starters, I'm no expert in Excel, but I'm trying my best with a really complex issue applying VLookup. I'll detail the issue with images below: I have a table that associates code letters to numbers in a separate sheet. I...

Hi guys, I am new to the forum and new to VBA. I am trying to write a code that would paste values of existing formula in one cell, then change an different formula in another cell and it repeat for n times. This is what I have so far: Sub Macro1() Macro1 Macro For i = 6 To 29...