|
create additional rows containing data from one original row
I have a spreadsheet of informational data containing mostly text that has
for each row one master id number, and then columns containing detail
information. one column for various colors, a second column for various
sizes.
I want to create multiple rows for each combination of master id number,
color, and size.
I figured a pivot table would be the best way to approach this, but I a...
|
1 |
12/24/2008 4:42:01 PM |
|
|
Shared file gets locked
Hi, We are using excel 2003, its a shared file, used by more then 10 ppl,
every now and then file gives message saying that file have been locked by
"user name" and it can neither be saved nor be 'Saved As'. Can some help me
out why this happens and how to get rid of this???
Thanks in advance.
Amit...
|
1 |
12/24/2008 2:50:01 PM |
|
|
Does anyone have aformula for Weeks Supply?
I have a formula that uses a lot of nested IF statements and am looking for an
improved one.
Currently, I calculate my weeks supply as follows:
Row C1 D1 E1 F1
5-Jan 12-Jan 19-Jan 26-Jan
Sales 2.5 2.9 2.6 3.2
Inventory 8.0 8.7 9.1 9.4
Production 3.2 3.3 2.9 4.1
Inv + Prod 11.2 12.0 12.0 13.5
My Weeks Supply formula for Jan 5 is:
=IF(D6>...
|
3 |
12/24/2008 2:33:53 PM |
|
|
Excel 2007 - Spreadsheet does not appear
I have received several spreadsheets from coworkers that, when opened
in Excel, do not appear. Excel boots up fine. I can "arrow" around
as if the spreadsheet was on the screen and cell contents show in the
contents line at the top of Excel but the spreadsheet is not showing.
How can I:
1. Get the spreadsheet to appear?
2. Set up Excel so that this does not happen again?
I've fixe...
|
5 |
12/24/2008 2:32:27 PM |
|
|
Using coding to autofill
Hi all
I have data sheets i want to automate.
Iwould like to be able to query the user for input and then fill the sheets
with common information.
Here goes:
In columns i want to be able to automate having the user enter the number 1,
20 times in 20 consecutive rows, then 2, 20 times, and so on to a user
defined amount of entries. For example(1) , if the user answers the question...
|
2 |
12/24/2008 2:19:07 PM |
|
|
Sorting down and over
I'm hoping someone can save me alot of work and aggrevation. I have a list
of cities in alphabetical order in column A and in column B a list of the bus
route numbers that serve those cities. This list is 20 pages long. If I
show it the way it is there is plenty of white space with lots of trees being
killed in the process. I want the data to show in two general columns but It
must r...
|
6 |
12/24/2008 2:15:00 PM |
|
|
Problem Linking to MS Excel Community Notification ??
Hello;
I've noticed recently that upon receipt of a Microsoft Community
Notification from notifyMS@microsoft.com and clicking "Read and rate the
response", I would get more often than not a blank MS Internet Explorer
window and "Done" on the task bar!!
I close the window, go to MS Office Discussion Groups::Excel::Programming::
etc. and find my way to the post. Very time consuming!
...
|
4 |
12/24/2008 1:50:49 PM |
|
|
cursor selects more than one cell range
I am making a spreadsheet and suddenly every time i click on one cell it also
selects the cell or two or three below it as well. Does anyone know why on
earth it's doing that? I'm trying to enter formulas, people won't be able to
enter data with 3 cells selected every time! Help please....
|
2 |
12/24/2008 1:40:56 PM |
|
|
Printing
I'm having a problem with things not printing or showing up on the print
preview the way they look on the screen and I have tried 2 printers with the
same results. The problem seems to be the printed character taking up less
room than the one on the screen so the more characters there are the more it
is off. For example.
Column a Column b
On screen aaaaaaaaaaaaaaaaaaaa bbbbbbbbbbbbbb...
|
6 |
12/24/2008 1:08:36 PM |
|
|
Just A Small Code
I want a VBA code for:
1. Select the Complete column of Currently Active Cell;
2. Go to the First Cell of the selected column (like Ctrl + .);
3. Count the number of items present in the selection; and
4. Finally Display the said column's number of items in a popup message;
5. If the selected column was the last one (as determined by Ctrl + End),
then display msgbox "Operation Complete";
...
|
2 |
12/24/2008 12:52:00 PM |
|
|
For FARAZ QURESHI - Column Entry Counts
The board is not operating properly, cannot find or reply to your request to:
select column, count & report items in it, move to next column based on user
choice and repeat - but here is code that I believe will do what you want. I
hope so, and I hope you see this message.
Sub CountEntriesInAColumn()
Dim lastUsedColumn As Long
Dim lastUsedRow As Long
Dim currentColumnArea As Rang...
|
1 |
12/24/2008 12:49:00 PM |
|
|
Last working day of a month
I am trying to write a formula to show the last working day (working days are
Monday to Friday) of a month based on the date in the previous cell. If A1 =
1/4/08, A2 should show 30/5/08 (Friday). I have tried
DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)+30). However, this picks up the day in
A1+30. What I want is the last working day of the month not the last day of
the month. I appreciate any help...
|
10 |
12/24/2008 12:12:00 PM |
|
|
How do I show file name at bottom of worksheet in Office 2007
...
|
2 |
12/24/2008 11:54:25 AM |
|
|
Data Validation
hello all,
is there any way to use following as a DataValidation.
IF A1 & B1 is equal then want allow to keying in data otherwise not.
A_1 B_1 C_1
D D Data input ok
D Y Not allow input...
|
2 |
12/24/2008 11:48:50 AM |
|
|
summing visible cells using SUMIF/SUMPRODUCT not SUBTOTAL
how to sum only the visible cells using SUMIF or SUMPRODUCT not SUBTOTAL...
|
2 |
12/24/2008 9:02:59 AM |
|
|
NPV/Sumif
Does anyone know how to do an NPV over multiple rows without having to sum
the columns. eg
Y1 Y2 Y3
NHU1 -100 100 100 etc
NHU1 -150 200 300 etc
NHU2 -160 140 300 etc
NHU2 -200 180 120 etc
Complete NPV by looking for NHU , summing each year for the NHU over
multiple rows. Obvious way is to total each NHU them NPV the total, or NPV
e...
|
4 |
12/24/2008 8:24:01 AM |
|
|
asign a number to a text string
it has to be very easy but I have not found the way to do it.
What I'm tryig to do is some list of companies and for their services I want
to use Yes for 1, No for 0, Sometimes for 0.5 and Maybe for 0.25.
just asigning these numbers to the text is what I want, so that it is easely
readable and editable for everyone and it still can make some addition of it
in the end.
Example:
Kw...
|
8 |
12/24/2008 7:21:01 AM |
|
|
how to use selectionchange instead of doubleclick event?
Hi,
I am using the following code to autofilter a list if the user wants to see
more details of employee training. The problem is, if I want to see more
details I have to double click first on employee ID and click on a link
beside employee ID. What I want is, once I click on the link, the link takes
me to the sheet of training and filter employee ID and training of him. How
to adjust t...
|
1 |
12/24/2008 5:00:05 AM |
|
|
Parse delimiter is change from text to numbers
I have a long list of items like this one below.
They consist of four things: Asset name, country, units, and market value.
Accor SA France 3,300,000 177,214,917
I want to parse this? Any ideas on the best way to do this? Open to all
suggestions. Prefer formulas over VBA for this one ....
|
7 |
12/24/2008 3:59:00 AM |
|
|
Linking cells
I want to have cells linked, but need help with the formula. I want to move
information with the stipulation to use a different cell if the first target
cell is occupied. For example, move to +A6 unless filled, then +b6.
I'm going to assume this is an If, then formula, but how would it look?...
|
2 |
12/24/2008 3:21:00 AM |
|
|
While open a file, just keep like looding.
I have one excel file, file size is 1,444kb and the office is MS 2000. While
open the file, from the bottom of file showing the loading bar. Something
like on loading to open the file. But is hang over there without showing no
respond. When I check from the task manager, found that is running two excel
file with the status no responding.
I confirm that this file is no double open. Try o...
|
3 |
12/24/2008 12:50:01 AM |
|
|
Reading replies
Anyone know why my post says "Community Message Unavailable"? I am trying to
read the replies, but I can't get into the original post... ...
|
2 |
12/24/2008 12:10:42 AM |
|
|
'Step' or Matrix Calculations
Here it goes.
Sales %
0-$250,000 0
$250,001-$500,000 15
$500,001-$1,000,000 20
$1,000,001-$2,000,000 25
$2,000,001-$3,000000 30
So I cant figure out the formula that would give me my desired result as
illustrated as follows. If a person sells between 0 and $250k, then don't
apply a ...
|
2 |
12/24/2008 12:08:45 AM |
|
|
Partial Text Color Change in Cell
Is it possible to change the color of just one number or word in a formula? I
have been reading and trying some of these conditional formatting posts, but
so far, no luck for what I am trying to do... For instance: =132+130+58 (and
I only want 130 to be red and the rest black)....
|
5 |
12/23/2008 11:11:59 PM |
|
|
WITHIN CELL, PARSE END OF TEXT, START OF NUMBER
Any suggestions on parsing data as below. I have a long list.
The one thing they all share in common is that they begin with text and end
with two numbers. Spaces can be anywhere within.
Accor SA France 3,300,000 177,214,917
...
|
3 |
12/23/2008 10:48:05 PM |