vba & conditions

Hi, I'm trying to create an excel spreadsheet (version 2019 and no ability to upgrade to 365) to keep track of appointments. There are sheets for each month. And I need the appointments for future dates to show up in their respective monthly tab automatically (without disappearing from the...

Hi, I'm trying to make a macro run on every sheet in my workbook, problem is macro doesn't work if cell value is 0: Sub Ola() Dim Rng As Range Dim InputRng As Range, OutRng As Range xTitleId = "KutoolsforExcel" Set InputRng = Application.Selection Set InputRng =...

Hi all, I am unable to change the cell reference by clicking the button (VBA ENABLED BUTTON). for instance: 1- Cell reference is "A2" and after clicking the button the cell reference will automatically "A3" and so on till the blank cell 2- Up and downside both buttons are available to work...

Hi all, I need an urgent help on a macro. I have very minimal experience with Macro and is struggling to get this done. I have a spreadsheet that has close 22K rows with a lot of data. The data is spread across various columns. The cell A1 is the unique id which repeats in various rows...

la idea es marcar cualquier celda de columna intermedia de los dos cuadros y enviar automaticamente a la celda h1 puede ser mediante un formulario o un mensaje que le diga que celdas desea marcar

What line should I add to extend the range to "g16: m25" please any help would be very useful Private Sub Worksheet_Change(ByVal Target As Range) Dim uF&, i&, nBusca%, Celda As Range If Not Intersect(Target, Columns(4)) Is Nothing Then...

Hi! First time posting here! I have been struggling with a very specific and probably weird issue that I am not sure of having a solution. The problem is related to text that is initially in word documents. Likewise, I have today asked for advice in a forum connected to Word VBA...

Hi Gurus, Hope all is well. Is it possible to rename a file based on it's equivalent cell value and criteria? Scenario: I have different multiple files in a folder and in different file format Sample filenames in a folder 0001 Datasheetxx.pdf Dataaaaaasheetxx_002T.xlsx...

Hello, first post here :) I have the following problem: -I have extensive lists of sentences in Excel, in which there are words ending and beginning with <strong></strong>. -Every day new words appear having these <strong></strong> remarks. -There is the need of creating a macro to automatize...

Hi there, I fear this may be a hugely technical request but have no doubt in the ability of the amazing people on here. Question: I have a spreadsheet that I use for monitoring assets, the assets are kept in one location but out of the pool of assets there are always some that are being used...

Hi, I’m hoping someone can help…I’ve read through quite a lot of threads and see that what I’m struggling with seems like a common thing…but I still can’t figure it out….I think my mind is zonked as I’m not a regular Excel user. Quick outline: I'm struggling to add/keep conditional formatting...

Hi, I built a list of daily prices in multiple currencies/countries with match and index functions across base prices, discounts and tax rates tables. However, I need to adapt it to another format that display prices in rows with a start and end time. I added a column to the daily price table...

Hello everyone, I have a code that serves its purpose well. Export a selection to pdf. However it replaces a file with the same name. I need it to ask if you want to replace or not If it is, don't loop until something is done. The code: Sub PDF() lr = Range("M:M").Find("*", , xlValues, ...

Created tool to auto putty login into jumpserver first , from Jumpserver it will login into mainserver . But some time mainserver is not reachable still script send username and password ......is their any way to stop sending username and password if mainserver not reachable .. Sub PUTTYSM()...

Hi All, I'm hoping someone can help me.... I have a few sheets that all look the same but there's a value in K2 on some of the sheets that I need to reference to sum up the values. For example: on my Summary sheet, C2 = 1) loop through all the sheets and find "Red" in K2 2) If Red is found in...

Hello, I'm trying to assign numbers to different Products using VBA. For example, if in "Products" column product "REG_AA" appears I want to assign it a number, if it doesn't appear I want to assign the next item in the list the number and go in series. If the product "REG_AA" didn't show up...

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...

Cross-posted at: https://www.excelforum.com/excel-programming-vba-macros/1355803-update-data-to-match-worksheets-instead-of-deleting-entire-workbook.html Reason: It has been up there for a few days now but no reply apart from my own replies. Link to work books...

Hello again, somehow i menage to deal wth my data entry problem, with some help from Indian youtubers. But i couldn t find any similar post. Is it possible to make a macro to change Status from "On Stock" to "Sent" in column E for all rows between two ID number, where are found given values...

Hi I am new to VBA, and I am still learning, I have this sheet that sometimes have a typo or spacing issue. So what I do is Find and replace multiple via array. However what I wanted to do is Set up a Find array and remove the array that will replace if it does not match, instead the user will...