|
Cell Comments
First off, I inherited a PC at my new company and the old users name
appears in the new comment field, how can I change it to mine.
Second, how can I change the default font and appearance of new
comments.
Thanks, Mark
...
|
3 |
23.08.2006 16:22:58 |
|
|
Field control
Hello!
I have set up an emailable spreadsheet that acts as a form. This "form"
is sent to myself to consolidate the data. Would it be possible for
this form to stop the macro (and subsequently not being emailed) until
certain "compulsary" fields are filled in by the user?
Thanks in advance.
CorreoMaster
...
|
2 |
23.08.2006 16:18:52 |
|
|
Word Wrap hiding text
Has anyone experienced word wrap in excel hiding all text. It has come
on all of a sudden and is causing problems with every excel file I
open. I have seen other posts here but no resolution.
Thanks
Matt
...
|
2 |
23.08.2006 15:37:02 |
|
|
Doing A Cut And Paste Problem ?
Hello:
Using Excel 97.
I know it's real old, but it has always done whatever i wanted.
Worked previously if I remember correctly (don't use very often), but won't
do a Cut and Paste anymore, apparently.
I must be doing something wrong, or have some option set that I'm not aware
of, but can't imagine what.
I'm cutting two columns by 15 rows deep.
I try pasting it into an identic...
|
2 |
23.08.2006 14:56:18 |
|
|
Linking userforms to Excell Worksheet
Hi
I have created a userform with textboxes, radio buttons, check boxes etc.
When a user opens the user form and fills it out i want the data to be
entered in to certain columns in the excell worksheet.
Any help would be highly appreciated.
Regards
shiv
...
|
2 |
23.08.2006 14:55:19 |
|
|
plot graph from multiple worksheet as embedded chart object on every worksheet
Hi i want to plot the graph for every worksheet (column B and column
D). I have more than 50 worksheets in the same workbook. How do i write
a macro to ask the excel to plot the graph for every sheet and present
the chart object on the same sheet? thank you very much for your help!
i have been working on this over 2 days still cannot figure it out...
...
|
1 |
23.08.2006 12:53:31 |
|
|
How will I do this...Help me Please..
Help me with this.. I dont really have that much knowledge about
excel...
I have a Record a Record that is in the Pivot table like this:
Item Code Serial
----------------------------------
Ques | 23120 | 00112255
| | 00112233
what i want to do is I want to inform the user that
one "Code" has multiple "Serial"... how will...
|
2 |
23.08.2006 08:50:51 |
|
|
Using a cell reference in a connection string
Hi all
I am using excel as a frontend reporting tool to display some performance
data that is held in a sql database. This spreadsheet and the database
behind it will be altered over time as we incorporate new data into it. I
will be doing these changes on our test environment first before moving it
to live. Because i will be altering the test version of the spreadsheet i
dont want...
|
2 |
23.08.2006 08:44:53 |
|
|
Statistical Analysis - Sampling
I wish to run a random sample of 60 numbers from a population of 75 numbers
without repeating any number more than once. The data analysis - sampling
tool generates the 60 random numbers but duplicates several numbers....
|
3 |
23.08.2006 07:14:07 |
|
|
Re: Help with Data Validation Lists
Hi
I want to data validate two lists where the value choices are the same.
Each list takes its data validation choices from a defined range.
However, when a user selects a value from the first list, the
corresponding value on the 2nd list will not have the value the user
just selected.
Thus, when user selects A on List A, the dropdown box for List should
only contain the choices which he di...
|
2 |
23.08.2006 03:24:44 |
|
|
Search Column for value in Cell & Replace
I'm sure this is very easy to do, but I'm having a lot of trouble
figuring out how to do it.
How do I search a column for the value in a particular cell, and then
insert the value into the current cell if found?
<table>
<tr>
A B C
<tr>1 jim james doesn't know what hes doing
<tr>2 james monk...
|
6 |
23.08.2006 02:53:02 |
|
|
can anyone help me with this??
hello all.
I am hoping that someone in this vast pool of Excel knowledge might be able
to help me with this problem.
This list shown below in blue....
10/04/06 10/05/06 108 757 ANC-NRT 1600 2325 ..WR...
07/06/06 09/29/06 108 757 ANC-NRT 1600 2325 ...RF..
07/01/06 10/21/06 108 757 ANC-NRT 1700 0025 .....S.
08/22/06 @...
|
3 |
23.08.2006 01:59:42 |
|
|
Hot News
Buy 'Xanax' (http://medicinese.info/?q=xanax) Online, No Prescription
Required
Overnight Shipping. Based in the USA for Quality and Safety. No prior
prescription required.
'Phentermine' (http://medicinese.info/?q=phentermine)
You save now! We sell all meds at cost. US licensed pharmacy.
Cost plus processing fee. Free Overnight FedEx. Secure
--
neabyzteplz
-------------------------------...
|
1 |
23.08.2006 01:45:27 |
|
|
Phentermine - USA Pill Inc. - Phentermine - Lowest Prices
Buy PHENTERMINE online. PHENTERMINE - Order BRANDS and GENERICS Online !
Only highest quality in online pharmacies. Phentermine, HUGE
DISCOUNTS!!! PHENTERMINE - Order BRANDS and GENERICS Online
'phentermine' (http://phentermine-br2.blogspot.com)
--
2korgnoise
------------------------------------------------------------------------
2korgnoise's Profile: http://www.excelforum.com/member.php?act...
|
1 |
23.08.2006 00:13:58 |
|
|
AutoShapes default to "no line"...
When I use the arrow tool (or any other AutoShape) to draw, it always
defaults the "line color" to the "no line" setting. If I have the
object selected, I can then change it to black (or default) but the
setting does not stick when I draw another arrow.
I have *a lot* of arrows, lines, and boxes to draw and would like to
find a fix, rather than changing the setting each time or using
copy-p...
|
4 |
22.08.2006 23:55:57 |
|
|
Count Issues
I have two columns, Date and Location. In location, there are 4
different possibilities, lets say Alpha, Bravo, Charlie, Delta. Here is
a small example of my data.
_Date--------------Location_
1/2/06------------Alpha
2/2/06------------Bravo
2/4/06------------Charlie
In reality, I have numerous dates with these four locations. I am
trying to track the total number of times a particular ...
|
4 |
22.08.2006 23:13:20 |
|
|
Validating sum of 2 cells, same row
Hi-
I have created a row with 2 categories and 2 numerical selection lists.
The numerical selection list represents a % allocation and goes from
0-100 in increments of 5 and the goal is to apply a percent of time
spent on activities in each category. The sum of the two %allocation
cells should equal 100 - is there a way to confirm/validate this before
the user leaves the row??
eg
Row 1 ...
|
3 |
22.08.2006 22:10:56 |
|
|
Multiple Instances of Excel
I am getting annoyed by not being able to have multiple instances of
Excel (being able to view two Excel workbooks at the same time. I have
dual monitors and right now I'm stuck on one screen with this other
beautiful screen going to waste. Anyone know of a way to allow me to
have multiple workbooks open and on different screens? I've had this
happen before, but I have no idea how I did it, i...
|
3 |
22.08.2006 21:20:02 |
|
|
add blank space in cell if first name is not blank
XL 2002 SP3
Win XP HE
Follow-up to: microsoft.public.excel.worksheet.functions
I have a list of names organized in table form.
I need to add a column with the field "blank" so that I can add a blank
space (which will serve as a separator between 1st and last name in a
different program) IF first name is not blank i.e. contains text.
the field in cells of column "blank" will either c...
|
4 |
22.08.2006 20:37:15 |
|
|
HELP NEEDED...Hyperlink printing
Hi There
I NEED HELP:
I have a over 3000 hyperlinks that are stored in fields (A1 to A500,B1
to B500 and so on). I want to automate a hard copy print run and PDF
print run.
Manually repeating clicking on the link, followed Ctrl+P in IE and then
clicking print again 3000+ each times will take an age and give anyone
repetitive strain injury!
I have looked at http://www.ureader.com/me...
|
1 |
22.08.2006 20:23:31 |
|
|
populating sheets
i've got a ton of data on sheet 1 that is my "running" database
(periodically updated). i want to keep that as my master sheet but have
second and third sheets pull certain lines out.
for example.
sheet 1 has 8 colums of data. if cell b2 has a date (non-specific) in
it i want all of row 2 to populate a row in sheet two. if cell b3 does
not have a date i want that row to populate a row in s...
|
1 |
22.08.2006 20:01:57 |
|
|
Find a specific string in a cell
I would like to search all the cells that are not empty in column E for
the words Account and New. If the cell does not have either of those
words in it, I would like to delete that entire row, go to the next
cell in column E and repeat this action until I arrive at an empty
cell.
Please help
LP
...
|
9 |
22.08.2006 19:46:09 |
|
|
Sorting data held across different rows but in same column
Hi
I have some data that contains the results of an online user survey.
The survey consisted of a series of multiple choice questions. The
answers were logged in a database and have been given to me as an Excel
sheet.
The data is as follows
Col 1: User ID
Col 2: Responses
So some sample data would look like this:
131 Yes
131 Maybe
131 No
131 Yes
132 No
132...
|
2 |
22.08.2006 19:41:42 |
|
|
Prevent deletion of Excel File
Is there any way to prevent deletion of an Excel file through Microsoft
Explorer. The file is stored on a local drive.
...
|
3 |
22.08.2006 19:10:24 |
|
|
Only allow one user at a time
We have an Excel spreadsheet that sits on the network.
People need to open the file to be able to sign up for various duty rosters.
We would like for the file to open for the first person.
And then for any others after that, get a message that the file is in use
WITHOUT the option to open a read-only copy.
Our staff can't read and they keep opening additional copies of the file!
I have read...
|
8 |
22.08.2006 17:33:06 |