add

I am trying to have texts in a value field in a pivot table, and my understanding is that creating a Measure (concatenating the text) is the best way to do so. However, I am unable to create a measure when I am in the Pivot Table, as even after I select "Add Data to Data Model" when creating the...

Good evening, I have a table that sometimes i might need to add a row to. I need this row to insert at the bottom of the active cell and still hold the formatting and formulas from the row above it, without the contents of the cell. I did a record macro as i got fed up trying to figure it...

I have a button to add new lines to my table. The table has a date field in column A that is formatted to Australian date format. When I click the add new lines button, the new lines revert to US format for any dates that are entered in the new rows in column A. How can I force new, added rows...

Hi, I've never done anything before with progress bars. I have a macro which loops through a worksheet to last row and the data is used to update an external program. The problem is if there are a lot of rows (1000+) Then excel freezes up until finished. Is it possible to add a progress bar...

Hello, I have t below code and I need to add another range. For Each c In sh1.Range("AT5", sh1.Range("AT" & Rows.Count).End(xlUp)) - I want to add range ("AR5", sh1.Range("AR" & Rows.Count) Set f = sh2.Range("O:O").Find(c.Value, , xlValues, xlWhole) - I want to add range ("M:M").Find(c.Value...

I need to find the value of the last number in column A and add 1 to it. Can someone help me with the vba for this please? Thanks, Dave

I have created spreadsheet that creates quotes successfully but my supervisor has asked me to add some sort of a reference so the quote can be identified. There is a file client_list.xlsm that has the client name added too when the quote is finalised This code will be run from my quoting...

I have a dynamic range that expands when I add new data(naturally). I would like to add code to a button that I have that will adddata to the range when the button is pressed. This is the line of code I amworking with: Sheets("Competitor OverviewData").Range("CompetitorsLOV").Offset(1, 0).Value...

The data I'm tracking is in Column G through DC or DD. I have this array formula that I establish in Column C and it covers my data through Column DY (an overkill to cover my bases). Each month I add 8 or 9 columns to the right of column DC (golf play dates) and remove the same month from Column...

Hello all, My msgbox is not working. Would like to show a message, show the Information icon and add values from variables in 1 msgbox; If xEptTxtName <> "" Then MsgBox "The following required fields are not complete", vbInformation & vbNewLine & xEptTxtName & vbNewLine & xTxtName...

Hello, Please I need your help with my project. I have made a system for my business and need to add some forms using different tools and entry methods The form contains: Text Box Combo Box Option Buttons Check Box Commend Button Once I open the form to add a new Item... 1- TextBox1...

I have data validation set up allowing a range of cells to only accept whole numbers between 0 and 100. I currently have a bland error message that pops up if the user enters data that doesn't fit the criteria. However, I want to add a picture instead of some text. Is that possible at all...

I'm using this to loop through a series of Textboxes on a Userform and enter a decimal point after the first 2 numbers entered; Dim ctrl As MSForms.controlFor Each ctrl In Controls If ctrl.Name Like "TextSTime*" Then If Len(ctrl.Value) = 3 Then ctrl.Value = Left(ctrl.Value, 2) & "." &...

Hi, I would like to be able to assign a command button to add a new column to the end of my table. Each new column added should appear to the right of the last new column add. The command button will be on the activesheet but the table in which I am trying to add columns to will be on sheet...

Hi Mr. Excel'ers, So, here's my problem. I have a list of numbers in Col A.. from A2 on down, and growing. I continually add numbers to the bottom of the list, so it's a growing list. I'm at A345 now. next number I add will be A346. Say for example I add number 6 to A346. Then in A347 I...

Hi friends, is it possible to add formula after index match in vba , in normal index match its working but not with vba. vba code Sub lookup() lastrow = Cells(Rows.Count, "e").End(xlUp).Row For i = 2 To lastrow Range("e" & i) = Range("b" & Application.Match(Cells(i, 4)...

Hi, I currently use the following code to lock a sheet in a Workbook: mysheet = "Sheet1"If ActiveSheet.Name = mysheet Then ActiveSheet.Visible = False Response = InputBox("Enter password to view sheet") If Response = "Sheet1" Then Sheets(mysheet).Visible = True...

Hi, I am trying to write a small basic code for fuel allowance of 45p per mile. Currently i use this which works fine & correct. =E18*0.45 But i now wish to add the cell value at E34 So i have written, =E18+E34*0.45 The value comes back as £256 but it should be £134.65 222 x 0.45P =...

Morning all. I am hoping to find advice for a Shell( ) or other method to add sheets to a pdf file. I have tried several pdf generators / merging programs that support command line, but cannot get any of them to work. I have a standard sheet which is filled by VBA and saved to PDF then...