|
Text Boxes and Check Marks
I have 187 rows of text boxes and check marks that I need to delete. It is
only allowing me to delete them in Design Mode one at a time. Is there anyway
I can delete them all at once? ...
|
2 |
12/18/2008 10:30:01 PM |
|
|
Excel totaly disappeared from my computer
I did a Microsoft update last night and today 2003 Professional Excel is
gone, when I try to open the workbook here is the error:
The feature you are trying to is on a network resource that is unavailable.
Click OK or try again, or enter an alternate path to folder containing
PRO11.MSl in the box below.
I tried everywhere and I cannot find PRO11. MSl or the installer files on my
PC,...
|
1 |
12/18/2008 10:24:07 PM |
|
|
Workday Problem
I am trying to use a receipt date and add to that, a number of days into the
future, and have excel provide me with that date using only workdays and not
holidays or weekends. I consider the receipt date as already 1 day old. So I
am using the following calculation:
=WORKDAY(A7,3,Holidays!$A$1:$A$70)-1
It works fine unless the holiday lands on a Monday.
example: If I have a receipt da...
|
5 |
12/18/2008 10:17:39 PM |
|
|
Print Entire Workbook acting strangely
When I want to print an entire workbook as one document, I normally choose
File, then print, and then choose Entire Workbook, and the entire workbook
prints as one document (sometimes I use a pdf writer, and this turns the
workbook into one document).
I have one workbook which is printing each worksheet separately. Does anyone
know what would cause this behaviour? I've never seen it be...
|
2 |
12/18/2008 10:17:01 PM |
|
|
Copy and Paste
Hi all
I have done this a 1000 times but now its not Doing it Properly!!
Copy one Work sheet with Formula to new work book.
It copies only values and not Formula and is not giving me an option to
paste the formula
Original Sheet Not protected
Excel 2003.
Put me right please
Best
Stew...
|
3 |
12/18/2008 9:57:02 PM |
|
|
Average If Statement (Excel 2003)
I am trying to find the formula for averaging cells in column B if the data
in Ais (a specific criteria). I've tried some formulas in the threads
related to average, but nothing seems to work.
Example:
If A1:A110 equals 01
Then Average B1:B110 (cells related to the criteria in A1:A110)
When using formulas, should cells have a specific format? Because there is
text involved, I set t...
|
8 |
12/18/2008 9:01:48 PM |
|
|
Macro to shift
Is there any way to to change this macro so that every time it is run the row
is changed? Here is the macro:
Range("C1").Select
ActiveCell.FormulaR1C1 = "=Master!R[3]C"
Range("E4").Select
ActiveCell.FormulaR1C1 = "='Riverview East Owners'!R[0]C[-1]"
Range("E5").Select
ActiveCell.FormulaR1C1 = "='Liberty House Condominium'!R[-1]C[-1]"
Range("E6").Select
I want to t...
|
4 |
12/18/2008 8:59:01 PM |
|
|
Compare and import data using two spreadsheets
My dilemma involves having two spreadsheets of data. One spreadsheet (A) is
formatted while the other is in a more general format (B). I would like
formulas that compare data in B to the formatted data in A. When a match is
found I need to import data from a column with updated pricing in B and
overwrite the pricing that is currently in A. Also, any record that is in B
but not in A s...
|
2 |
12/18/2008 8:40:06 PM |
|
|
Change the column width
I want to change the column width ( reduce the width) and get teh following
message and the command is not executed:
Message: Cannot shift objects off sheet .
What does it mean and what do I need to do to reduce the width of this column...
|
4 |
12/18/2008 8:36:13 PM |
|
|
Asked to Save Twice??
Here's a strnageone. I have a couple of workbooks that when closing after
making changes I get a meesage asking if I want to save changes. I click
yes, the workbook saves and then I get yet another confirmation asking the
same thing.
Not a big deal but curious minds want to know. Any idea why this is
happening? (there is no VBA code attached to the workbooks)....
|
3 |
12/18/2008 8:28:09 PM |
|
|
Convert Excel to Word
Hi,
Is that anybody know that how to convert the excel file in to word file ? I
have type a lot of thing in Excel,I do not wish to retype again to word, is
that any solution ?
I have try to copy and paste, but the excel's gridlines will show in word,
or is tat any solution to delete the gridline which show in word (when copy
the thing from excel)
Thanks !...
|
3 |
12/18/2008 8:03:44 PM |
|
|
Date Format
I have this formula in a cell =IF(K2="","","Check Number"&" "&J2&" "&"in the
amount of "&I2&" was mailed on "&(K2)), and on cell K2 i have the date format
as mm/dd/yy, but the result returned this "Check Number 12345 in the amount
of 258.93 was mailed on 39797." How can I change the 39797 to show 12/15/08?
Thanks.
...
|
6 |
12/18/2008 8:03:01 PM |
|
|
Automatic Update for Date
But I want the date to only be Fridays. Each week it has the date of that
Friday & then it automatically changes the next week to that Friday. How do
I do this? If the TODAY function will do this then I need someone to explain
to me in detail how to do this....
|
4 |
12/18/2008 7:59:02 PM |
|
|
Copy/Paste formulas in merged cells
I have a spreadsheet that has merged cells in the following cells: A1&B1,
C1&D1, E1&F1,G1&H1,I1&J1 AND K1&L1. A1&B1 and C1&D1 have values, E1&F1
formula is =A1, G1&H1 formula is =C1. When I copy cells E1&F1 and G1&H1 into
cells to the right I1&J1 and K1&L1 the forumla stays the same such as it
treats it as an absolute but there are no $ in the formula. The formula
should change to I1&...
|
3 |
12/18/2008 7:58:01 PM |
|
|
copy 2007 created macro to run in 2003
I have a macro that I created in 2007 that I would like to make available for
my users of 2003. I have the icon on the quickaccess toolbar. It is only one
macro that aligns the columns, sorts based on column A (customer #), applies
5 conditional formats that color entire row based on contents of column K
(status of customer order), then subtotals column L (order total) by column A
(Cust...
|
5 |
12/18/2008 7:48:01 PM |
|
|
Automatic Update for Date
Basically I need to know how to make a date update automatically. For
example, the date column reads 12/19/2008 (Friday). Then the next day
(Saturday 12/20/2008), it will change to read 12/26/2008. Is this possible?...
|
6 |
12/18/2008 7:47:01 PM |
|
|
Excel query for a stock sheet.
Hi there!
I have just started my new job and I have o set up a stock sheet.
What I want it to do is highlight with a warning if the amount from a new
stock take is lower than the previous stock take figure for a particular item
so that it can be re-ordered.
eg: (Column A) Item Detail , (column B) Previous Stock take figure, (Column
C) new Stock take figure
Green Side plate, 22, 14
When...
|
1 |
12/18/2008 7:37:01 PM |
|
|
Change protection of a shared workbook (Excel 2000)
Hi,
Is it possible to protect or unprotect sheets of a shared workbook without
stopping sharing?
I would like each of my employees to have a separate worksheet in a shared
workbook, but I have had problems with individuals modifying the contents of
another's sheet. My caveat is that the workbook is shared, so that everyone
can view each other's data - I don't want to stop sharing ...
|
1 |
12/18/2008 7:29:01 PM |
|
|
Change cell based on answer in another cell
I am trying to make a cell have an "x" marked in it if another cell has a
certain word in it. Example: F2=George then A14=X, If F2=Mary then A15=X....
|
2 |
12/18/2008 7:25:10 PM |
|
|
Combining Cells
OK, there must be a way to do this. I have a list of names in column A, each
name has a number after it in column B - I want to combine all the names into
cells based on the number after the name. Exmple:
I want this (imagine that it's two columns)
bob 1
david 1
ted 2
mike 2
linda 3
anne 3
to turn into this:
bob, david 1
ted, mike 2
linda, anne 3
I can...
|
4 |
12/18/2008 7:23:02 PM |
|
|
Conditional Formatting
I am trying to format rows R2:R187 to change the font red and bold if it
starts with *.
For example: *Have Amanda review payment of $25.00*.
I need to leave the dollar amount open ended because it changes everytime.
Also, occasionally comments will be added into the same cell underneath the
above note, and I do not want that formatted.
Thanks!...
|
3 |
12/18/2008 7:00:09 PM |
|
|
Using Excel to capture Inventory
Has anyone used excel as an inventory tracking tool? I've set one up and
every time something comes out of inventory in a given month, just add an
additional plus to the formula on that line item. I've set up a reorder
number and an if statement when a number drops below a certain number, it
alerts me to reorder. However, a few items need removal from multiple places
and people forget...
|
2 |
12/18/2008 6:51:00 PM |
|
|
Adding columns
How do you select 3 columns then skip the next four columns, select the next
5 columns and then make a report that will fit and print landscape mode?...
|
5 |
12/18/2008 6:49:24 PM |
|
|
Special copying of columns
Hi,
I need your help again :-(
I have two columns A and B.
In column A there are values of general type,
in fact there are strings of characters.
In column B there are values of general type
or fields are empty.
The values in columnB can be equal to those
in columnA or can be different.
What I need is to copy values from columnA
to columnB but only if the field in columnB
was empty....
|
3 |
12/18/2008 6:44:24 PM |
|
|
Fetching multiple lines in Excel
Hi,
I am using a formula in a sheet which will display multiple lines in excel.
However, the only problem is the speed, this formula slows down the
performance of the sheet because data size is really huge.
I want to know, is it possible to have different formula/way to fasten up
the things here.
Sample file is uploaded on the following location:
http://www.savefile.com/files/1937...
|
2 |
12/18/2008 6:31:01 PM |