vba

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...

I have the following code that works most of the times, sometimes if gives me this error when using it consecutively too quickly: Run-time error 1004 CopyPucture method of range class failed. But I guess I can live with that :( What I need is to be able to add add text before the picture in the...

I have a spreadsheet with multiple tabs. In the tab titled "Cal/PM", The user will make an entry in Column A, and is supposed trigger the code below: Dim Asset As String Dim spec As String Dim cal As String Dim pm As String Private Sub Worksheet_Change(ByVal Target As Range) ' Check if the...

I have 02 issues with autocpmplete.... first - I have a worksheet with multiple pages (alomst 30 pages) and autocomplete only work in the current page but when I scroll down to insert data in a new page it doesn't work second - another worksheet with a table and I have 4 coulmn where i insert...

' Spot = Spot Price of the underlying ' K = Strike Price ' T = Option Maturity in Years ' rf = Interest Rate in decimal (i.e, for 5%, use 0.05) ' vol = Yearly volatility of the underlying in decimal ' n = Number of time steps ' OpType = 'C' for Call and 'P' for Put ' ExType = 'A' for...

Hello! I have prepared a document in which about 50 volunteers must indicate their availability on certain dates each month. The columns in which they indicate yes or no should always open for editing, for anyone. In contrast, columns A through L contain information they should never be able...

Hi, I need VBA code to get the list of top 10 recently modified files on the excel ribbon as macros in excel ribbon. The list of these files must be obtained from the Sharepoint link.

Hello All. I created a macro wherein the data captured from SAP and imported via power query will automatically pasted on another sheet of the same worksheet, what happened is that even though the query is updated once I ran the macro it captured the previous data generated from power query...

i am a beginner at vba, and am building a code to automatically clear text in column J when text in either column H or I is removed. i have this code already, but text in column J is cleared only when text in column I is removed. when i tried removing text in column H, text in column J doesn't...

Upfront Admission: My VBA skills are limited to one lines of code and plagiarism. So I will be zero percent offended if spoken to like a Excel baby. That said. I am working on a Power Query file that is reading a folder location of PDF files. From those files, I scrape out permanent information...