Summary: I am looking to find out if a specific value falls in a range of values on a separate sheet and return a value. For example: Sheet 1 <TABLE> <TR...
Summary: I have a set of numbers that I need to find out if they are in a certain range, if they are, I need them to report back the range For Ex: Column A (in...
Summary: In column A I have a list of items that all start with an A (a1 a2 a3 etc) In column B I want to use “lookup” to generate a sales report from anot...
Summary: Several Things. The most obvious is the range. VBA does not recognise Excel ranges in their "spreadsheet" form. "sheet2!b:c" means "a bunch of alphanu...
Summary: I am trying to put in an event driven time stamp in excel. When data is entered in a cell, the adjacent cell records the current time. This is a sheet...
Summary: Question 1 The code below does exactly what I want it to do when using it on the same sheet. i.e. If a number greater than zero is entered into cell ...
Summary: Using a million nested "If"s is almost always a bad idea. There are many other ways around this problem which are far easier to implement and far far ...
Summary: You can use visual basic: Private Sub Worksheet_SelectionChange(ByVal Target _ As Excel.Range) 'colors active cell yellow with blue outline Cell...
Summary: I want to use the following command Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not Application.Intersect(Target, Range("A51,A100,A14...
Summary: The following is a macro that I run(copied from someone else) that enables the entry is a cell to trigger a permanent time stamp in another cell. Wor...
Summary: Tom, The following code was shown when I looked. Any ideas? "Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) End Sub" also I h...
Summary: I have a an excel spreadsheet and an access database. I need to take some specific data from access to excel. Normally I would import the data into e...
Summary: If I understand your first problem correctly you can solve it with the functions INDEX & MATCH. If your data in the "lookup table" is in the array E6:...
Summary: Hi, I'm using Excel 2002 and I need some help. I have 30 text files (one for each day of the month) that I need to import into separate workbooks, and...
Summary: OK, I will try and explain how it all works together. My master (parent) file consists of one sheet which has all the data I need in the columns. The ...
Summary: I would like some help with a lookup table. I would like to create an excel spreadsheet to help with my vehicle logbook. What i want to achieve is on ...
Summary: Hi, Is it possible to just lookup an Access database from within an Excel sheet to see if the value is there? eg. I have a list in Excel of accounts, ...
Summary: Hello. I am fairly new to conditional formating in Excel and would appreciate some help with a basic request. I use Excel 2007, and I would like to ...
Summary: I am working with an Excel workbook that contains two sheets. On the first sheet, I have several columns of information about departments participati...
Summary: I have an Excel workbook with 4 worksheets in it. The code is set up on the 1st worksheet. When a quantity is entred in a cell under the Quantity co...
Summary: Hi All, I am trying to reference an excel workbook that is on a LAN (at work). The idea is to copy the contents that is on sheet1 and paste it on shee...
Summary: Hi there. I'm hoping someone can help me simplify a function that I'm using in excel. Basically I have rows of data, e.g. Row 1 - XOOXO Row 2 - XXXXO ...
Summary: How do I format the cells, in Excel, to remove everything, but the APT in my below example. I have many different cells, in a single column, that are ...
Summary: Yes it is quite possible and quite simple too. Use the VLookup formula. Lets say that in Sheet2 you have your 156 words in column A1:A156 and their de...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
