conditional copy range

Hi all, I am new to VBA and I tried to write a macro to append data from Book 1 (active workbook where will have the macro) which is updated daily, to Book 2 ( close Archiving excel) which is only used for queries. Book 1 and Book 2 have the same column headers in row 1, with dates in column A...

Hi, I am trying to create a work book containing names of people with the color coded dates if that certain item is near expiry or is already expired. I have done that conditional formatting, however the data is too many for me to narrow down as to what has expired. Question: I created a new...

Hello, I have a table of data where i want to select data that meet a certain criteria and copy and paste that to a table in another range. I.e. I have a table with 6 columns. The first column is date and that is what i am using as a condition. If the date for a given row is in the past week...

Hello, First let me thank you for your time assisting me with this. I have extensively researched the forums and tried to implement/modify various suggestions but to no avail. I am trying to create a macro that will copy and paste a range of cells based on the condition of another cell. I know...

I am coding a Userform. I want combo boxes that are tied to excel data from the workbook. I have that taken care of this easily. I have coded the combo boxes to be conditional based on the previous selections in the other combo boxes. It is quite a bit of code. I cannot imagine Excel's code...

Hi Guys, I hope I can get some help from someone. Situation: I have a dropdown list (containing 109 diffirent values) in cell A1 of sheet named "working" and in another sheets named DataSheet the drop values are present in Column A. Desire: If I select a value from the dropdown box...