vba

Hello all, I think this topic has been discussed in many posts here and other forums. I'm sorry for the Clickbait (for some), however, I was unable to solve my problem.... I have a workbook to register my expenses, so I have a Sheet for every month of the year: so, first sheet is for January...

Good morning all, My column headings are in row 7. The below code works fine. However, the ActiveCell.Formula = "=G8" needs changing (the active cell is the Subtotal column). I need it to sum the values between two columns called "Calculated payment based on time and costs" and "Subtotal"...

I currently have the sub-Macro below which filters for Columns A and B (for Strings Asset and SN), and then copies the value. What I'm trying to figure out is how do I set it so that if no results are found for either, the macro would generate an error instead of crashing/copying just the title...

Hi all, I seek your help again. I have this VBA: Sheets("Data_analysis").Select Set pvFld = ActiveSheet.PivotTables("Data_analysis").PivotFields("Entered on") strFilter = ActiveWorkbook.Sheets("MAIN").Range("C3").Value pvFld.PivotFilters.Add2 xlCaptionEquals, , strFilter It worked...

The below code parses a single column address to dedicated columns for Address1, Address2, City, State, Zip. The code first tests the original column and places commas so that TextToColumns can do its work with commas as the delimeter. My problem is, Excel keeps returning the TextToColumns...

I have a code in excel sheet to save the currant page as pdf into pc folder based on cell value + current month text and it's working perfectly with just one problem - when I have an old file already saved in the folder and I need to save a new one with the same month name, the new file...

I wrote this code to refresh all my queries first and save the "Schedule" table as a .txt file. (Table: "Schedule" is coming from query) However, the problem with the code is that it does not refresh the queries; it just saves the table's existing/outdated data, which is not required. I want to...

I'm stuck with a part of long VBA code in my worksheet to pop up Msgbox in case if cell vlaue was edited - here is the probelm I have a worksheet that collect data from other sheet with formulas to show me the employee records and ID image when I only insert the employee ID number in Cell "E5...

Hello, I am currently working on a set of two classes: one being a custom object model, and the latter a custom Dictionary class, with my 1st class as key, and the items being arraylists. I am facing a problem for which i am completely aware and kinda anticipated. It is explained here in...

I have two sheets, "Operation" and "EHSQ", I want to be able to hide and unhide certain columns on these sheets, I am thinking of using a a shape and assign the macro where the user can press, like Q1, Q2, Q3 etc. So the user hits Q1, if the columns are unhidden, then the macro hides it and vice...

very very new to VBA but i have a spreadsheet that has entries by several people as a log. i have tried the below code but every time the sheet was opened, the dates update: Function Timestamp(Reference As Range) If Reference.Value <> "" Then Timestamp = Format(Now, "dd/mm/yyyy") Else...

Hi to all, Here I am again to bring my problems with vba. I have a workbook where I have a few sheets, that all have one table and one pivot table. To update the data on the pivot table, I have this code, that runs when I change the column "Valor s/ Iva" on the table: Private Sub...

Hello there, Looking for some guidance on how to code into my macro adding a Pivot Table that has a variable data set. I have the attached coding but does not work if the data set increases/decreases. TIA! Sub BuyerItemPivotTable() ' ' BuyerItemPivotTable Macro ' '...

Hello, Column J has a data validation list with the following 3 options: 1. Pending 2. Fit for work 3. Not fit for work I would like to add VBA which converts the row (from A to I) into values only (i.e converts any formulas into values) when "fit for work" or "not fit for work" is selected...

Hello everyone! I know excel well, but I don't know vba. I would be grateful for any help. Based on the table (М-55 МP) i need to use any tool to build a module that, when checking a product line with options, would automatically display its production date. Line to check -...

HI I hope you can help, I have been looking online and either I dont have the feature or i cannot do it. I have a table Column B to F and I want to hide the row if column F shows the word Completed. I have looked at conditional formatting but cannot find how to hide, not even sure where to...

I can't seem to get this VBA to go to E15 ! Otherwise, it is fine. Private Sub Worksheet_Calculate() If Range("E24").Value > "1" Then MsgBox "CLEAR" ActiveSheet.Range("E15").Select End If End Sub Thanks

For some unknown reason, whenever I paste a letter in cell e2 that is the same as the first letter in cell e9, it Autocompletes rather than just keeping the one letter "F". If I shut off Autocomplete it works fine. Similarly if I move "FLAME" to another column it also works fine. This happens...

Hi Good People, Currently I am working on a tool that would extract Reflection Workspace data to an excel file. The proble is, there are multiple pages or screen of a specific screen. Like for example. I managed to copy the first page of the screen, then you have to press page down key inorder...

I have this code that sends a range as a picture into an outlook email. I added checkboxes and want to be able to modify the code to send the contents in range B4:B17 and one or all of C,D, and E depending on if the checkbox is true. I have no idea how to do this, can anyone help me? Sub...