vba & conditions

  1. P

    VBA: Formating specific text sections of a cell based on conditions.

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

    Running a "Last Seen Report" using the data in 1 Tab and viewing it in another Tab

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

    Conditional Formatting issues with VBA insert/delete row

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

    VBA code to return row values in a different format upon a met condition in the first column (A:A="TRUE")

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

    Ask if you want to replace file

    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, ...
  6. G

    How to stop sending username and password if mainserver not reachable

    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()...
  7. V

    SumIf across multiple sheets if a value is found

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

    Assign Numbers to Products - VBA HELP!

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

    Make data input from multiple workbooks in one master workbook

    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...
  10. kelly mort

    update data to match worksheets instead of deleting entire workbook

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

    Change all values in column E between two rows?

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

    Find in specific range inside array and Replace it via input Box

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

    Conditional Formatting? VBA?

    Hi Everyone, First time poster here, and man do I need some help. I am working on re-creating an "Activity Workbook" for my team to use at work. The original Workbook was created some years ago by someone who no longer works for my company, and it is in desperate need of updating. No one on...
  14. J

    VBA Code Loop Copy Paste Transpose

    Good day, I am newish to Visual Basic, apologies if this has been posted but i have searched through most of the forums and could not find this specific one. Basically what I need to do is a data sort from a file that information is not aligned properly. It comes with information in Cell A...
  15. T

    Allow user to input specific text and number-need VBA code

    hi anyone can help me on below, I want users to enter specific text (AB, DO, SL) and numbers (-10 to 20) in the cell range(A1:B10, A20: B30). Users should be able to enter only allowed data. if not cell should be clear. I don't want to use data validation impact I need VBA codes. please help...
  16. K

    Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???

    i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????
  17. K

    Make One Dropdownlist , Including all table Column Cell Details Show without Dependent Dropdownlist ?

    @ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...
  18. kelly mort

    Building a sentence generator with VBA

    Hello geniuses, I have this challenge here that is staring at me for a while now. I have tried to ignore it but it still pays me visit. I want to be able to use a VBA script to construct grammatically correct sentences. For the start, I will be constructing just simple sentences. S + V + O {...
  19. S

    VBA, Send email before expiry date of license and colour cell red

    Hey all, I hope I can get some help here. I have looked around for a solution and have gotten close but not there, it is a tricky one. This is the closest I have gotten: Send email based on date I have an excel spreadsheet stored on onedrive It has 4 sheets with employee details, 3 sheets...
  20. tourless

    if value x or y, delete until next value.

    Hi Folks, I'm working with some data that looks like this... CAP8503MKTG04EAOM1CAP8504MKTG01EAOW35-381PO: 0009692CAP8504MKTG03EAOW27-51PO: 0009168CAP8505MKTG01EAOP59-10PO: 000857759-125PO: 000969259-125PO: 0009693CAP8505MKTG04EAOP1 Column B holds the values of 01, 03, or 04. I need to check...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top