vba & conditions

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

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

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

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

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

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

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

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

The code below here was written for me by @Fluff some time ago. It's a very wonderful code and I love it. I have added 2 more comboboxes to use as the criteria for doing my filtering but I am stacked with how to get it tweaked. The new comboboxes are: ComboBox3, which will check column Y and...

Hello good people, I am working on a database where people join and have an ID card. ID cards are expired. I want to write VBA codes to highlights an entire row based on different cell values and then copy and paste those values to different sheets according to highlighted rows. A snap is...

Hello Everyone! I ran into an issue with macros and I could use some guidance! I attach a sample excel file for ease of reference. I need to write a VBA code which needs to: 1) Check if a condition is met ("Other" or "Building") -> Column D If "Other", then multiply OMV (Column C) x 0.30% If...

I need to add a vba code for ceiling along with vlookup worksheet function. Can anyone please help? This is my code line: Worksheets("sheets").Cells(i, 24).Value = Worksheets("sheets").Cells(i, 21).Value / Application.WorksheetFunction.VLookup(Worksheets("sheets").Cells(i, 18).Value...

Original Sheet: ABCDEFGHIJKL12UUIDWhatsover1Whatsover2Whatsover3Whatsover4Whatsover5Whatsover6Whatsover7Whatsover8Whatsover9Adjust and filterWhatsover103140542WhatsoverWhatsoverWhatsoverWhatsoverWhatsover5/20/2021 10:00:00 AM5/20/2021 7:00:00...