lost

<tbody> Rule Born Trigger Variable XYZ Texas Texan A or B or C or D ABC New York New Yorker A or B or C or D RST RST A or B or C or D WXY WXY A or B or C or D DWF DWF A or B or C or D </tbody> Hello I need help with this excel formula. Basically I always have data in Rule column...

Hello, I'm hoping some one can get me started building this excel spreadsheet... I have only a tiny bit of excel experience I think this spreadsheet should be real simple and only have a few calculations... I'm thinking the only Data needed will be: Current Date. Current Vacation...

Fortunately, I had already exported the modules to BAS files and zipped them.... just in case I am completely baffled by this.

Hello! I'm not even sure if this can be done. I have several columns with various labels, for the example I am going to use; year, size, weight and height. What I'm trying to do is create a macro that assigns a number to rows to all rows, but puts the same number in those rows where the...

Hello, 2nd post here. I have this code : Sub creer_tache() Dim nom_liaison_tache As Variant Dim nom_projet_liaison_tache As Variant Dim check_P As Boolean Dim check_ssp As Boolean check_P = False check_ssp = False Dim i As Integer For i = 1 To 20 nom_projet_liaison_tache =...

I'm an old guy disabled by worsening chronic illness and cognitive deficits and I can't remember how to look at a macro I used to have in an Excel 2003 spread sheet of my medical records. Yesterday when I opened that spreadsheet the macro didn't work as it usually did. So I figured that the...

This is really strange. I have a fairly extensive VBA Excel 2010 project going. Among other things I have a group of options: optAgentMail, optAgentHold, and optAgentWire. During the program, the default condition is hidden. During the program, they are made visible. At the end of the program...

Hi everyone, Longtime listener first time caller. I have a couple of tasks that I am trying to complete for my boss. I am trying to rework some data and get some explanatory statistics out of it. My data set is a time series with 10 variables and about 5800 daily observations. First: I...

Often, when I copy data in one workbook, then alt-tab to another workbook, and keystroke alt-e-s-v to paste just the value, the copied data is gone from the clipboard, and I end up keying in "esv." I'll retry several times, sometimes with success, other times, I end up ctrl-c'ing, then...

I created a doc, saved it, opened it, added information, made changes saved it. Saved and entered info several times. I went to open it, and it reverted back to the original save. WTF!!! errr there were no formulas or anything, just data. It was saved as a shared document, but I was not sharing...

To a helpful excel friend, I have a sheet that does not show the first row. I tried everything (all I know) to show that row. e.g. Goto A1 will hilight the line beneath A. or set row height to 20. Nothing works. Do you have a suggestion? Thanks, Paul

Help please This keeps happening, and I can't see why... On some worksheets and spreadsheets, when I save the formulas disappear, only to be replaced by the previously calculated values. It has become a real pain. I assume this is something simple. Can anyone help please? Thanks & Regards

When you have, lets say an invoice, and you are wanting to hide the rest of the columns and rows normally a light grey; however, I have seen templates and such with different colors in that background. My question is, how do I change that hidden background color??

We have a 3 page workbook that we store on our server. The server is using Windows Server 2000 NT technology. The workbook is shared. We use it to track our jobs. One sheet has info from cell A1 through AG3226. Not every line and cell is used, but there is a lot of data. This is the sheet...

Using XL 2003 Im trying to determine how many Nos are tied to a certain subject. Here is the format: _| Subject | Y/N | 1 SUB1 YES 2 SUB2 YES 3 SUB1 NO 4 SUB1 YES 5 SUB2 NO I have a dropdown on a different sheet where I can select a subject. I want to be able to determine how many nos...