Recent content by bino1121

So I wrote a quick code to copy and paste in mass Sub MassCopyAndPaste() With Range("A2:D10") .Copy Destination:=.Resize(.Rows.Count * 10) End With End Sub However the next part I am struggling to do after the mass copy and paste has run I need another code that will update column A...

So the goal here Is that I have a sheet ranging from A:J with headers on row 1. I am trying to evaluate columns F & G (variable ranges) They are date ranges but I would like this to apply for all values not just dates. The if conditions I am testing for include This should be accounted for...

seems like it is working good thank you so much! could you explain a couple things about it? How come last row is dim as double? and how did you come up with the Idea for r=2 or could you explain the r=2 part and how it works I have not used used the for loop yet and I could not figure out how...

Below is the code I am currently attempting to write. The background is I have a list of orders with other information A:J ( don't want to make a table if it can be avoided) I need the code to evaluate D2 & lr = 10 AND F2 & lr ="" (blank) then if that statement is true put "ON HOLD" into cell...

Sub Advanced_Filter() Dim Ws1 As Worksheet Dim Ws2 As Worksheet Dim dataSet As Long Dim setCriteria As Long Set Ws1 = Workbooks("Template Report.xlsx").Sheets(1) Set Ws2 = Workbooks("Template Report.xlsx").Sheets(2) dataSet = Ws1.Range("A" & Ws1.Rows.Count).End(xlUp).Row setCriteria =...

I need to convert this into VBA code.... The range I have set there isn't really 1048576 I just couldn't figure out how to set it as control+shift+down. and the cells that this applies to is from $A$4:$A$1048576

looking for a formula or conditional formatting so that if the text building1 shows up on sheet1 then the value on sheet2 that is building1 changes red conversely, if the text on sheet1 does not show up in the column A on sheet2 (building1 is not on sheet1 but is on sheet2) then the color...

This is awesome thank you so much! I did have one question though. So how I have it set up is that the report is on Sheet1 and then there is a list of buildings on Sheet2. This list of buildings changes through another macro depending on the day. For instance, On Sheet2 I would have to select...

Right so for this code to run it would be my understanding that I would have to input each search item individually? "Red*" Where as the code I am running is advanced filtering Sheet1 for a list of values on Sheet2. How would I add a wildcard search for a list and not a specific term I guess is...

Is it possible while using advanced filter in VBA code to add wildcards in the VBA code so that it only returns those exact values and not something that would contain the string of numbers and letters? while also still using the facilities list from above to be what the data set is filtered by...

Currently in the thinking stage right now but I am wondering if in excel VBA I have a report that comes in. This report then needs to be filtered by specific set of buildings. I just learned that you can add macros to the ribbon at the top of excel. INSTEAD of having a ton of buttons on the...

Never mind I solved the issue thanks

Trying to run a simple auto filter one for sheet1 and a different filter value on sheet 2. The range for the filter needs to be variable code I wrote is in the photo I don't know why it says this range is not valid. Even when I did Sheets(2).Select or Sheets(1).Select I could not get them to...

Current Issues with the code I'm attempting to run. Sorry for the quality.

I get an error: Invalid procedure call or argument debug highlights this line of the code. Selection.FormatConditions.Add Type:=xlExpression, Formula:= _ "ISERROR(MATCH(A2,Sheet1!$A:$A,0))"