HELP! how to cross - data with excel??

Hi, I'm required to present some info at my work, using two excel files. This is the task: File 1, has ID numbers in column A, and column B is blank. File 2, has ID numbers in column C and column D has the date the person joined the company File 1 es a select grop of people (about 2500), whereas File 2 is the general database (about 30thou) They're asking me to match the data, in order to end up with the coresponding date they joined the company in column B on File 1 (obtained from column D on file 2), how to do it? taking in account that File 1 is outdated and some peo

Mixed colur text.

I have cells that contains a mixture of black and red text. Other cells contain either only black or only red text. I wish to (a) selectively locate the cells with mixed-colour text and then (b) change the red text to bold black text. leaving any original black text as unbold. I have got as far as the stage of trying to detect these cells. When I use: Cells(i, j).Select iColour = Selection.Font.ColorIndex Valid indexes are returned for only black or only red text contaiing cells. But I get Invalid use of "Null" as an error message on the mixed cells. . Can sks pl

Excel 2010 fails to save or open from network drive

In Excel 2010 I receive the following error message whenever I try to open or save a file to a network drive: " Microsoft Excel cannot access the file "C:\Temp\Content.MSO\8A68000 *The file name or path does not exist *The file is being used by another program *The Workbook you are trying to save has the same name as a currently open workbook " I have full permissions to read/write/delete to the network drive as well as c:\temp\Content.mso This happens both on a windows XP sp3 and Windows 7 system. I do not have the save/open problem in Microsoft Word 2010, just in Excel

styles.xml part (Styles) error

Hi, I am exporting data from an Access 2007 database into Excel 2007 .xlsx format and as part of the export I select the keep formatting option. Everything seems to work fine, but when I try to open the .xlsx file I get the following errors: "Excel found unreadable content in 'spreadsheet.xlsx'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes." I click Yes, then get a dialog box labeled "Reairs to 'spreadsheet.xlsx'. The dialog shows: Repaired Records: Format from /xl/styles.xml part (Styles) I know that's not a lot t

Strange results

I im working with Excel 2007. I have these numbers -10.555,12 -14.600,60 -16.341,07 -75.259,65 -27.445,85 -7.899,05 135.760,27 16.341,07 That I like to add. The result should be 0, which is what I get, if i use =SUM(B19:B26) Unfortunately the numbers are part of a larger amount, and is determined by another number in a nother column, so I have to use SUMIF. My SUMIF looks like this =SUMIF(A19:A26,9334,B19:B26) but the result of this is -7,27596E-12. I have seen this before when trying to add calculated numbers (due to decinmal errors), but in this case all the numbers a

Workshhet name

lcConnectionToOpenedXls = "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq="+<ExcelTemplateFilename>+"; DefaultDir="+JUSTPATH(<ExcelTemplateFilename>) lnHandleToOpenedXls = SQLSTRINGCONNECT(<lcConnectionToOpenedXls>) SQLTABLES(lnHandleToOpenedXls,"","fWorkSheetAlias") SQLDISCONNECT(lnHandleToOpenedXls) I use this VFP coding to retrieve worksheet information from the excel file. If a worksheet name contains a dot(.) it shows as # after retrieving data. What is the reason for this? What are the other characters represents in # marks after retrieving except of the (.)

If the cell is not empty, then...

I have a many rows of 12 cells where it is possible to write a number/ text in the cells. I would like to be able to calculate how many of these cells, in one row, that are different from empty, and then multiplie this with the value 8,3 Like if 7 cells in one row are different from empty, then =SUM(7x8,3) how can I do this ?

calculation based on the range you indicate in another cell

I use Excel for basic project management. I use formula below to calculate hours spent on a specific task of a project. The range is B22 to B2058, A43 is the project name, BC15 is the task name. B column is the hour, H column is the task. =SUMPRODUCT((worksheetname!$B$22:$B$2058=$A43)*(worksheetname!$H$22:$H $2058=$BC$15) I noticed that there are recurring projects that I'd like to count only the recent change so the range needs to be dynamic. I'm thinking that I can have another cell on the same row that I indicate the date after to track. The formula would use that date and find t

We are here for all your events!

Attention! Need an excellent event management for your business and home we must do events on your behalf with attractive Fees! Contact us :-) Rtlx Groups 61 PNS Gold Mahal, South Avani Moola Street, Madurai - 625 001, Ph No. 0452-4230735, MBL 9597766651/52 Website: www.rtlxgroups.com Email ID: rtlxgroups@gmail.com moorthy@rtlxgroups.com

Generate GUID, Find Duplicates, Replace, Rescan

I am trying to find a way to generate GUIDs, which I've found, but I need to ensure they are truly unique. Here is the script that generates the GUIDs Sub GenerateGUID() Dim c As Long, r As Range c = 1 Set r = Range("a2") Do Until r.Cells(c, 1) = "" Dim strGUID As String Set TypeLib = CreateObject("Scriptlet.TypeLib") strGUID = Left(TypeLib.GUID, 38) r.Cells(c, 16).Value = strGUID c = c + 1 Set TypeLib = Nothing Loop End Sub Here is the script that scans for duplicates. I need a couple changes, but I don't k

�jection du programme excel

bonjour je travaille avec Excel 97 SR-2 pour une raison inconnue , je suis �ject� ,� r�p�tition, du programme Excel. Le message suivant s'affiche et je suis �ject�: " ce programme va �tre arr�t� car il a effectu� une op�ration non conforme " ECX=00000208 DS=0197 ESI=017e23f8 FS=0d6f EDX=017e23d8 ES=0197 EDI=00000000 GS=0000 Octets � CS : EIP : 66 8b 08 83 c0 0e 81 e1 ff 7f 00 00 51 50 52 56 �tat de la pile : 00000208 00fe2164 303e16a4 017e23d8 00000000 00fe2164 00fe2164 060f0002 7863c388 0000049f ffffffff 0002f18c 8950060f c3440002 787e0002 00060004 Auriez vous une id�e pour �viter

formula to count instances of something

Using Excel 2007. I want to create a series of cells with a formula that will count the number of cells elsewhere that contain a certain word. "[ ]" means a cell. Example: [Category 1] [sub category 2] [#of instances] [sub category 3] [#of instances] Elsewhere on that XL spread sheet, I would have rows that have [sub category 2] [data...] [data...] [sub category 2] [data..] [data..] [sub category 2] [data....] [data....] [sub category 3] [data] [data] [sub category 3] [data] [data] [sub category 3] [data] [data] [sub category 3] [data]

interpolated values

Column A Column B Column D 4.99 3650 6.500 5.06 3940 6.450 5.12 4230 6.400 5.19 4520 6.400 5.26 4810 6.450 5.33 5100 6.500 5.39 5430 6.500 5.46 5760 6.400 5.53 6090 6.350 5.60 6420 6.300 5.68 6750 6.200 5.73 7100 6.150 5.80 7450 6.150 5.87 7800 6.100 5.93 8150 6.050 6.00 8500 6.000 6.07 8850 6.150 6.14 9200 6.350 6.21 9550 6.450 6.27 9900 6.470 6.34 10250 6.900 6.41 10650 6.950 For the input values of column "A" I am having respective out put values in column "B". now for any input number between "4.99" to "6.41", I want output values to be

ADSENSE ACCOUNT ONLY $5 WITH IN 4 HOURS

ADSENSE ACCOUNT ONLY $5 WITH IN 4 HOURS WORLD TOP BLOG $20 WITH IN 4 HOURS CONTACT CHINNAMNAIDU HYDERABAD INDIA +919866357079 VISIT http://onlineairlinesjobs.blogspot.com http://andhraonlinegames.blogspot.com http://ukgirlsbody.blogspot.com

Conditional formatting based on length of the cell contents

Hi all A customer is using Excel to define data which will later be mangled into a database, but they have a habit of putting in strings that are too long. I'd like to be able to format a range of cells so that if (e.g.) the length of the text is greater than 8 it is coloured red (or whatever). So, 'abcdefgh' would be OK and normal but 'abcdefghi' wouldn't be and would be highlighted in some way. The conditional formatting help wasn't helpful. This is Excel 2007 / Excel 2010. TIA

Finetune formula to get currency format?

I've managed to put together two different formulas from two different sources and it seems to be working okay except in terms of the format of the numbers. The formula is this: =IF(G2="?",TEXT(G2,"$0")&" ttl unknown",G2*I2) The "$0" in there is a remnant from the original. I don't know what to do with it so I've left it in. The purpose of this formula is to deal with situations where a list price is unknown and a user puts a question mark in G2. This formula goes into the totals column but there is no total known so the result will say: "? ttl unknown" Yet when there

Text Output To CSV

I have an Excel spreadsheet that has a column formated as text. The colomn contains UPC codes, many of which have a leading zero. That's why I have the colomn formated as text, so that I can see the leading zero. Now.... When I export the file to a CSV, it turns that colomn into a number (ex. ....,0968574433298,...). I want it to keep it as text (ex. ...,"0968574433298",...). Is there any way for me to force Excel to do this when it creates a CSV? I have to be able to do this because my store that I upload these products to requires a string for that field, in order fo

Changing Part of a Formula En Mass

Good morning, I need to edit part of a formula in many cells - but they don't all follow each other - so I cannot use the fill option. Is there anyway that I can edit text within the spreadsheet? Almost like a flat file where I do a find and replace? Thanks

Resource Planing Excel Sheet

Hi, Is there a good (free) excel sheet that can help resource planning? With the tool, i want to list resource (people) usage in varity of projects, from now to the remained times of the year, in weekly and monthly basis. Thanks. -- Life is the only flaw in an otherwise perfect nonexistence -- Schopenhauer narke

replacing zeros by blank cells

Hi, Charts read cells with 0 as value, but a blank cell as a missing value so that it is not presented on the chart. What is the trick to replace the zeros in a large table by blank cells? Thanks for your help, -- milet

Work hour tracing program

Hi, Could anyone recommend a work hour tracing excel sheet for me? I like to find a good and free one. I should be able to define tasks and log tasks in hourly wise. Thanks. -- Life is the only flaw in an otherwise perfect nonexistence -- Schopenhauer narke

Changing xlsx file to zip and deleting a file

I have a user who has an Excel (.xlsx) file that took about 15 seconds to do a simple calculation. But, there are a bunch of other formulas and conditional formatting statements in the file. The file size was "only" 351 KB. There are only 5 worksheets, two of which didn't appear to be used. I went through the other sheets and checked for: - hidden rows/columns - I found none - the area of each worksheet that had data and calculations was small (the most rows on any worksheet was about 130, and the columns didn't extend past P) - the formulas and conditional formatting didn't s

Exclude Range from Random Name Generator

This is not work-related. I've been using Excel to draw random names for my family's annual Christmas gift exchange for several years. There are four families and a family cannot end up with anyone from their own family. The best I've been able to do is 'draw' one name at a time and assign each to a family - throwing the name back if it happens to come from the family I'm drawing for at the moment. I'd like to take this to the next level by figuring out a way to limit the selection pool based on the family by excluding its own members. So the names in Family A's hat will only include m

Text vs. Number

Why is is that if I have a tab-deliminated file or csv file that I open in excel the following happens: If the field has twelve digits (a UPC code) -- say 068888701648 -- that when it gets into the Excel spreadsheet is drops the front zero and calls it a number. I don't want that to happen. Also when I export to a csv file I want the field to be a text field -- "068888701648" -- as opposed to a number. This is the reason. What I've been doing up to this point is creating a custom format -- 000000000000 -- twelve digits. Most UPC codes have a zero at the beginning. S

Creating parameters in excel for an access-linked query

Hi, I have an excel sheet that's linked to a query in an access datadase. I'm looking to make it possible that upon opening the excel file, user's can choose to view data by one of two parameters (the column names are product code which isn't a visible field, and ID). Once the parameter is chosen, subtotals of each columns are displayed at the bottom. Can anyone point me in the right direction to achieve this, I'm kind of lost. Also I don't have much experience with Visual Basic, but know this is the direction I have to go in.