Search results

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

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

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

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

I have 2 sheets one is a data set (Sheet1) and the other is a list of building names (Sheet2). The range of cells can vary in size for both sheets as these are reports that are generated and change from day to day. What I am trying to do is if a value from Sheet2 shows up in the dataset sheet1 I...

This is the code for an advanced filter I am running I am trying to find a way to make the Range("A1:A97") to be xlDown Instead I as the range values for both ranges listed in the code need to be a variable size not a defined range as the lists could be bigger or smaller then the amount listed...

I have a large data set that changes in size that I am trying to import into a template sheet in a different workbook. So the goal is to get the data set workbook to copy and paste from A1 down to a variable sized range (Could change from day to day) and when it imports into the template sheet...