Search results

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

Hi Everyone, I am currently using Excel 2003 version. I am developing an application which does not gets closed if all the required fields are not filled up in a particular spreadsheet. And, if all the fields are filled up, then upon clicking upon the button 'SAVE' (which I have developed...

I guess Pivot Table would do....

Goto TOOLS> MACRO... There would be an option to record a macro....(may be NEW). Then a dialog box would appear to record macro....there would be an option to assign a shortcut key (Option would start with 'CTRL+' followed by a box..input any key (preferably, the ones that are not assigned by...

Goto VIEW tab on the menu bar, check on FORMS..You would see a tool bar popup), click on CommandButton icon and place the CommandButton at a desired place in your spreadsheet...you would get a dialog box related to macros...click on RECORD...then do all the tasks that you want to do (in this...

It is not possible as far as I know... Work out some other way Jennifer....like, you can fix the reference each time at a regular intervalic gap...like if A1 today, then may be C1 tomorrow and E1 the day after tomorrow, etc...but make sure that if you are going to use such kind, then you have...