If I enter a number into any cell which has already been entered into another cell, regardless of row or column, is there any way in which my attention could...

I use a ZIP drive and a 1.44 floppy drive to store financial information. I keep duplicate files on the floppy. The Zip drive is the primary storage. After...

Hi I have a spreadsheet with a large list of dates which I want to order into their month. I would like a Vlookup that looks at the month field and...

Hi, I have a problem. I have in column A a system tag 202.E.0716/LN114-01. I want another column to automatically give me 202E0716LN11401. I have more than...

How do I change the excel worksheet that automatically opens when I start the program?

i need to check to see if a given range of cells each fall within a range. Say I had a column of data like this: 2 3 6 3 4 I want a statement that checks to...

I cannot find the Excel 97 SR-1 patch on the office website. Where can I get it?

Please help!!! I am trying to lookup a value in Access but am having problems with the code. I have seen the code others have used on this forum, but I...

I am trying to open two different program files, one after the other, in VBA within an Excel macro. This is what I have so far: Shell ("C:\Program...

I want to change a formula linking to a cell in a workbook on another server so that the server name is used rather than the drive mapping. I have tried the...

the calculation that i require is for eg. 9am -7am = 2hours or 120minutes, expressed in the hh:mm format, but if the answer is a negative i get ####, thus i...

hi, anyone to solve my problem ? I have an Abacus that contain : Cell B1 to R1 contain (CABLE SIZE): 4mm, 6mm, 10mm, 16mm, 25mm, 35mm, 50mm, 70mm, 95mm,...

I need a macro to do the following in B3:B500 If(right(......,5)="Total" Delete Right(........,6) Hope this is clear

I have a spreadsheet with colums one with number and second with alphabetic list . Now i wanted to add the same word RR3 to the right end of each row of the...

I have a large macro I wrote, and which I've used for some time. It takes a string of characters and parses it into separate cells using some arcane...

I have a problem I have created a hyperlink to a picture on my hard drive and when I click on the hyperlink it does nothing. How can I make excel show...

Can I set some aspect of the cell format based on a formula value? For example, I would like to change the cell fill color based on whether the value in that...

I feel like a dummy for asking, but, I've played with Page Setup, Page Break, Print Area, etc., etc. and can't figure out how to resize the printed image. I'm...

I have a list of customer names in cells A87:A?? I need to sort this list, but the list might get longer when names are added. I have a VBA code that adds the...