sheet2.cellsi

Hi help me with my requirement, I have data in one excel sheet2 and I have created a button with macro, once i execute/run the macro it should copy and paste the data to sheet1 and i wanted to show this data from particular row(let's take A12). I am not sure that i am using right approach or...

Kindly need help. I want auto compute the start date and end date in my data. But when it generate it will include the sunday and holidays. Sub Scheduling()Dim LastRow, LastCol, IMAN, IMAN_last, MINqty, day As Long Dim qty_D, qty_W, qty_PO, NumDays, Capa_W As Long Dim x As Long Dim...

I need your kind help in the following code for preparing a treatment history reports of patients that how can I short and smart it? or any more suggestions form you in this matter. Private Sub ComboBox1_Enter() '**** It takes the names of all patients from Sheet2 where from '****we can...

Hi. I have this code for populating a listview box that works almost perfectly... What I want here, is to the listview box returns the data filtered by the content of the TextBox1 Private Sub UserForm_Initialize() Dim Item As ListItem Dim LinhaFinal As Integer Dim i As Integer...