|
Cell in Excel spreadsheet will not accept entry of specific data v
I have a spreadsheet where certain cells will not accept my name, but will
allow almost anything else. I have other cells that have silmilar problems
with other data. These cells did have validations in place which were
removed. But I did a Clear ALL on the cells in question and even used the
validation command to "accept any value" but nothing I try works. Anyone
have any suggestion...
|
4 |
27.09.2006 15:23:44 |
|
|
Named Range Question
I have a series of named ranges that are Question_1, Question_2, Question_3,
etc. I'd like to reference them with something like this:
"Question_"&A1 where A1 is 1, 2, 3, etc.
within a complicated array formula. How would I do this so that it finds
the named range?
Thanks...
|
5 |
27.09.2006 15:10:02 |
|
|
find a worksheet and extract data
I have 3 different worksheets, "01-01-2004", "01-11-2005", "01-01-2006".
In a separate spreadsheet I want to insert a formula that gives me data from
the worksheet I specify.
e.g. In cell A1 I insert the date of the worksheet I want to use, e.g
01-01-2004.
I want to find a formula that looks for the worksheet dated 01-01-2004 and
gives me the data that is in cell B7 of that worksheet....
|
4 |
27.09.2006 14:39:38 |
|
|
Simple lookup - or maybe not so simple - help!
Hi,
I am putting together a very simple worksheet for some sales tracking
and I have hit a bit of a road block when I am trying to utilise the
Lookup and Index functions.
I want to be able to pick the type of sale in 1 Coolum from a drop down
list (have this list working ok). Depending on which option is chosen
(5 possible options), I want to populate a cell with the cost data
relating ...
|
2 |
27.09.2006 14:09:10 |
|
|
Want to choose last filled line, but dont know how?
How can I choose last filled row and copy it to other worksheet?
People are filling excel sheet and the latest data should be copied to
summary sheet (all can be in same workbook). ...
|
4 |
27.09.2006 14:08:02 |
|
|
Capture RS232 data
Hello, I work with a system that prints out receipts on a dedicated little
printer whenever there is a transaction.
I want to be able to capture the information onto a laptop that I plug in
instead of the printer, and end up with it all in an Excel spreadsheet.
The printer connects to a multi-pin socket that looks like a COM port.
The data comes out (and I don't know what any of this me...
|
2 |
27.09.2006 13:55:45 |
|
|
How do I limit characters in a cell?
I have a cell with this information: "1234_01_251225". I need to have a
formula that will only give me the first 4 characters "1234". Is there a way
to do this? I need to add the formula to the entire column of data, since I
have thousands of rows of data....
|
4 |
27.09.2006 12:44:08 |
|
|
How do I sort by entry date?
I am trying to sort my excel workbook by entry dates. I enter date daily and
my boss wants a report on a weekly basis of only the new items I have
entered. How can I get the program to perform this for me?...
|
5 |
27.09.2006 12:24:02 |
|
|
How do I change the order of tab through unlocked cells?
I know you can create a Name Range - but that only seems to work in an
unprotected worksheet. Is it possible to create a randomly selected name
range (for specific order tab-thru) in a protected worksheet?...
|
1 |
27.09.2006 12:00:02 |
|
|
Using "@" unrelated to email address
When using Excel (Office 2000) worksheets to track my stocks, I use the "@"
symbol to mean "at" (like 500 @ 56.30). Instead the cell auto-formats it as a
formula (=) and tries to make an email address out of it (with little blue
underlined letters) and then tries to put me online. No matter how I try to
format the cell it is ignored. After a struggle I can trick it but there
must be a ...
|
4 |
27.09.2006 11:09:42 |
|
|
fined all same word in one text and sum number of repeat within d.
hi
i want know can you write one function , that , able select one word in one
sheet in excell whithin diferrent row and column. for example fined evry
world , that start by A.
the other thing converting in excell is wear, how i can creat one function
for converting date of excell in the other date ( conver calculater ) to my
callender .
----------------
This post is a suggestion ...
|
1 |
27.09.2006 10:31:01 |
|
|
Multiple conditions for conditional formatting
Can I have more than 3 conditions for multiple formatting? If so, can anyone
tell me how? I have 4 potential text phrases to choose from a drop-down list
and would like each to be coloured appropriately
Many thanks.
P....
|
5 |
27.09.2006 10:00:01 |
|
|
Strange problem with Code
I have this code on a sheet.
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("E2:F3003")) Is Nothing Then
Exit Sub
Else
Sheets("Main").Range("G2:M3003").Calculate
Sheets("Main").Range("Q2:Q3003").Calculate
End If
End Sub
The reason I have this code is I have three columns of large array formulae
at the end of my sheet and keeping the book on au...
|
2 |
27.09.2006 09:16:25 |
|
|
Using cells to refer to worksheets
Hello,
I am trying to SUM the total number of a specific colunm for a number of
different worksheets, in the same worksheet.
I.e. Sheets are named 'Ward 3', 'Ward 5' etc, and in my 'Total Contacts'
sheet I want to SUM up the column H3:H36 for each of those worksheets. So I
have been able to generate the correct formula for each worksheet
A B
...
|
2 |
27.09.2006 08:36:04 |
|
|
User Defined Functions - local or global?
I have a set of templates that we use to check/calculate costs from
invoices using a set of user defined functions (nested if's beyond the
normal limit).
I had these set up as local (each sheet uses a different set of functions,
so it made it easier for me to navigate/maintain), but I was having trouble
whenever I needed to copy or move a sheet (ie we routinely check over 100K
records...
|
6 |
27.09.2006 08:15:59 |
|
|
Importing CSV-File with formatting informations
Imaging a file containing a CPR-number (eg social security-number) in column
1 and name in column 2, like this
0101612342;Michael Jackson
0202655431;Janet Jackson
In column 1 there can be leading 0 (zeroes), which I want to keep.
When I import I want to to avoid to use the wizzard to make the column to be
text every time, I want Excel to do it automatical.
I have tried to do it like "01...
|
3 |
27.09.2006 06:57:02 |
|
|
Activating Function
I just used the Add-In tool to activate additional spreadsheet function. I
now have a function in place [=RANDBETWEEN(0.9,1.1)] but it isn't active,
i.e. the cell displays the number "1" and when I use the cell as a multiplier
it multiplies by one. In other words, the cell isn't functioning by giving me
random numbers between 0.9 and 1.1.
I suspect that there is some sort of "activation...
|
8 |
27.09.2006 06:54:25 |
|
|
Need Help Badly!
I make a DARTS scoring workbook with 26 Teams, each Teams as is own sheet,
So every week i enter the scores on each sheet, then using a namecell, i
copy to the master sheet....
What i need to do, since i have many teams and many week to enter.
On each sheet, i need to enter and name 26 cell diiferently.
EX: A1=T1WK1 - A2=T1WK2 AND SO ON!
As you see the naming is almost the same but...
|
5 |
27.09.2006 04:54:02 |
|
|
how do i use if function to different texts
I want to say IF A1 = "International" then multiply A2 by 16% and if A1 =
"European" then multiply A2 by 20% and if A1 = National then multiply A2 by
10% etc etc etc
Please can anybody help?...
|
7 |
27.09.2006 03:28:02 |
|
|
How do i place a roundup functoin at the end of a formula?
=G7*0.062 roundup(g7,2)...
|
4 |
27.09.2006 02:51:01 |
|
|
Count text based on multiple (2) conditions
I want to be able to count the number of times text occurs in one column
based on a match with a different condition in the second column.
The formula: =SUM(IF{(A199:A216="Karratha",IF(B199:B206="DET",1,0)))}
returns #N/A when entered as an array and returns 1 when entered as normal.
...
|
5 |
27.09.2006 02:49:18 |
|
|
Help on Adding the same cell in different sheets.
I am working on a big excel sheet, and I am kinda new at it. How can I get a
sum of the values on 45 different excel sheets? I can only get the sum of
about 15 sheets for so before it says that my formulat is too long. Here is
an example of the formula: =SUM('Service Invoice (45)'!D29+'Service Invoice
(44)'!D29)
I need to get the sum of cell D29 from sheets 1-45.
thanks for your help
...
|
3 |
27.09.2006 02:37:50 |
|
|
Copy and Paste help needed - tia!
Let me start by saying I do not know Excel hardly at all. Also, what I am
using it for is I suspect somewhat different than the average user here.
I sell on ebay, and I have roughly 15000 items up. While the item title and
item pictures are different for each item, everything else is exactly the
same, description, price, shipping, all of it. I have a CSV file of my
listings from ebay, and...
|
3 |
27.09.2006 02:12:12 |
|
|
SUMPRODUCT help
I have a worksheet that is tracking items that are missed broken down daily
by employee... The columns look like:
A2 (date) B2 (Name) C2 (Initials) D2 (# of items)
Same as above for: F2 G2 H2 I2
then the running tally in K2 (name) L2 (Initials) M2 (Running total)
I've tried two different formulas with no result but the horrid ####'s.
=SUMPRODUCT(--($C$2:$C$31="TLG"),--($H$2:$H$31="TLG"...
|
2 |
27.09.2006 01:54:39 |
|
|
vlookup
I have a workbook with 2 worksheets. Sheet 1 has a table ranging from A1 to
M200. Sheet 2 has a table with matching data from Sheet 1’s table A, F & I
columns placed in Sheet 2’s A, B & C columns. I need to match the data in
Sheet 1’s table A & F columns and Sheet 2’s A & B columns to get the data
from Sheet 2’s C column. The data from Sheet 2’s C column will be placed in
She...
|
4 |
27.09.2006 01:33:01 |