|
Missing Cloumn data when importing external data
I got 1 master excel file with 6 or 7 worksheets
- Basically, each worksheet is linked to the excel file via "Import External
Data" function.
- Each worksheet contains a table (6 columns and xx rows). The data are
formatted numerically.
What happened:
- Some worksheets works perfectly when refreshing the data (all data needed
in columns 1 to 6 are being refreshed).
Problem:
- In...
|
1 |
12/16/2008 11:22:01 AM |
|
|
Time calculations
I need the formula that will allow me to subtract a 1/2hr lunch if an hour
result is equal to or greater than 8.5 hours.
A B C D E
Start Time End Time OT Hours Total worked hours
7:00 15:30 8:30 8.0
This is an example of what my answer should be.
I have tried so many formulas that I thought should work but it doe...
|
4 |
12/16/2008 9:02:01 AM |
|
|
files in folders turning into icons
about once a week files that are in some of my excel folders turn into icons
and they also auto arrange any help in stopping this would be appreciated
--
richardg...
|
2 |
12/16/2008 8:46:01 AM |
|
|
OPEN ONLY IN READ ONLY FORM
Is there a way to open a file in read-only mode, although no such option had
been used while saving the file?
--
Best Regards,
FARAZ A. QURESHI...
|
3 |
12/16/2008 8:40:01 AM |
|
|
funtion writing
I have a big problem.I have data on members of 6000 households, with the
income of each and every member.now i want total income for each household.
for eg
household 1 member 1 $1000 total= 2300
member 2 $800
member 3 $500
Household 2 member 1 $200 total= 2200
member 2 $2000
household 3 member 1 $1000 total=...
|
2 |
12/16/2008 8:38:01 AM |
|
|
Format default comment font
Is there a way to format the comment box so it will default to NO initials
and NOT bold lettering? I'm trying to lessen the irritation of formatting
each box as I add a comment. Thanks.
All of you volunteers are surely blessed (may you have candy everyday of
your lives)for helping us.
--
Some days it just doesn''t pay to gnaw through the leather straps.
Find a Cure
=:-)-P(++)==|...
|
3 |
12/16/2008 8:08:01 AM |
|
|
Keyboard excel
Please help.
My keyboard keeps changing when I work with array formulas. I am not sure
which combination of keys causes the changes or how to fix it.
The keyboard is affected just in excel.
When I try and get an "=" sign I get a ")" instead, "z" is now "y" and "y"
is "z", etc...
Any ideas?
thanks
D...
|
9 |
12/16/2008 8:00:01 AM |
|
|
Automatically entering data
Good afternoon!
I would like to find a way to automatically attach a client name to a client
number. For instance, if client is called "thisismyclient", and his client
number is 00001, is there a way in the spreadsheet to automatically populate
the correct name by just typing in the client number?
Many thanks! PS, I work on Excel 2003....
|
3 |
12/16/2008 7:49:00 AM |
|
|
Excel Chart - Too many data points in Series?
I am working on a master data sheet for my 25 sales people and tracking their
progress every month. Other than the master worksheet, I also have 25 other
worksheets so I can visually graph each employees' data. 1 graph per sheet
(tab). As I go through the Create Chart wizard, I have 12 pieces of data in
12 different non-adjacent cells. Excel will only let me select 11 cells
located o...
|
2 |
12/16/2008 7:35:59 AM |
|
|
Remove blank row
how do i remove blank row from a sheet present at many places, which
restricts me from filtering all data in a sheet....
|
3 |
12/16/2008 7:19:01 AM |
|
|
Time calculus in Excel 2000
Greetings. I have recently been handed a project dealing with process times.
I have one set of numbers as seconds (ss.ssssssss) and one as a decimal
version of minutes (.91 m). What process do I need to know to convert these
numbers into a workable format. I'm hoping to have them as mm:ss.ss and then
doing basic math with the results. Thanks in advacne....
|
10 |
12/16/2008 6:01:01 AM |
|
|
Macro Security
How can I set myself as a "Trusted source". I am helping an organisation
streamline there spreadsheet activities, this includes some macros. When I
try to run a programme the security warning appears. Changing security level
to Low and then resetting later is cumbersome. So I want to know how to
identify myself as a Trusted Source so that the macros will be accepted...
|
3 |
12/16/2008 4:39:00 AM |
|
|
Formula to convert a number with spaces to just a number?
We import GL data in a CSV file and it gives year to data balances. The
problem is the number has spaces where a comma should be. For instance,
1,700,000.02 is in as 1 700 000.02 If the number is in the thousands there
are two spaces in front of the first digit, in the millions one digit. If
the number is less than a thousand than it reads as a number. Is there a
formula to remove t...
|
11 |
12/16/2008 3:21:17 AM |
|
|
Pictures on excel sheet
I have an excel sheet that I insert some pictures and when I print the page
some of the pictures are all black. But when I look at the print preview the
pictures looks fine. How can I solve the problem?...
|
1 |
12/16/2008 2:10:02 AM |
|
|
formatting in BOLD and RED in cell
I have this:
=IF(region_selected="All","AMF="& AC9 &" , APJ="& AC10 &" , EMEA="& AC11 & "
, Total=" & AC12,"Destination
("&VLOOKUP(region_selected,AB9:AC12,2,FALSE)&")")
If one region is selected the result may look like this : Destination (24)
If 'All' is selected the result may be: AMF=24 , APJ=20 , EMEA=17 , Total=61
I would like to have the numbers BOLD and RED. How can I do i...
|
3 |
12/16/2008 1:42:01 AM |
|
|
Consolidate an XLS sheet
Hi,
I would like to consolidate a new sheet retrieving data from two separate
tabs having exactly the same logical organization. Number of rows is known,
and varies among the two tabs.
Conceptually it is a simple sort of iterative loop, not sure how to
implement it though.
Thanks, Stefano...
|
4 |
12/16/2008 1:29:13 AM |
|
|
as i drag a cell, can increment the cell number? . eg.. D1..D4..D7
i wish to copy a cell with a formula, but as i drag it down it only
increments by one
can i make it increment by 2 ? or 3? etc....
|
7 |
12/16/2008 12:55:52 AM |
|
|
Deleting a row with a cell containing a value of 0.00
I would like to delete all the rows in a worksheet that contain the value of
0.00, these values come from another worksheet through the formula
=CheckInfo!$AC$2. The 0.00 are all in the same column. I am using Excell 2003....
|
4 |
12/16/2008 12:53:31 AM |
|
|
decimation
How to decimate temporal data in Excel? That is to reduce the number of
samples to the minimum significative number.
I am doing so by hand averaging groups of x-samples and checking visually if
the data to be averaged is significative to the meaning or simple noise.
Doing so over a large number of data is more than cumbersome, it is a
non-sense. I can code it but I need to teach to st...
|
3 |
12/16/2008 12:38:25 AM |
|
|
Data Validation question
Hello
I have 7 Data validation lists, each list gets it's content from a seperate
range (list 1 gets it's data from b2:b156, list 2 get's it data from B2:B156,
list 3 gets it's data from C2:C156 so on through to list 7. All the ranges
get their data from the range ti it's left via a formula
the formula does the following.
If I select 047 from a list, the formula replaces 047 with ""...
|
4 |
12/16/2008 12:25:24 AM |
|
|
Using clips in Excel
When I insert a picture into a cell in an excel spreadsheet, it doesn’t show
in the print preview. Also, if I sort the spreadsheet, the pictures don’t
stay put in the correct columns/rows and they become distorted in size/shape.
I’m trying to insert thumbnail pictures of my paintings into a spreadsheet
for inventory and sorting purposes. Maybe this can't be done in Excel and if ...
|
4 |
12/16/2008 12:25:02 AM |
|
|
Can't see what text I have hightlighted to format
When I highlight cells to format I cannot clearly see which cells I have
hightlighted so I end up formatting cells I do not want included....
|
1 |
12/16/2008 12:14:02 AM |
|
|
Cumulative total??????
Hi,
I have the following in sheet1
Cell J3= Todays date
Cell F8= Hours flown in one flight on that date
Cell H8= Cumulative total for the day
Cell C8= Cumulative total for the year
I do the above with the following code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Range("F8")) Is Nothing Then
Range("I8") = Range("F8") + Range("I8")
...
|
1 |
12/16/2008 12:03:01 AM |
|
|
Sumproduct puzzler - apologies for incorrect post to Programming
Hello Lords of Excel!
I know this can be solved in one cell but am going round in circles.
I have 20 Volume Descriptions with varying volumes over 160 months.
Further down on the shet, I have a user selectable range of these Volumes of
up to 5 catagories.
What I can do over two ranges is index match the volume to fit the selection
by row no problem. I can then sum those 5 cells in...
|
12 |
12/15/2008 11:34:53 PM |
|
|
Attaching an Outlook email into a cell
I use a 2003 Excel spreadsheet to monitor account moves within our company.
User experience with Excel varies from low to high. Many people are
accessing the spreadsheet through SharePoint. Among the many pieces of
information that is gathered is an Outlook email approval to move the
account. This email approval needs to be referenced on the spreadsheet and
allow other users to easil...
|
1 |
12/15/2008 11:17:02 PM |