Recent content by MI man

Hi noboffinme, I am looking something like what I have attached here. I think a code with For loop and Group property would do. I will try for it.

Hello, I am working on a data of 7 columns, of which the column B (Manager) is the one that I am using as the main criterion to group data. The problem is, there are n number of managers. I can group them by using subtotal, but I would get an extra column giving me the subtotals, which is not...

Sorry Brian, I put the else parts in comments, forgot to delete them while pasting here.

Hi Isskint, Thanks for looking into the issue. I have written this piece of code just now and it seems like it is working good for me as of yet. Written in code module: Sheets("Drill").Activate Range("B1734").Select lastcell = Range("B1734").End(xlDown).Row...

I am sorry, I somehow forgot to mention that I am running it in a code module

Hello, The data into Drill worksheet comes from Masterdata worksheet in the same workbook and the data contains 'Risk' as a field. The Risk field includes data of Medium and High Risk for all managers. I am hiding rows based on the Manager criteria (just like what autofilter does, but I am...

Hi Brian, Yes, the third book does not contain any sheet as you have named. Anyway, I have figured out the solution. Here it is: Thanks a lot for your help. Your code had opened my mind. :-)

Thank you Brian. However, I have a twist now. This code works, but I am making a macro in a 3rd workbook and when I am running with the code, it is selecting the range from the 3rd workbook and not the one from which it has to take it up. Please see the code below: I have written this code in...

Hello everyone, I have a table (say Col A to Col G) in an Excel spreadsheet and each column has some data. I need to copy the data and paste it into another workbook. All the columns may have different ranges, but Column A must be taken as a reference to cut-off the copying of data. Assume...

Hi, I have an Excel sheet with repeating data in column A. I have made a unique filter of that data and placed it in column E. I used shell function (shell "Notepad.exe") to open the Notepad I copied the data from column E of Excel and pasted it in Notepad by using SendKeys. (SendKeys "^V"). I...

Hey Brian, Thanks for the solution. I think I have to stress more on learning the array formulae. Thank you very much.

Hello All, I have a table in Excel 2003 in which I have to do a countif with the multiple criteria. Say, I have to count the number of people of a particular Race in a country in a continent (Eg: Count of Caucasian Race in a country (Japan), which is in continent (Asia). I have got the pick...

Hi, I have written a one liner VBA code to display the date, time and weekday name on the status bar of Excel (Version used is Excel 2003). Application.statusbar= date & " " & time & " " & weekdayname(date, vbsunday) Something of this kind written in Worksheet activate event. (this line...

Thank you very much Bob

Well, here is the code: Private sub CommandButton1_Click() Dim fname as String If cells(4,4)="" or isnull(cells(4,4)) or isempty(cells(4,4)) then Msgbox "Input Highlighted field", vbCritical, "Missing Field" Cells(4,4).select Exit Sub Elseif cells(5,4)="" or isnull(cells(5,4)) or...