Search results

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

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

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

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

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

Hi, Can anybody crack this...!!! I have 2 columns in Excel 2003. The rows of column A contains some text which is the same as the rows in column B, except for few differences. Eg: Row 1 of col A: This is a test line Row 1 of col B: This may be a test line I have many rows of such kind...

Hello....ppl..!! Somebody please tell me what OFFSET does... I have some problem.... Have data (say column 1 has codes, each code would have multiple data in another column (column B) and each entity of column B has multiple (and sometimes redundant) data in column C. I have used OFFSET...

I have an event in VBA: CalcVal_Click() dim startdate as date dim i as integer startdate= date(month) & "/" & 19 & "/" & date(year) For i = 2 to 20000 If sheets("Data").cells(i,4).value="" then Sheets("Measure").cells(i,2).value=Empty Else Sheets("Measure").cells(i,2).value =...

I have a database in one spreadsheet and table on another spreadsheet. The database would have the data of all the months.... There would be a field named TAT (which is a number) The fields required: Month TAT Centre (centre is an area of work, say Birmingham, Yorkshire, etc.) So, I want...

Is there any way to protect the formulated cells and still run a macro which results ultimately in the change in values in those cells due to dependency on the macro results..?? Or is it better to write all the formulae in the VBA environment, by which no formula is visible on the cell and...

My data comes from MS Access as an export fille (.xls) wherein I have a column which contains all names redundant. I want to find the count of the Unique records only for which I have written a macro in the 'Open' event of the workbook which filters the unique records and gives the count of...

I have a report coming from COGNOS in the form of Excel spreadsheet. I want to take the required values from the exported sheet into the table that I have (in Excel). The Exported spreadhseet (coming from COGNOS) consists of various rows which vary from user to user and time to time. The...

Hi... I am working on an Excel project (Excel 2003) wherein I have to pull data from other Excel sheet. I have to count one field based on other field... Field 1 : Yes/No Field 2 : Date Now, I want to count all the "Yes" from Field 1 based on Field 2 I have used below formula (as seen...

This may sound like a silly question...but still, I have this one..:confused: I am designing a form in Excel, which consists of all checkboxes. A total of 60 checkboxes is what I need to induce into that form. After putting some checkboxes, then form reaches the end of the monitor, I need the...

Hi, I have a database into which I import data from Excel spreadsheet thorugh the form interface. I need the timestamp of the import in the table for each item that I import. The structure of the table is as follows: ItemNo ItemName TimeStamp 1-------ABC -------(Time should get recorded...

Hi, I have an Access form through which am importing data from Excel into the Access table (Docmd.transferspreadsheet, acimport, acSpreadsheetTypeExcel8, "TableName", "SourceExcelSheetPath", True). This above code has been assigned to a command button and is working fine, but by default, the...

Hi, I have an Access form through which I import the data from Excel spreadsheet (by assigning Docmd.transferspreadsheet to a Command Button). However, this should be the case when the database is empty. The probelm: I have to transfer the data on a daily basis. So for the first time when...

Hi guys..!! I'm working on an MS Access Database where in I have to calculate the deadlines for tasks people input (in the form of data). But the problem is if it's a Friday, then the task should skip one day. For instance: in general, a task would have its deadline as 1 day. If the task is...