Time input in w/sheet #2
I had a problem which was resolved (or so I thought) yesterday regarding
input of time. I was kindly given the solution
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim TimeStr As String
On Error GoTo EndMacro
If Application.Intersect(Target, Range("A1:A10")) Is Nothing Then
Exit Sub
End If
If Target.Cells.Count > 1 Then
Exit Sub
End If
If Target.Value = "" Then
Exit Sub
End If
Application.EnableEvents = False
With Target
If .HasFormula = False Then
Select Case Len(.Value)
Case 1 ' e.g., 1 = 00:01 AM
TimeStr = "00:0" & .
|
3/12/2010 12:38:01 PM
|
0
|
=?Utf-8?B?UnVzc2VsbCBEYXdzb24=?= <russell.daw...@discussions.microsoft.com>
|
|
Text colour keeps changing to grey
I'm finding that the text within several of my spreadsheets (though they were
all based on one original master spreadsheet), sometimes shows as grey when
the spreadsheet is opened.
I'm able to get it to go back to normal by going to
Tools-Options-Color-Reset, but is there any way of stopping it from doing it
in the first place?
thanks
Sarah
|
3/12/2010 12:26:01 PM
|
0
|
=?Utf-8?B?U2FyYWhN?= <Sar...@discussions.microsoft.com>
|
Auto fill column with sequential numbers with decimals
Want to auto fill as follows: 3, 3.1, 3.2, 3.3, 3.4
What method works? Can only seem to get sequence on primary number, example:
3.1, 4.1, 5.1
I want the number to the right of the decimal to change.
|
3/12/2010 10:43:01 AM
|
2
|
=?Utf-8?B?RG9nc3Rhcg==?= <Dogs...@discussions.microsoft.com>
|
Claculating Annual Turnover forma Quarter
Hi All
Does anyone know the formula to calculate the annual turnover rate based on
a current quarterly percentage???
Thanks
Caz
|
3/12/2010 10:00:01 AM
|
2
|
=?Utf-8?B?Q2F6IEg=?= <C...@discussions.microsoft.com>
|
Printing Excel Viewer
hai,
how prevent that excel viewer ask a location of file. because i already
selected at explore when i use right click then choose print. it always ask.
any workaround for this problem ?
TIA,
Andy Susanto
|
3/12/2010 9:49:01 AM
|
0
|
=?Utf-8?B?QW5keSBTdXNhbnRv?= <AndySusa...@discussions.microsoft.com>
|
Graph linked with combo boxes
Dear,
I need assistance in plotting a graph which is linked with 3 different combo
boxes. I have data for different persons from 1st jan onwards.
I have to plot a single graph which is linked with 3 different combo boxes
having the drop down list of name, start date and end date. The graph should
reflect only the data, once the required person's data for a date range is
selected using the 3 different combo boxes.
Please assist. Also suggest if there's a better to get this.
I could able to link the graph with one combo box earlier using the below
link.
http://peltierte
|
3/12/2010 8:31:01 AM
|
2
|
=?Utf-8?B?U2FzaWtpcmFu?= <Sasiki...@discussions.microsoft.com>
|
Trailing Spaces in Merged Cells
Hi,
I have a large spreadsheet with data in merged cells. When I look in Excel,
the trailing spaces doesn't appear and when I copied the data onto Notepad,
the spaces are shown. I have tried TRIM (works for single cells not merged
cells). Any help would be greatly appreciated.
|
3/12/2010 6:14:01 AM
|
0
|
=?Utf-8?B?TWVuZw==?= <M...@discussions.microsoft.com>
|
Find Duplicate names and delate
Dear experts,
I have a small doubt could you clarify that???
That is I find duplicate name but I want to delete one name only, if I
filter DUPLICATE….. both names are showing…
|
3/12/2010 5:47:02 AM
|
3
|
=?Utf-8?B?RmluZCBEdXBsaWNhdGUgbmFtZXMgYW5kIGRlbGF0ZQ==?= <Find Duplicate names and del...@discussion
|
Insert Comment
Hi
Using Excel 2003.
For some unknown reasons, the sheet in my excel file don't allow me to
insert comment (ie. the Insert Comment is greyed out)
How to solve it?
Thanks
|
3/12/2010 5:10:01 AM
|
1
|
=?Utf-8?B?UEw=?= <...@discussions.microsoft.com>
|
Locked for Editing
There is an excel workbook that is locked for editing and it has at this
state for over a week. I need to be able to forcibly delete this file,
renaming as a different file name is not an option. Is there anyway that I
can forcibly delete this file?
|
3/12/2010 3:36:02 AM
|
0
|
=?Utf-8?B?T2ZmaWNlIFVzZXI=?= <OfficeU...@discussions.microsoft.com>
|
same numer/character at beginning of cells in row
I have to make a worksheet of products. I can copy the part numbers but need
to have all the part numbers preceded by "2M" no quotation marks. example:
starting number looks like this "el000c" need to have it look like this
"3Bel000c".
The information is being copied from several other sheets via cut and paste.
Is it possible to paste the "el000c" number with the 3B already there and
staying after pasting several cells at once?
Thanks in advance regardless of the answer.
|
3/12/2010 3:04:08 AM
|
2
|
=?Utf-8?B?TUdE?= <...@discussions.microsoft.com>
|
Adding a column if two ranges match
A B C D
1 Participant Volume Group 1 Group 2
2 name 1 3 name 3 name4
3 name 2 4 name 5 name 20
4 name 3 1 name 6 name 150
5 name ...
---------------------------------------------------------------
Sum Sum
I am attempting to add coulmn B based on which group the participants are
associated with.
I have a master list of the tot
|
3/12/2010 2:12:02 AM
|
2
|
=?Utf-8?B?eFJhaQ==?= <x...@discussions.microsoft.com>
|
time formulas
I have times generated in h:mm in cell A1 and A2 I need a formula in A3 that
subtracts A2 from A1 and produces the difference (either negative or
positive) in h:mm.
For instance, the time in A1 is 6:15 and the time in A2 is 6:00 I need A3
to return -:15 or -0:15. All I can get is ###########.
Thank you in advance for any help offered.
--
bob
|
3/12/2010 1:38:01 AM
|
2
|
=?Utf-8?B?dmRtYnFi?= <vdm...@discussions.microsoft.com>
|
text and number
i have something like this in a cell:
T2 T2 E1 T2 N3
can I add just the numbers and put the answer(10) in an adjacent cell and
disregard the text?
|
3/12/2010 1:36:01 AM
|
0
|
=?Utf-8?B?V2FkZQ==?= <W...@discussions.microsoft.com>
|
convert column with inches to 2 columns "feet" and "inches"
I have a spreadsheet that has a column with total inches, but what I really
need is 2 columns that shows how many total feet there are in one column and
how many left over inches there are in the 2nd column. What formula can I use?
|
3/12/2010 12:01:02 AM
|
2
|
=?Utf-8?B?ZnN1ZGlhbmU=?= <fsudi...@discussions.microsoft.com>
|
Pivot Table help
I previously asked about consolidating rows of data that I was looking at and
got the following response that worked great:
I took your Source data and did the following...
Created a pivot Table from the data (I think you are good to here)
Placed the Duty Location in the Left Column (not top row)
Placed the State to the immediate right of the Location (not in the data
section)
.... same thing for all of the remaining fields
Place FTE's in the data section.
Pivot tables like to add in subtotals. You can remove the subtotals by right
clicking on the field and select Field Opti
|
3/11/2010 11:57:02 PM
|
0
|
=?Utf-8?B?Sm9uIGluIHRoZSBVJkw=?= <Joninth...@discussions.microsoft.com>
|
Prompt if data is not entered after so many times
Is it possible to highlight a cell if that data has not been entered after so
many times? For instance, if I have a column where I have entries of A,B,C,
& D and say B hasn't been entered for 7 times since the last entry of B, is
there a way to highlight that last B then? Hopefully my question is clear
enough to understand.
|
3/11/2010 11:26:06 PM
|
1
|
=?Utf-8?B?QWNlV2lsbA==?= <AceW...@discussions.microsoft.com>
|
Find and TRansfer from another Tab in same Worksheet
Hi, I have a worksheet in which contact information (names/add/postcode etc)
are stored in a secondary tab. I need to update the information onto the
first (main) tab. Is there a way I can put a postcode into the postcode
column and for it to search the secondary tab, match the postcode there and
transfer full contact information to the main sheet?
Thanks in advance. David
|
3/11/2010 10:29:01 PM
|
1
|
=?Utf-8?B?ZGF2aWU2NzA=?= <davie...@discussions.microsoft.com>
|
deleting temporary excel files
My computer crashes when exiting excel on all files. I remember that you can
delete temporary excel files and cannot remember how to locate them and
delete.
Will this fix my problem
Dave
|
3/11/2010 10:06:18 PM
|
0
|
=?Utf-8?B?RGF2aWRt?= <Dav...@discussions.microsoft.com>
|
Looking up your previous questions
I am really in need of looking up a past question I asked here, but cannot
find it through the search function. Is there a way to retrieve the messages
that you've posted here? Thanks in advance!
|
3/11/2010 9:58:03 PM
|
6
|
=?Utf-8?B?Sm9uIGluIHRoZSBVJkw=?= <Joninth...@discussions.microsoft.com>
|
Easy One!
I have this formula:
=COUNTIF(A1:A10,"sup")
I want the sum of a few other acronyms as well. How can I retrieve the sum
of several different acronyms within the same data range? Help!!!
|
3/11/2010 9:44:02 PM
|
5
|
=?Utf-8?B?U2t5ZGl2ZXI=?= <Skydi...@discussions.microsoft.com>
|
Need macro - please help
I have an Excel spreadsheet that is emailed to me each day. I have to make
the same changes every time before I print. I am trying to consolidate these
steps into a macro but can't seem to get it to work.
I shrink the column widths for all columns (the largest of which is about 20
pixels wide). I do this so that when the spreadsheet prints on one page the
type is not so small you I can't read it. Then I change the page setup to
landscape, legal, and fit 1o 1 page.
Is it even possible to make a macro to do this?
|
3/11/2010 9:08:06 PM
|
2
|
=?Utf-8?B?ZXhjZWxuZXdiaWU=?= <excelnew...@discussions.microsoft.com>
|
Need Help with Sumproduct
This formula works because I found it in this forum and have applied it. Now
I want to use it for 3 conditions, but my 3rd condition is also in the column
range of C3:C46, but the condition is H4.
=SUMPRODUCT(--($A$3:$A$46=F3),--($C$3:$C$46=H3),
--($C$3:$C$46=H4),$D$3:$D$46)
When I insert the additional c3:c46 into the formula, the result is $0,
instead of the sum I'm looking for. I need to keep these particular
conditions in col C.
Any suggestions on how to overcome this?
Thanks
|
3/11/2010 8:58:01 PM
|
2
|
=?Utf-8?B?SkhM?= <...@discussions.microsoft.com>
|
Consolidating Data between worksheets that removes dulicates
I am interested in tracking lab values that my staff enter into a daily
worksheet. I would like to compile monthly percentages (% low, % in range, %
high) but sometimes it is necessary to have duplicate data on consecutive
worksheets for my staff's workflow. These duplicate values will cause my
percentages (and absolute numbers) to be incorrect if I just sum between the
worksheets. Does anyone have a solution?
Thank you,
Jody
|
3/11/2010 8:47:01 PM
|
0
|
=?Utf-8?B?Sm9keVNtaXRoUGhhcm1E?= <JodySmithPha...@discussions.microsoft.com>
|
Scroll Bar Delay
I want to use a scroll bar to control which 18 months of data are viewable.
Right now I have an ActiveX scroll bar linked to a cell with the minimum
being 11 since the earliest data I want is 11/1/07. In the cell below that I
have the formula =DATE(2007,AB3,1), which gives me the starting reference
date. Back in Column C I put the formula =$AB$4 in cell C7 then below that
(and each subsequent row) =DATE(YEAR(C7),MONTH(C7)+1,1) for 18 months. Then
the 4 columns to the right of the date has the various information for that
month populated through a pivot table on another sheet usin
|
3/11/2010 8:42:05 PM
|
0
|
=?Utf-8?B?QnJpYW4=?= <Br...@discussions.microsoft.com>
|
Reduce balance
How can i get the cell with my balance owed to subtract what payment I made
on the next cell?
--
nat
|
3/11/2010 8:37:01 PM
|
2
|
=?Utf-8?B?bmF0?= <...@discussions.microsoft.com>
|
Pivot Table Variance
I have a pivot table that shows gross revenue by month. The months are the
column headers. Is it possible to create a field within the pivot table that
shows the variance between January and February's gross revenue? I don't
have access to the source data. Thanks,
Nate
XL2003
|
3/11/2010 8:30:01 PM
|
2
|
=?Utf-8?B?TmF0ZQ==?= <N...@discussions.microsoft.com>
|
FORMULA TROUBLE! PLEASE HELP!
Ok, i'm trying to create a formulas to calculate overtime hours for a
timesheet. 8 hours starts overtime so I have L11(total hours)-8/24. Now if my
total hours are over 8 this works perfect but if there not I get a result of
infinate #### and yes my column is wide enough! I have no idea what to do.
I'v tried everything from IF statments to conditional formatting, I can't
seem to figure this one out. Please help me or give me some ideas as to what
to try. Thank you.
|
3/11/2010 8:29:01 PM
|
3
|
=?Utf-8?B?QXNobGV5?= <Ash...@discussions.microsoft.com>
|
modify macro to include more tabs
Hi,
The macro below allows users to group/ungroup rows in a protected sheet. How
do I modify this macro to either incorporate more worksheets or apply it to
the entire workbook?
Thanks,
Charlie
Sub workbook_open()
With Worksheets("Sheet1")
.Protect Password:="password", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub
|
3/11/2010 8:23:02 PM
|
1
|
=?Utf-8?B?dGVoX2NodWNrc3Rh?= <tehchuck...@discussions.microsoft.com>
|
Microsoft Excel Merge Cells
Hey Guys,
I work for a Marketing company and every week i am inundated with data to
present in a clear and concise way to board members. I have cells that are
presented like this:
10 11 12 13 14
10 11 12 13 14
10 11 12 13 14
10 11 12 13 14
20 21 22 23 24
20 21 22 23 24
20 21 22 23 24
20 21 22 23 24
So what I have been doing is spending about 2hours a week merging cells. I
would highlight the four 10's and merge; highlight the four 11's and merge.
I want to know if there is a
|
3/11/2010 7:59:02 PM
|
1
|
=?Utf-8?B?TWFya2V0aW5nIEV4Y2VsLiAgTWVyZ2VyIG9mIENlbGxz?= <Marketing Excel. Merger of Ce...@discussi
|
Advanced Search Capability
Is there any code out there (add-ins, macros, etc.) to provide
advanced search capabilities in Excel (2000, or any other version)?
1. The ability to search backwards, or at least a command button to
go to the "previous hit" instead of the "next hit"?
2. The ability to use regular expressions or any sort of andvanced
search string (something better than just wild cards)?
3. The ability to process a list, and copy every row that meets the
search criteria to another worksheet, thus producing a condensed list
of the hits?
Have their been improvements in the search capability wi
|
3/11/2010 7:51:51 PM
|
3
|
Fred Holmes <...@his.com>
|
Automatically Update Excel Links
I have an Excel spreadsheet that resides in SharePoint. Every time the
spreadsheet is opened a message appears asking is links (within the
spreadsheet) should be updated.
Is there any way; using formulas, VB Code or some other magic :-) to have
the spreadsheet automatically update and to have it update every hour (or
other time period)?
Any help would be greatly appreciated!
Thanks in Advance
--
Rodman Veney
|
3/11/2010 7:30:01 PM
|
0
|
=?Utf-8?B?Um9kbWFu?= <Rod...@discussions.microsoft.com>
|
Conditional Formula based on previous date + 30
I have a spread sheet that caluclates when proposals expire.
Date Sent Follow Up date
January 13, 2010 February 12, 2010
What I am looking for is for the Follow up date to turn RED when the date is
expired (over the date listed).
|
3/11/2010 7:09:02 PM
|
1
|
=?Utf-8?B?Q2hyaXM=?= <Ch...@discussions.microsoft.com>
|
Help with cell reference
I need help with cell reference in cells. In cells A3:A21 I have a list of
store numbers and in cells Y3:Y21 I have scores. In cells D28:D32 I have the
top 5 stores scores. I have figured out to get the top 5 scores to populate
in cells D28:D32 by using the LARGE function =LARGE($Y$3:$Y$21,1). Now I need
the have the stores numbers to populate in cells C28:C32 next to the scores
in D28:D32. I have tried several formulas to get this to work with success.
VLOOKUP,INDEX/MATCH. I need some help and direction.
|
3/11/2010 6:38:01 PM
|
3
|
=?Utf-8?B?WVMxMTA3?= <YS1...@discussions.microsoft.com>
|
Tabbing between text boxes in Excel 2007
I have a spreadsheet that has multiple text boxes that I need to quickly type
info into and then tab to go to the next text box, this worked just fine in
2003 but since I changed to 2007 it does not allow me to tab between the text
boxes, any solutions? I would be happy to send someone an example of my
worksheet if that helps.
Thanks!
|
3/11/2010 6:28:01 PM
|
1
|
=?Utf-8?B?ZXN3YWNr?= <esw...@discussions.microsoft.com>
|
filter a list of numbers
I have a list of numbers (20000 to 27583)
I only want to see the info for the rows where the number ends with 0 (eg.
20000, 20010, 20020 etc. basically every 10th row)
When I custom filter for "ends with" 0, my whole list goes away.
|
3/11/2010 6:05:01 PM
|
5
|
=?Utf-8?B?T2xl?= <...@discussions.microsoft.com>
|
Sorting by Color in Excel 2003
I am not sure where this question belongs so I thought I would enter it under
general questions. I have a sheet with 3,245 rows. There are blocks of data
that are highlighted in yellow. The data in the row always starts in the A
column and ends in the F column. I need to sort the data so all of the yellow
blocks are together.
A1:F1 contain the tiles of my cells, then rows A2:F3 contain yellow filled
data then I have no colors until A30:F30 etc.... down to the end of the
sheet. I would like to have all of the yellow colored cells together.
I know Excel does not do this on its own
|
3/11/2010 6:03:02 PM
|
5
|
=?Utf-8?B?Sm9obg==?= <J...@discussions.microsoft.com>
|
Formula to add up numbers but there are negatives
Hi,
I want a formula that will just add up the total numbers and disregard the
negatives, is there a true value formula?
|
3/11/2010 5:55:01 PM
|
3
|
=?Utf-8?B?Tm9vZGxlbml4?= <Noodle...@discussions.microsoft.com>
|
AUTO FILL
If I type a value into cell 3H and I want that same value entered
automatically for me in cell 148T what formula would I use. This would make
my job a whole lot easier. Thanks
|
3/11/2010 5:46:02 PM
|
2
|
=?Utf-8?B?UGF1bA==?= <P...@discussions.microsoft.com>
|
Automatic update of links has been disabled - how do I get rid of
I thought I had removed all the links. Does this message when I open up Excel
(2003 and 2007) mean that there are still links in the document, or that
there were links previously...and now it's just going to show forever. Either
way, how do I get rid of it.
|
3/11/2010 5:42:03 PM
|
1
|
=?Utf-8?B?S2V2aW4=?= <Ke...@discussions.microsoft.com>
|
Excel 2007-macro enabled, multi-sheet opening in minimized mode
A spreadsheet that has 10+ worksheets is opening in minimized mode with only
the current worksheet appearing to be displayed. In order to see the other
tabs, the user needs to recognize that they are not in full screen mode. This
spreadsheet is being linked in a word document Appendix as support
documentation. The users click on the link and see one worksheet not
realizing that there are multiple sheets to review. How to get the
spreadsheet to open maximized with all worksheet tabs displaying? I have
gotten the spreadsheet to open correctly when not going throught the word
docu
|
3/11/2010 5:36:01 PM
|
0
|
=?Utf-8?B?TFQ=?= <...@discussions.microsoft.com>
|
Consider space in centering
In centered text, I'd like Excel to consider extra spaces on the left or
right. In text consisting of multiple lines, this would allow one line to be
forced off-center.
But Excel seems to ignore spaces in centering text. Is there any other way
to do this - possibly a character that Excel would consider in centering
text, but which is invisible on display. (Word can do this using a
non-breaking space.)
Any suggestions? Thanks.
|
3/11/2010 5:26:01 PM
|
1
|
=?Utf-8?B?RXJpY19OWQ==?= <Eri...@discussions.microsoft.com>
|
Macro in Excel
I am creating a macro, and need to select the next cell down after the
selected cell, and then to run the entire macro until the end of the data on
the sheet.
I am new, and would like very basic instructions, please.
Thanks, Cristina
|
3/11/2010 5:20:03 PM
|
2
|
=?Utf-8?B?Q2hyaXN0aW5h?= <Christ...@discussions.microsoft.com>
|
Excel character limitations
Hi
I'm trying to copy between 2 excel spreadsheets, when i do, the end column,
which contains more than 255 characters, has the end chopped off. How can i
increase the amount of characters that I can copy?
Any help would be appreciated.
Thanks!
|
3/11/2010 4:46:01 PM
|
1
|
=?Utf-8?B?ZW1tYXRlYWdsZQ==?= <emmatea...@discussions.microsoft.com>
|
Engine and Caboose
I use to use and Engine and Caboose set-up that rolled into a consolidated or
summary page. It has been a very long time since I didi this and I cannot
remeber the exact formula. Help!
Thanks!
Kurtis
|
3/11/2010 4:45:01 PM
|
0
|
=?Utf-8?B?RW5naW5lL0NhYm9vc2U=?= <Engine/Cabo...@discussions.microsoft.com>
|
Address of Freezepane
Hi all,
In VBA, is it possible to determine the address at which a sheet is locked?
I found a property activewindow.splithorizontal and splitvertical but they
give me double length integers. Anyone know how toconvert this int an
address?
Kind regards,
Bony
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."
|
3/11/2010 4:25:01 PM
|
2
|
=?Utf-8?B?Qm9ueSBQb255?= <bony_ponySPAMS...@BLOODYSPAMbtinternet.com>
|
Excel clicking selects multiple cells instead of a single cell
Excel clicking selects multiple cells instead of a single cell
|
3/11/2010 4:17:01 PM
|
2
|
=?Utf-8?B?dGV4bWFhbQ==?= <texm...@discussions.microsoft.com>
|
Macro to filter dates using Userform1 & printing
I have a speadsheet that has 5 columns.
(Headings are in row 2 and are: Cell A2=Date, B2=Name, C2=Paylist,
D2=Cycle, E2=Action).
Data starts in Row 3 and will go down to row 5000. The dates would
start 01-Jan-2011 and could go up to 31-Dec-2011.
Right now I have 2 macro's to sort by date and paylist but what I also
need is a macro to allow the user to sort by the user inputting a from
date (I think I can use a calendar to pick from) and a to date (option
of => and =<) in a form.
The next piece is how to display and be able to print this filtered
info.
I am not sure best optio
|
3/11/2010 4:05:00 PM
|
0
|
Mel <mel.pilg...@agr.gc.ca>
|
save a file with author's name
how do i save a file so that my name appears as the author in the file's
property?
thank you in advance for your help.
--
aprilshowers
|
3/11/2010 4:04:01 PM
|
1
|
=?Utf-8?B?YXByaWw=?= <ap...@discussions.microsoft.com>
|
Folder with largest number
Hello
Is it possible for Excel to filter through a set of folders/directories and
determine which one has the largest number and then open it?
thanks for any insight
|
3/11/2010 4:03:01 PM
|
1
|
=?Utf-8?B?U3RldmVabXluYW1l?= <SteveZmyn...@discussions.microsoft.com>
|
In Case You Didn't Notice - MS Released Patch RE:Excel
http://support.microsoft.com/kb/980150
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
|
3/11/2010 3:41:49 PM
|
5
|
"RagDyeR" <ragd...@cutoutmsn.com>
|
Compatibility Question
I have been writing macros and utilizing userforms in Excel to use at work.
I am doing this on my personal computer and I am about 95% complete. I was
using pre-MS Office 2007. Work also utilizes pre-MS Office 2007. However, I
have upgraded both my personal computers to MS Office Enterprise 2007.
I am not using any complex macros. Basically, simple calculations, Date &
Time commands, and cell references (Range, Offset, etc). I did notice with
one of my personal workbooks that the NAME for the cell I used, "APR09", had
to be changed to "_APR09" (without quotes), in the 200
|
3/11/2010 3:38:01 PM
|
3
|
=?Utf-8?B?V0xNUGlsb3Q=?= <WLMPi...@discussions.microsoft.com>
|
Comments Defaults
Hello i want to change the shape and font of Comments in Excel 2003 and then
apply this as the default to all Comments created thereafter. I thought I
just needed to right click on the comment and select Set Autoshape Defaults
but this does not work.
|
3/11/2010 3:35:01 PM
|
0
|
=?Utf-8?B?c2hheg==?= <s...@discussions.microsoft.com>
|
access & excel issue
i made a pivot off an access data base but the figures came up showing
zero "0", and i founf out that the reason this is so is because the
excel pivot is reading the figures as text and not number and i
checked the design view everythin is in order. was wondering how i can
rectify this.
|
3/11/2010 3:27:13 PM
|
0
|
memme <afrowo...@googlemail.com>
|
Using Regular expressions in Excell 2007
I have code written in excell 2003 where I use Regular Expressions
'heavily'. In Excell 2003 you had to import the RegExp library to be able to
use it. Is Regular Expressions part of VBA in Excell 2007? or do you still
need to import the RegExp library?
|
3/11/2010 3:25:01 PM
|
1
|
=?Utf-8?B?bmN1bmhh?= <ncu...@discussions.microsoft.com>
|
SUMIF???
I need a formula that will sum up columns N through W but only for rows where
column C = specific word AND F = specific word.
|
3/11/2010 2:57:02 PM
|
4
|
=?Utf-8?B?a2VyMTM3OA==?= <ker1...@discussions.microsoft.com>
|
Look up multiple values
I have a table where I want a value based on looking at data in two columns
as follows;
Table:
A B C
1 Bore Pressure Length
2 100 760 80
3 100 1050 100
4 100 1200 100
5 125 670 80
6 125 830 100
I want to find a value in column C, based on an exact value from column A
and when given a value for column B the value immediately above it. (e.g If
i had a bore of 100 and pressure of 900, I would want the value of 100 from
row 3)
Hope this explains it, i have tried SUMPRODUCT in various f
|
3/11/2010 2:54:03 PM
|
3
|
=?Utf-8?B?c3RyZXRjaA==?= <stre...@discussions.microsoft.com>
|
Importing Long Numbers as Text cells
I want to import a text file with some long numbers (16 characters and more).
Excel automatically converts them to floating point numbers which causes it
to lose some digits of precision. When I put quotes around the numbers excel
treats it as text but leaves the quotes around the number and removing the
quotes causes it to covert to floating point even if the format for the cell
is TEXT. If during the import I specify the columns as TEXT everything is
fine. However I need to do this for many files and many columns and I need
do the process many times on an on going basis. I
|
3/11/2010 2:46:01 PM
|
1
|
=?Utf-8?B?U3RldmU=?= <St...@discussions.microsoft.com>
|
How to mail merge multiple rows in one document
Hi,
I have a worksheet that lists subscribers of a service. It looks something
like this:
Organization Name Title Email
ACME CO. Smith, Sam CEO ssmith@acme.com
ACME CO. Jones, Bill Staff bjones@acme.com
Each organization has one president and multiple staff members listed
(between 1 and 5 staff members). I want to email each president, through mail
merge, and give them a list of all the current subscribers from their
organization (data from other rows in the worksheet).
Is this possible to do (using Office 2
|
3/11/2010 2:42:02 PM
|
0
|
=?Utf-8?B?S2F0ZQ==?= <K...@discussions.microsoft.com>
|
Counting of cells with a specific color filled
Hello experts,
I have an excel workhseet where different cells are filled with different
colors. I need to count no of cells in a specific column with a specific
colour filled. For example i need to count how many cells are filled with
green color and how many with red etc. What formula i should use?
Thanks in advance,
Atiq
|
3/11/2010 2:41:01 PM
|
8
|
=?Utf-8?B?QXRpcQ==?= <A...@discussions.microsoft.com>
|
Sort Window Size
My company recently upgraded to Windows7 and Office 2007. When I use the sort
command in Excel, the size of the sort window increases with each use of the
command. I have to grab the edge of the popup window and resize it in order
to see the work sheet. Is this a known problem with this software
combination, or an installation problem?
--
EWJJET
|
3/11/2010 2:33:06 PM
|
0
|
=?Utf-8?B?RVdKSkVU?= <EWJ...@discussions.microsoft.com>
|
Deleting Rows - only deletes content
Hello, one of our users has an excel document and would like to delete rows
(there are images contained withing some of the cells in each row). When he
right clicks on the row header and select's Delete or select's Delete >
Delete Sheet Rows in the Cells toolbar, only the content is deleted, not the
entire row. we would like to delete the row AND it's contents.
Four other users (including myself) are able to perform both functions to
achieve desired result, however when this one user delete's, it only delete's
the content.
I have an appointment with the user to fix in 2.5 h
|
3/11/2010 1:58:02 PM
|
1
|
=?Utf-8?B?UGhpbA==?= <P...@discussions.microsoft.com>
|
Excel 2003: Duplicate dashboard and data sheets
Hello,
I created a dashboard with several small graphs on it. The data for the
graphs is stored on a separate data sheet (i.e., work sheet). I now want to
duplicate the dashboard/data sheets to build a dashboard for another
employee. I envision the workbook eventually having 5 dashboards driven off
5 data sheets.
The trick I'm looking for is a way to change the datasource for the graphs
on the copied datasheet to the appropriate corresponding data sheet. I know
how to do it manually but it seems like there should be some sort of "find
and replace" type function fo
|
3/11/2010 1:44:05 PM
|
0
|
=?Utf-8?B?a2Fycmll?= <kar...@discussions.microsoft.com>
|
How to separate background highlight rows in another sheet
How to separate background highlight rows in another sheet
|
3/11/2010 1:40:05 PM
|
0
|
=?Utf-8?B?Um9oaW5pa3VtYXI=?= <Rohiniku...@discussions.microsoft.com>
|
Filter
Is there any way to link a filter to a sheet of data which is based on a data
validation cell/cells? (Instead of using VBA).
|
3/11/2010 1:19:01 PM
|
0
|
=?Utf-8?B?SlBEUw==?= <J...@discussions.microsoft.com>
|
Help Please with If statement / vlookup
How do I write an if statement if I only want to get the averages of the
first five cells with a value? I will need to look in about 10 cells, but
only avg the FIRST 5 with a value. Some will be blank and Some will be on a
different sheet
|
3/11/2010 12:05:01 PM
|
9
|
=?Utf-8?B?RG9ubmE=?= <Do...@discussions.microsoft.com>
|
xls data valadation question
i can create a list using the data validation btu would also like to be able
to type text in the same cell. is this possible?
|
3/11/2010 11:04:04 AM
|
2
|
=?Utf-8?B?dA==?= <...@discussions.microsoft.com>
|
Time entry in w/sheet
I have a shared w/sheet that requires inputters to make a time entry of time
spent on a task.
Times can range from a matter of minutes to a couple of hours.
I'm Ok with formatting cells to time but what I want to do is ensure that
they correctly enter the time as say, 1:20 for 1 hour 20 mins which gives
01:20:00. Using data validation, I can ensure they do not input as 1.2 but
when the time is less than an hour, say 25 mins and it is wrongly entered .25
or 0.25 it does not prompt the inputter re incorrect input (0:25) and the
entry becomes 06:00:00.
Assistance would be much
|
3/11/2010 11:04:01 AM
|
3
|
=?Utf-8?B?UnVzc2VsbCBEYXdzb24=?= <russell.daw...@discussions.microsoft.com>
|
How to print the background?
Any simple way to have the background picture be also printed rather than
being only displayed on the screen.
--
Thanx & Best Regards,
Faraz!
|
3/11/2010 10:47:01 AM
|
1
|
=?Utf-8?B?RmFyYXogQWhtZWQgUXVyZXNoaQ==?= <FarazAhmedQure...@discussions.microsoft.com>
|
Collect data from spesific cell in multiple sheets
How can I collect data from cell A1 on sheet 01.01 thru 31.12 (Dates) to
summary sheet?
I've tried fill and copy formula with different use of ! and $ but I've not
been able to solve this by my self.
Thank you
|
3/11/2010 10:29:01 AM
|
3
|
=?Utf-8?B?RXNwZW4gUm9zdGFk?= <EspenRos...@discussions.microsoft.com>
|
Excel is defaulting to Number format instead of General format
The programme for 2007 has recently been installed, and my cells are all
formated to Number instead of General, and Excel won't let me change it back
to General. We tried to uninstall and re-install but this did not help.
|
3/11/2010 10:11:01 AM
|
1
|
=?Utf-8?B?S2lt?= <...@discussions.microsoft.com>
|
Can I read a range of scenario (input) values from a table?
When creating several scenarios (to ultimately get a scenario summary), it's
laborious typing in a scenario name followed by a scenario value for each
scenario. Is there any way of setting up a table of (names and) input values
and just reading them into the scenario manager?
|
3/11/2010 9:31:01 AM
|
0
|
=?Utf-8?B?aGlsdG9u?= <hil...@discussions.microsoft.com>
|
Printing With XxcelViewer
I download and install ExcelViewer, but when i try to print a file (without
open it), it always ask me to choose what file that wants to print.
is there any workaround ?
|
3/11/2010 9:23:01 AM
|
0
|
=?Utf-8?B?QW5keSBTdXNhbnRv?= <Andy Susa...@discussions.microsoft.com>
|
calendar
Is it possible drop down the calendar when click the specified cell
That help to select dd/mm/yyyy then the calendar will hide
|
3/11/2010 7:31:01 AM
|
2
|
=?Utf-8?B?YmFzaGFy?= <bas...@discussions.microsoft.com>
|
Extra characters appear in the formula bar but not in the cell
Extra characters appear in the formula bar but not in the cell not resolved
by excel help solution
|
3/11/2010 6:34:12 AM
|
1
|
=?Utf-8?B?c2Fuaml2?= <san...@discussions.microsoft.com>
|
Primary and Secondary tech locator
Hi, I use a 3rd party excel plug in called Spheresoft that I use to calculate
distance in zip codes. My question is really a function of excel and not the
tool itself.
In short I have in Sheet1 a list of sites: address, city, state, zip etc.
I have a sheet called techs that list all the name and addresses of my techs.
Basically it looks at the zip code from sheet one and picks the one with the
lowest distance value. Works great.
However..
It would be great if i could have column c be the second closest tech.
Is there a way to have it exclude the tech from column b (which is the
|
3/11/2010 3:07:01 AM
|
1
|
=?Utf-8?B?Q3JhaWc4NjA=?= <Craig...@discussions.microsoft.com>
|
stop sorting titles please
I have an excel document with 35000 rows and 125 columns of information. I
am sorting in almost every title column in multiple formats. is there a way
to sort these with out always having to notify the sort I have headers?
I want to click AtoZ or ZtoA and just go with out taking all the extra steps
to manage the headers.
|
3/11/2010 2:26:01 AM
|
3
|
=?Utf-8?B?Q0M=?= <...@discussions.microsoft.com>
|
Excel
I have a price list done in Excel and I want to increase all prices by 5
or10%. I know there's an easy way to do this but I can't remember how to do
it. Can someone please help.
|
3/11/2010 2:20:04 AM
|
2
|
=?Utf-8?B?UHJpbnR3b3Jrcw==?= <Printwo...@discussions.microsoft.com>
|
Considering upgrade office 2000 to 2007
I just upgraded kicking and screaming to Windows 7 (love it) and am
considering an upgrade to Office 2007. I use Excel extensively and my 2 main
files are around 20meg each with a large number of quite complex macros.
Any advisory comments would be appreciated, and I'm particularly wondering
about forward compatibility and whether my Excel 2000 macros are likely to
fall over under 2007.
(Also, I'm wondering if the facility has yet been built in to cells to
instruct the cursor on entering to then move to a designated cell?)
|
3/11/2010 1:49:01 AM
|
7
|
=?Utf-8?B?S2V2cnls?= <Kev...@discussions.microsoft.com>
|
Cannot copy & past beween workbooks
Hi,
I have two workbooks open in the same Excel instance, but cannot copy and
paste. The paste and paste special option is grayed out in the second
workbook. Thank you for your help.
|
3/11/2010 1:21:01 AM
|
1
|
=?Utf-8?B?TEw=?= <...@discussions.microsoft.com>
|
Edit formula while entering Excel 2000
Is there a way, such as a key combination of enabling the cursor to navigate
a formula or line of data while composing it, before its actually entered,
and without going to the formula bar to do it?
Yeah....I know its niggly, but its niggled me for a long time :-)
|
3/11/2010 12:38:01 AM
|
5
|
=?Utf-8?B?S2V2cnls?= <Kev...@discussions.microsoft.com>
|
VLookup Function over Multiple Worksheets
I am trying to use the VLOOKUP function over multiple worksheets, can this be
done on Excel 2003?
I am trying to automatically retrieve data that is dependent on previously
entered fields in drop down lists that I have created.
Regards,
|
3/11/2010 12:33:01 AM
|
2
|
=?Utf-8?B?Y3A0MDI=?= <cp...@discussions.microsoft.com>
|
drops leading zeros on SAP download
Downloading from SAP to Excel 2003, only dollars were treated as numbers,
other fields were Text. Excel 2007, all fields that appear to be numbers are
treated as numbers and any leading zeros are dropped. Is there a solution
other than to customize every column/field.
|
3/11/2010 12:04:01 AM
|
0
|
=?Utf-8?B?Skw=?= <...@discussions.microsoft.com>
|
How do i find my post from a few weeks ago
How do i find my post from a few weeks ago?
|
3/10/2010 10:37:02 PM
|
5
|
=?Utf-8?B?UmF0Ym95?= <Rat...@discussions.microsoft.com>
|
Macro for Copying with conditions
Hi,
I have almost not much knowledge of making macros except for simple ones.
here is my question
I the sample data below need to copy "SystemA" in the cells below when it
find something written in column B and C and stop at Total in column C after
copying there also and goes down and does the same thing for the next block.
Any help will be appreciated
Thanks
MH
A B C
SystemA
CIVIL
PIPING
CABLE
Total:
SystemB
CIVIL
PIPING
CABLE
TERMINATION
Total:
--
MH
|
3/10/2010 10:32:01 PM
|
0
|
=?Utf-8?B?TUg=?= <...@discussions.microsoft.com>
|
Notification to my email address
I have set up my profile to receive notifications via email. I believe that
it is set up properly and I performed the verification steps and received
positive response. Still I am not getting any notifications.
What can I do to start getting notifications? Who can I contact?
Tom
|
3/10/2010 10:22:01 PM
|
3
|
=?Utf-8?B?dG9tcGw=?= <to...@discussions.microsoft.com>
|
Auto Filter
When I use Auto Filter and select the criteria I want to filter by and then
go back to select all criteria certain rows are hidden, it does show all
rows. Anyone know why?
|
3/10/2010 10:10:01 PM
|
3
|
=?Utf-8?B?R1Y=?= <...@discussions.microsoft.com>
|
Conditional Comment using Cell value as part of it
What I'm trying to do is the following:
if cell(a1) is different from 0(zero) then, cell(b1) should have a comment
that say, the value of cell(c1) is the payment, next line the value of
cell(a1) was refund, next line Total for today = cell(c1)-cell(a1)
Example
a1 = $10.00
c1 = $30.00
B1 (comment):
$30.00 is the payment (c1)
$10.00 was refund (a1)
Total for today: $20.00 (c1-a1)
can anyone help me on that?
thanks in advance
|
3/10/2010 9:46:01 PM
|
0
|
=?Utf-8?B?QWxmcmVkbw==?= <Alfr...@discussions.microsoft.com>
|
select From dropdown and return another dropdown menu
Hi,
i am looking for help with dropdowns and returns. I would like to b able to
have staff select their business area from a dropdown menu, when a business
area is selected i would like it to then offer the corresponding cost codes
for that business area as a dropdown and those cost codes be available for
selection.
Is it possible?
many thanks in anticipation.
Nigel
|
3/10/2010 9:40:10 PM
|
2
|
=?Utf-8?B?UkU0Mzc5?= <RE4...@discussions.microsoft.com>
|
Updating Excel Spreadsheet
I have 3 users that use the same spreadsheet, is there a way of automatically
updating the spreadsheet of one user with newer information input by another
user.
|
3/10/2010 9:24:10 PM
|
0
|
=?Utf-8?B?am9lc3c=?= <jo...@discussions.microsoft.com>
|
Why is default Vertical Cell Alignment "bottom?"
There is a ton out there on how to change the vertical cell alginment default
"bottom" but there is not one explanation as to why "bottom" is the default
to begin with?? I would really like to know if there is a reason why the
default is not "top?"
Thanks.
|
3/10/2010 9:08:07 PM
|
4
|
=?Utf-8?B?TGF5YQ==?= <L...@discussions.microsoft.com>
|
Insert row(s) with vba
I'd appreciate some help to determine if I'm attempting the impossible...
We have a workbook to generate proposals. Each proposal contains numerous
sections. Each section has many line items. The first item in section 1 is
numbered 01-001, the next 01-002 etc. The 01 is the section number, the 001
is the item number. Iuse the formula:-
=CONCATENATE((TEXT($A$2,"00")),"-",(TEXT((RIGHT(OFFSET(A5,-1,0),3)+1),"000")))
to automatically generate the item number row by row. The value in $A$2 is
the section number. This way I can use vba to insert a row and the numbers
look after themsel
|
3/10/2010 9:02:06 PM
|
3
|
=?Utf-8?B?QW5keSBCYWlsZXk=?= <AndyBai...@discussions.microsoft.com>
|
Excel 2007 changes links in cells
Hello guys,
when I enter link to TXT file in the cell (e.g.
D:\aa\ss\ko-hs-048-332-09\11ss.txt), for some reason it changes to
C:\Users\Eddie\AppData\Roaming\Microsoft\Excel\ko-hs-048-332-09\11ss.txt
after some time.
It seems to me it's something like Temporary Internet Files in IE...
Any ideas how to keep the original link assuming that I haven't changed the
location of the file?
Thanks, Milan
--
Milan Bortel
MCP, MCAS, MCTS
GOPAS Computer Training Center
Brno, Czech Republic
|
3/10/2010 9:00:01 PM
|
1
|
=?Utf-8?B?TWlsYW4gQm9ydGVs?= <MilanBor...@discussions.microsoft.com>
|
Ranking Top 5 in score and percentage
I have read many postings on ranking and they don't seem to make sense to me,
that is why I supppose I am here. :) I need a formula that will sort store
rankings based on the highest average score and the highest plus "plus/minus
score". Here is some of the information:
Column A3:A21 is the store numbers
Cloumn X3:X21 is last week average (percentages)
Column Y3:Y21 is this week average (percentages)
Column Z3:Z21 is plus or minus vs last week average (percentages)
Now in column C28, which is rank 1, I want the store number (A3:A21) to show
up in C28 based on it having the Hig
|
3/10/2010 8:49:01 PM
|
1
|
=?Utf-8?B?WVMxMTA3?= <YS1...@discussions.microsoft.com>
|
get rid of drop down boxes in excel 2007
We have a spreadsheet that we sorted some of the inner rows. But now there
are drop down boxes on the first row of the data. How do we get rid of these
boxes?? They don't show on the print prieview, but we don't want them to
show at all. Thanks for any light you can shed on this---I KNOW one of you
can help!
|
3/10/2010 8:16:03 PM
|
6
|
=?Utf-8?B?Qm9ucw==?= <B...@discussions.microsoft.com>
|
number format
I have a large column of numbers, they all need to be 10 digits long. If
they are less than 10 digits I need to proceed the number with zero's until
each number is 10 digits.
3418
3909867750
3916717360
21972
9064130
4106431176
3919306948
9092768
24976
28241
3914169069
539
7187
29132
3919530745
3908063591
22210
3911589814
28357
3915302636
--
Randy
|
3/10/2010 8:13:02 PM
|
2
|
=?Utf-8?B?UmFuZHk=?= <Ra...@discussions.microsoft.com>
|
How do I merge an excel worksheet into tables in word
How do I mergen an excel worksheet into tables in word and keep specific
records on the same page
|
3/10/2010 8:13:01 PM
|
1
|
=?Utf-8?B?dGVlbmllYm9w?= <teenie...@discussions.microsoft.com>
|
Get #### when typing
When typing a lengthy statement in a cell I get ######. Is there a character
limitation in Excel 2007 and is there a work around to this?
Thank you
Bill
|
3/10/2010 8:08:05 PM
|
2
|
=?Utf-8?B?QmlsbA==?= <B...@discussions.microsoft.com>
|
how do I clear a dialog box in Excel that is not a comment?
I have a dialog box that pops up when I click in a cell, but it is not a
comment. How do I change or clear this?
Thanks in advance for your help!
|
3/10/2010 8:04:05 PM
|
0
|
=?Utf-8?B?QnJlbmRh?= <Bre...@discussions.microsoft.com>
|
Matching records in two lists
I have a list of part numbers in one range (list) on a worksheet with the
description in another columns. In a seprate range (list) on the same
worksheet, I want to see if there are any matches in the part number column.
How is this done?
|
3/10/2010 7:53:01 PM
|
2
|
=?Utf-8?B?SmFtaWU=?= <Ja...@discussions.microsoft.com>
|