How can I allow my first 3 rows as my fixed heading, and the rest of the rows are my records. This means that the 3 rows will always not able to page down, it'll always visible on top while I ...
Hi:
I'm trying to find a formula for a cell, not a VBA solution, to return the name of the person logged onto the PC. Is this possible?
Thanks
Charlie
see attached file
Hi Experts
Need amacro that will proform the following steps: see worksheet "sheet 1"
1. column C cells that have no date (i.e. empty one to be shown as "-")
2. co...
Hi
I have a table of values where a user comes in and enters data in some columns and in another few columns it will populate figures on data he has entered. The populated columns use the Vll...
I have an excel spreadsheet on which I have 2 Custom toolbars with macros assigned to each of the buttons. I have clicked the "attach" button on the toolbar customize dialog box and copied the...
We would like to be able to freeze a set of values on cells that have auto-calculating formulas.
In case I'm not clear I'll try another way of saying this, we would like some values to ch...
Cells a1:a100 often have trailing spaces because they are imported from a web page. (geeesss I hate this, it happens all the time.)
I usually use vba to fix the cell's directly, but I wond...
Hi,
2 sheets has to be compared with 1 sheet and show results on screen
Resigned sheet has to check with Desktops sheet on colum "E" in both sheets
Disabled Accounts has data in colum "...
Hi,
I receive a xls file from one system, am running a VBA macro on it and saving it as a CSV so it can be imported into another system.
I don't have control over either of the other sys...
I've got a spreadsheet that is already set up with formulas. I need to add a "ceiling" statement to the existing formulas, without making any other changes to the formula. The existing formula...
Hi,
Need an option to add the comments data in colum "D"
The existing code does the job of quering 3 colums and getting the data what i want is to query the comments in each cell that has ...
Ok, I have a new problem.
I have groups of three numbers, in their own cell. I have to compare these numbers as a group of three against many thousands of sets of other groups of three.
...
I am trying to create two Data Validation lists that depend on the value of a third column. The validation lists are spread across two worksheets in the same workbook.
Sheet1:
Column ...
Experts,
I need to highlight a column when Now() is a certain number of days after a given date and another column is not "Completed". I have two seperate formula that give me each but can'...
Hi All
Im using Excel 2007. Is there a way to make the background of a user form transparent?
Thanks in advance
Elmo
All I have is a .DBS file from an old server that was running SQLBase 6.1.2-PTF11. The server and the s/w are no longer available. I just need to get the data from the .DBS file into Excel o...
Hello,
I have a C# program that uses the Excel interop (Microsoft.Office.Interop.Excel) to monitor an Excel 2003 spreadsheet.
I use the delegate named WorkbookEvents_SheetChangeEventHa...
Dear experts,
Given
Today's date in cell F1
Date ranges by bucket in range I2:M2
As shown in cell I3, start date (15th Nov) will be one day more than the date in cell F1
Required
N...
I need to analyze what are the amount of materials that I use for each activity in the business. I want to use an automated process such as a Pivot table. I have attached a simple example of...
I am trying to validate if part of a cell content contains the word "Advance". How do I accomplish this? For example; how I incorporate this into the function "If"
Experts,
I understand that you can have up to 6 nexted if statements. I can't even get two to work.
=IF(I3<=M3,0,G3*Q3),IF(I3>M3<=M4,0,G3*Q4)
The function below works. However, after calling a "black box"-function (in *.xla) that also uses Find(), it doesn't work no more. It simply doesn't find anything, though it should!
Come on...
I am trying to write a conditional formula that is based on an indicator and also date. I attached a sheet with data to work out my formual. Basically I was to sum the total below the dates...
I can use what ever makes the most sense .. I have a table that includes a filed for mac adresses but no colons. the data I have to use it for requires them. I dont care what I use be it off...
Hello,
I have coding (see below).
I want to highlight/select the range. NOT autofill!
I want to automate them using VBA and ensure the range reach the last row.
Could you help. Thanks
