Search results

One solution, though not effective, can be... To use 3 fields to see the result. Eg: if you want to see if wheat has fallen to 0, then in one cell type in wheat, and here you can use VLOOKUP to see the value of wheat (in this case, 0) and then for the next cell (to view the date), you can either...

It would be better and more clear if you attach that spreadsheet here...

This may sound ridiculous, but I still want to say that instead of merging the cell, duplicate the value of that cell. for example, you have the 2 columns merged on row2, type in the same data in both the columns instead of merging it. I don't really know if it works out or not because I...

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

Thanks for the instant response DCrake...!!! I would try the update query method that you prescribed. Thanks a lot

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

Hey guys...!! I forgot to tell you that my only source is VBA. So, if anything that I have to do, I have to do it either throught the front end (Direct in Word) or through VBA. Any help..??

Hi All, I have a text template in word in which there are some of the places where I have to replace some of the text with the specified other. For this, I have made a template in excel where I input the replacable words. Now how to export these replacable words from excel into the specified...

How do I do that..???

Hello Everyone, I'm the process of creating a database regarding scheduling of days. I have created a form and then through Active X control, linked a calender to the form. Now when I click on the calender, the dates would appear in the listbox provided. Now, the problem is, though I enter...

Thank you very much Roli001..your code seems to work.!! However, a small problem, though the code's working properly, with each change, F5 has to be pressed in the enviroment (or option Run in Excel environment) to get those displayed in the dropdown. For instance, Condition: A in cell 1...

Thanks for the reply..!! One clarification is required. How to insert cell dropdowns into this code. I have a general code of validation in VBA which somewhat start like: with range("e10") .validation .add xlValidateList, xlValidateAlertStop, xlBetween _ "=$a$377:$a$378" incelldropdown =...

Hi everyone, I'm working on an excel file in which I have to validate one cell when it satisfies a condition in the other cell. For instance, if cell A is 1, then cell B should be validated to a, b, c (Incelldropdown). I have tried it through wizard (in excel menu bar "data >...