vba & conditions

Hi, following request I had done before with the FormulaLocal(sverweis). Now I want to learn more about if loops, but I cant get it done. So I ask you for help to show me how to do it. Request - Reference worksheet uploaded: check if value in blue marked column of worksheet "Bezugsdaten"...

I have two tables, one with multiple rows and columns of information from where I need to pull a random sample of rows according to a second table on a different sheet (the one below) I've managed to put together some code that allows me to pull a random sample and apply some filters to it...

Hi guys. I'm a noob working with VBA, so I need your help. So, I have an excel file, where I have a table with some data. In this table, I have a collumn named "expiration date" (column G), but not all rows have expiration dates, some of them are empty. I have setup a conditional formating...

Hi, I'm looking to find a way to highlight rows within this range (not entire row), based on the following two conditions: If any date in column A is a weekend, then highlight that particular row and/or If any cell value in Column B at min. contains the word "TEST" (doesn't have to match...

I am trying to figure out how I can see if one cell is equal to another one on a different sheet, perform an action once that IF statement has been determined, and then iterate down one row on both sheets to perform the same analysis on the cells in the row directly below. Essentially what I...

I am looking at having a VBA run with 2 conditions to autofill or pull data from another worksheet in the excel file. I have not finished adding all the locations, but i have added 2 different ones to test out on. Currently on my Shift Notes Tab, I have a formula in the cell ranges of C9:F12...

I recently built a sheet that will help me duplicate records by concatenating specific data, last four of the SSN and first 3 letters of the first name, which then duplicates this data into two transactions. It will work perfectly to group the transaction 3 and 4 together BUT only if I sort two...

Good Afternoon, I have a worksheet that is conditionally formatted to use 6 formulas. Every time a user pastes in the worksheet, they are messing up the formatting. I understand I can create a VBA to delete and reapply formatting. I found some formatting that rlv01 (Thank you!) had posted on a...

I have two issues. 1. I would like to be to run two If statemetns If Audit area Combobox is Blank return all values and run the if statement for the report range or If Audit Area combobox has a value return that value and run the if statement for the report range 2. Once that is done I...

Hello Everyone. I am new with VBA. I have been watching tons of videos to get some insight on how to do what I want but to no avail, I think there’s multiple solutions to get around this, but I lack the knowledge. I want to get my “Journal Entry workbook” (I’ll call this “Workbook1”) to...

Hi All, Just had to re-register after 8 years away. I receive a weekly timesheet spreadsheet for a construction project in an area with high rainfall. Each person can charge to 3 or 4 different time codes per day. One of the codes is "inclement weather/rain". When this code appears I need to...

I need a material record sheet which i created in Excel table, and summarize with Pivot Table (for Pivot Table refreshing after entry i use VBA Code), in Sheet i make a column which is "Approved" after approving i want that specific line will become locked (i use VBA code which work properly)...

I have few values in column I and column H, i have a code which highlights specific words in H column if those words are exactly present in I column. Drawback is it highlights the works only if they are exactly ditto and are present together, Can any changes be made in the code and make...

Hello VBA Guru's! I am fairly new to VBA. I have here a VBA code that compares attributes from sheet1 to sheet2. if attributes in sheet1 column A is found in sheet2 column A, copy the entire row in sheet1 and paste/replace that row in sheet2. Sub UpdateSheet2() Dim i As Long Dim f As...

Hello, I have this VBA formula that compares the attributes in sheet1 to sheet2. If attributes in sheet1 is found in sheet2, copy the entire row and paste in sheet2. Sub UpdateSheet2() On Error Resume Next Dim i As Long Dim f As Range, c As Range Sheets("Sheet1").Select last =...

I would like to know how to copy a variable cell value in a pivot table from one sheet to another. I would like to copy Sum X Est from label Buy and S. The code must work even if there is a row missing of data. I tried GetPivotData("labels", C1, "Buy", R2, "S", R3, "Sum X Est.", C2) but it...

0 1 I have a link to options in Think or Swim I have a form that I'm using to enter values into this sheet and for the textbox "tbossot" I'm using this code to copy to the worksheet: Cells(lrow + 1, "R").Formula = "='" & tbossot.Value & "'!" but when I paste this link into my form, it gets...

Hi Everyone, I am new to this forum and have been trying to learn some VBA coding to automate some data. My question is - I would like to insert a row when there is a value change in two-column cells in an excel For example, columns F and G where F has a string value of "Buy" and "Sell" and...

I need help with a VBA code and have absolutely no experience/knowledge with it. I have looked into it but ultimately come up confused where i am suppose to change data to match my workbook. I am trying to copy data based on one cell with multiple and changing factors into other sheets for a...

Hi, I have a File with no. of rows that change everyday, In file, I have data until column z, columnX is decision column which contains 4 values" Venice, Paris, Newyork and Italy" I need a macro to extract 27 rows to a new sheet named verification based on 2 scenarios 1, If Venice and Paris...