|
picture display problem
I got a problem which is I can preview excel file with picture normally, but
the picture be strange (e.g. the picture separate line by line) when display
in normal screen mode, why?
Thx for help
JY
...
|
1 |
22.09.2006 17:10:21 |
|
|
Sort numeric data in more than 3 columns in excel
Hi All,
I have to sort 12 columns of numeric data in descending order on a
excel worksheet. I currently sort 3 at a time and then move forward.
For example, I have sales data for months Jan to Dec. I want each of
these columns to show zeros at the bottom when the macro is run. The
rows would increase in future but the columns would be fixed. The
worksheet would also remains unchanged each ...
|
2 |
22.09.2006 17:06:09 |
|
|
Custom Menu activates Web Toolbar
Made a custom menu, added custom buttons and assigned hyperlink
Now every time I open one of these files, the Web ToolBar pops up.
I don't need (or want) this.
How can I stop this secondary action?
...
|
3 |
22.09.2006 16:54:09 |
|
|
Formula to calutale overtime?
Hello.
I am currently paying my employees on a percentage basis. However, my new
payroll company is requesting that I turn in hours for employees. Because
my staff is paid on a percentage basis they can work as much or a little as
they wish.
How can I calculate the following in excel (if possible).
John Doe made $1,200 at 37% in one week however if I track his hours he
worked 50...
|
10 |
22.09.2006 16:07:49 |
|
|
Objet variable question?
Is there an objet variable that would tell me the current running
macro/module?
Thank's ahead.
...
|
2 |
22.09.2006 16:06:02 |
|
|
Excel & RAM
I'm experiencing problems at work with my PC constantly 'Not Responding'
when in Excel, working with large data sets and complex formulae. The PC is
new, a
3.00 Ghz Pentium 4 HT, but with only 512MB of RAM.
I'm experiencing similar problems in Access, when working with &
queryinglarge data
sets. I'm making every effort to ensure my workbooks are designed as
efficiently as possible, s...
|
3 |
22.09.2006 15:11:02 |
|
|
Problem with changing a cell validation through VBA
Dear all,
I have a problem with a macro which I have recorded in Excel. The macro
comes with an error in running the recorded script. This error is:
Run-time error '1004': Application-defined of object-defined error.
This is the VBA-coding which has the problem:
Range("A12").Validation _
.Modify xlValidateCustom,
Formula1:="=AND(COUNTIF($A$11:$A$52;$A12)<2;VLOOKUP($A12;PRO...
|
6 |
22.09.2006 15:01:48 |
|
|
Counting cells that have the same data
I have a spreadsheet with 31,000 rows, column A has a number that is
duplicated numerous times. There are 7500 different numbers in the
column, I want to know how many times each number appears. Is this
possible?
...
|
4 |
22.09.2006 14:23:56 |
|
|
Conditional Cell Number Formatting
I've looked back on several thousand messages or so and haven't seen
this so here goes. I need to be able to set the numerical format of a
cell based upon the contents of another cell. In other words if C1 is
equal to x than the numerical format of C2 would be "00000" and if C1
equals y then the C2 cell's format would need to be set as
000000000000. I hope I've been clear, thanks!! All i...
|
8 |
22.09.2006 12:11:42 |
|
|
Create meeting groups from list of attendee preferences
Hi there,
I am trying to create a function that will automatically allocate
conference attendees to a meeting group, based on their preferences. I
have a spreadsheet with the following info:
Attendee Group1 Group2 Group3
Joe Bloggs 2 1 3
Jane Bloggs 1 3 2
Jim...
|
3 |
22.09.2006 11:12:15 |
|
|
Printing an Excel doucument
In this example, I have a document of 100 pages, when I print the
document, the column headers only print on the first page and not the
subsequent pages. also I would like all the pages to be numbered. is therea
fix for this?
...
|
2 |
22.09.2006 10:28:44 |
|
|
Fomula to copy every third cell in col
I have a list of business addresses and phone numbers in 1 column. Ideally I
would like Col A the be name. Col B address and c phone number. Here is the
format I have right now. Please help.
Ultimate Staffing
3435 W Cheyenne Ave, North Las Vegas, NV
(702) 647-0477 - 2.8 mi SE
Allied Forces
1401 N Decatur Blvd # 21, Las Vegas, NV
(702) 647-6668 - 4.3 mi S
Labor Express
1401 N Dec...
|
3 |
22.09.2006 05:20:01 |
|
|
Sorting
Hi,
XP Pro
Excel '03 plus '07 beta...
I am doing a mail merge from excel. There are two pieces to a page. I need
to sort the list but when I do a two up page, page 1 has #1 and so forth.
In small quantity that is not a big deal but when you do a 1000 pieces it
adds a lot of labor.
IF my list were 500 pieces, I would need to sort the spread sheet to print
page 1 to have #1...
|
1 |
22.09.2006 01:27:38 |
|
|
How to restore F2 functions
Lately, I am unable to outline, when entering edit mode in a cell, the
cell's formula-related cells. I used to, upon pressing F2, see a cell's
formula and, highlighted in differing colors, the cells referenced by
the formula to be edited/viewed.
Any ideas how this very useful feature may be restored?...
|
3 |
22.09.2006 00:19:08 |
|
|
Retrieve Deleted Worksheet
I did something very stupid. I deleted a worksheet from a workbook. I
thought to myself: there are too many worksheets in this workbook.
That one is blank, so I'll delete it. Unfortunately, there are some
important macros stored in that worksheet and I don't have another copy
of them.
Is there any way to retrieve them?
Thanks very much
...
|
9 |
21.09.2006 23:53:25 |
|
|
Underline with accounting format
Preface: If you use the accounting format and the underline you get a great
underline that is just a little less than the width of the cell.
Problem: It does not underline the right parenthesis in negative numbers.
Question: Is there any way to create a customized version of the accounting
format that will to go all the way to the right and go under the right
parenthesis for negative n...
|
5 |
21.09.2006 22:27:29 |
|
|
Playing MP3 files embeded in Excel
I'm using Insert | Object | From File to insert an MP3 file into an Excel
2003 worksheet. I don't link to the original file (so I'm embedding it) and
I change the icon from the default. Excel shows the icon correctly and
allows me to play the file in Windows Media Player v10 successfully by
double-clicking on the icon.
But if I wait for the MP3 to finish playing and then double-click on...
|
1 |
21.09.2006 22:22:04 |
|
|
Make a pivot table from an existing pivot table
I'm trying to make a completely new pivot table out of an existing
pivot table where the existing table is actually the source data (not
the original data table). The problem I have is that this intermediate
pivot table has 3 columns of unique values (with over 1000 rows) before
we get to the data. I can't just copy it and make a pivot table, or
create a mirror sheet that isn't a pivot tabl...
|
3 |
21.09.2006 22:10:46 |
|
|
Remove Date Timestamp in Excel?
Hi there,
I was wondering if someone can help me out. I am using a csv file and want
to calculate if things were done on time or not.
Example:
In the A column I would have "Date Expected"
In the B column I would have "Date Completed"
In the C column I have an IF formula such that if B<= A then "Meets"
otherwise "Not Met"
But I have a problem since I get the data from a csv f...
|
3 |
21.09.2006 20:35:44 |
|
|
Formatting decimal Number as text
I want to show a number (really a dollar amount) as you would write on a check
10.95 as "Ten and 95/100". I wrote a function, but it's tricky. Anyone
know a way to use just straight EXCEL formatting
BTW I use Excel 200 with Win XP.
Thanks,
Don...
|
2 |
21.09.2006 20:11:53 |
|
|
mystery background color
In some worksheets that I've inherited, I noticed that there seems to
be a way to give sheets a background color other than
Format/Sheet/Background (which uses an image) and
Format/Cells/Patterns.
As is the case of Format/Sheet/Background, this color does not print.
In the workbooks in question, the color does not vary from sheet to
sheet, so it may (or may not) be workbook-wide.
My d...
|
10 |
21.09.2006 19:18:21 |
|
|
Stop Sum blanks
I am using the Sum function. My range has blank cells. I am entering 0 for
No. If I get a Sum of 0 then I have an answer of False. But how do I stop
Excel from displaying 0 when the range of cells is left blank? ...
|
4 |
21.09.2006 16:20:02 |
|
|
find a sum number from 300 numbers in Excel
I have 300 numbers and 1 number. I want to know whether that 1 number
is the sum of the combination of those 300 numbers and which several
numbers in these 300 numbers sum up to produce that 1 number. Some of
these 300 numbers are same. Can I use Excel to work out that question?
How?
All help would be appreciated.
Best regards,
Tim
...
|
4 |
21.09.2006 14:39:37 |
|
|
RE: looping through pivot tables
I need to loop through each pivottable, making the
PivotItems(i).Visible = False, then making the one consecutive in the
PivotItems(i) = True for each PivotTable
Dim j As Integer
For i = 1 To Worksheets("Output").PivotTables.Count
MsgBox Worksheets("Output").PivotTables(i).Name
For j = 1 To
Worksheets("Output").PivotTables(i).PivotFields("Timeframe").PivotItems.Count
Set myRa...
|
1 |
21.09.2006 13:46:52 |
|
|
1 excel file but 2 windows open
I receive a excel file from my workmate
when I open this file, the excel windows open and display the same content,
but the file name shown are different, e.g 1 windows show abc:1, another
windows show abc:2
And the file owner dont know why the file become like this.
Any setting make this effect ? and how to make it become a normal file?
Thanks in advance...
|
2 |
21.09.2006 09:45:09 |