Count Problem- cells with diagonal line
Hi
I'm trying to count all cells in a range that have a diagonal lin
accross the cell but so far no luck! :confused:
Background:
The Worksheet is an audit schedule and when an audit is completed
diagonal (xldiagonalup) line is placed in the cell, for reporting I'
like to obtain the total number of cells with the line.
Would be sooooo grateful for a reply, I'm starting to loose the wil
the live!!!!!
Thanks to anyone who has taken the time to read this....
Ada
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 35021
conditional formatting #value!
Hi
Is it possible to create a conditional formatting condition that
can detect the condition of #VALUE! ? That is NOT the text string but
the "error condition". What I am trying to highlight is that certain
calculated values have not been correctly calculated on the sheet and
need further investigation.
Thanks
Clive Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 35018
Total Possible Outcomes!
This one has got me stumped, and I am pretty good normally with Excel!
There are 5 catagory's going horiz: [GARMENT, MANUFACTORER, SIZE, COLOUR
1, COLOUR 2]
6 rows of data under each catagory, e.g [GARMENT = shirt, shorts, polo,
socks, jacket, vest] [ SIZE = XS, SM, MD, LG, XL, XX] etc etc
I need to return a list all the possible outcomes from the rows of data.
There must be a way of excel doing this for you? Anyone have any clues?
Thanks for you time
Mike
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum *** Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 35013
Test for entries
Hello all
The following macro is the final part of a routine that will creates a
chart.
What code would I need to insert that would test the activecell for
entries and if none print a message like "No data to Chart".
Thanks for any help.
Sammy
Sub MakeChart
Sheets("Build Chart").Select
ActiveCell.CurrentRegion.Select
Charts.Add
ActiveChart.ChartType = xlColumnClustered
On Error Resume Next
ActiveChart.SeriesCollection(1).Name = "=""Forecast"""
ActiveChart.SeriesCollection(2).Name = "=""Returned"""
ActiveChart.Location Where:=xlLocationAsObject, Name:="Chart"
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "2003/4"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text =
"Categories"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Hours"
End With
ActiveChart.ApplyDataLabels Type:=xlDataLabelsShowValue,
LegendKey:=False
ActiveChart.HasDataTable = True
ActiveChart.DataTable.ShowLegendKey = True
Call CoverRangeWithAChart
End Sub Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 35011
How can we get the subtraction of values in first 2 columns in the 3rd column
Hi Friends
Greetings. If I have the following 500 row excel file, how can we get the
subtraction of first two columns(Col3)?. I couldn't find any subtraction
function in microsoft excel 2000.
Col1 Col2 Col3(I want the subtraction of Col1-Col2)
------ -------- ----------
$50 $30 ??(I want $20 here)
$100 $40 ??(I want $60 here)
$150 $25 ??(I want $125 here)
--- ---- ---
--- ---- ---
Thank you
Jane Humbrey Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34997
Re: Saving Excel Spreadsheets causes user to go offline.
This has been baffling me for weeks, and I've finally given up.
One of our users is on a laptop with her My Documents folder synche
with a network drive. Whenever she saves one of these Excel files t
this network drive, it cause the connection to the server to dro
momentarily causing the "Offline Files" icon to appear in the taskbar
If you wait a minute, you can click OK on the offline files dialog an
it will synch with the server.
But here's the strangest part of this whole thing, it doesn't happe
with all spreadsheets. It only happens with spreadsheets with formula
in them. I'm totally stumped. She had been using Office XP, but
upgraded it to 2003 in hopes it might remedy the problem. Unfortunatel
it's still happening the same way.
Any comments would be helpful. Thanks
-
colforbin1
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message608825.htm Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34996
Use Quotes in Concatenate
I searched but could not find the answer then Boom I stumbled upon it o
my own. Anyway here it is:
To use Quotes in a CONCATENATE formula use two quotes next to eac
other. I am sure most here knew that but I have been using Excel for
looooong time and never knew that since I never needed to know it :)
Example:
Combine Cell A1 and Cell B1 and Quotes
A1=Blah B1=hlaB
=CONCATENATE("""",A1,""",",B1)
Results:
"Blah",hlaB
Anyway this is in case someone does a search for something like thi
:)
--------------------
Tazde
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34995
Fax Line utilization with Start and END time data
I have large list from our fax servers that produces a lof with :
Start of FAX Connect date/time, End of Fax Connect date/time
I know I have 24 lines but need to find how many lines have I bee
using historicaly to do capacity planning.
Any suggestions?
M
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34994
help excel freezing up
my excel 2003 keeps freezing when try to scroll or move my mouse over the
worksheet.
--
Mark Anthony Stephenson Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34991
treat as text
hi, i have two questions.
1) there is something you can select in excel so that when you writ
really long numbers it treats it as text and doesn't truncate it or pu
it scientific notation. I was wondering what exactly the menu was an
what needed to be selected. I'm using office 97
2) i have a text file that when i convert to csv and open it up, som
of the information is missing. Espeacially if it seems to begin with
1 or a 0. I'm just wondering how this can be avoided since excel i
what is reading the csv file. Thank you very much.
this problem is really frustrasting me
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34986
file and folder help. Please :)
Hi I have a list of files in an excel sheet in the first column I would like
to know is there a way I can get excel to search for these files by giving
it a dirctory and then it would copy the files to a directory I set, so say
I have the following in an excel document
15632.dxf
55555.dxf
95854.dxf
now they are under directory X
and the directory I want them to be copier to is XX
is there a way to do this, I would appreciate any help
Thanks.
Ali Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34971
Opening Workbooks
When I open up many separate excel files, the files all open up in th
same excel workbook.
How can I have the files open up in separate workbooks on my toolbar a
the bottom instead of always having to go to window and choosing th
next file I want to view?
I would rather click on the windows tool bar at the bottom.
Thanks for your help
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34968
Word Mail Merge with Excel Data--Missing Data
I have created a mail merge document in Word2002, using Excel2002 for m
data source. When I merge the document, some of my fields hav
incomplete data. The only records affected are those where the dat
from the Excel fields is fairly long. Only about 200 characters wil
show up on the Word doc. I am not exceeding any limits in my Exce
fields. I've tried everything I know to do, but can't get this one t
budge. Any suggestions are welcome
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34965
Drop down box values
I've been given this task to do in Excel and I need help.
I have a column/list in worksheet2. The list is indexed and must stay intact
as many cells in the workbook use this list.
Lets say in this column I have the following information:
Absorp
ABSC0112
ABSC0129
ABSC0148
Cen
CVAE 18
CVAE 19
CVAE 21
Wate
GEVA 1/2 - 2 1/2
GEVA 3 -5
GEHA 1/2 - 2 1/2
GEHA 3 -5
Now I want to add two drop down boxes on another worksheet. Drop down box 1
would have the values:
Absorp
Cen
Wate
The list in Drop down box 2 would be dependent on what value is selected in
drop down box 1 so if Absorp is selected in drop down box1 then ABSC0112,
ABSC0129 and ABSC0148 would display in drop down box 2.
Any ideas on how to do this?
Thanks in advance. Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34964
Numeric Overflow Error
I have an Access Database linked to an Excel Worksheet. In my attempt
to massage the data, I changed their refernces from Right 2 character
to DatePart. Now I consistently am getting a Numeric Overflow error?
Can someone explain this
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34955
Global Variables losing scope in Excel when developing
This is a multi-part message in MIME format.
------=_NextPart_000_000C_01C42C80.D0AD9790
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a vba module inside an Excel add-in with a global variable =
pointing to a class in an external dll, in the form
Public MyVar as new MyLibrary.MyClass
The problem is that when I am developing and testing the add-in, the =
variable loses scope (not initialize). I have to close everything and =
restart Excel. Then all is OK.
Any suggestion?
PD. If a declare the variable without "new", where is the best place to =
initialize it?
Thanks in advance
------=_NextPart_000_000C_01C42C80.D0AD9790
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I have a vba module inside an Excel =
add-in with a=20
global variable pointing to a class in an external dll, in the =
form</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Public MyVar as new =
MyLibrary.MyClass</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The problem is that when I am =
developing and=20
testing the add-in, the variable loses scope (not initialize). I have to =
close=20
everything and restart Excel. Then all is OK.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestion?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>PD. If a declare the variable without =
"new", where=20
is the best place to initialize it?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in =
advance</FONT></DIV></BODY></HTML>
------=_NextPart_000_000C_01C42C80.D0AD9790-- Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34951
match record field
I have a simple excel table where 5 users enter records on the same
spreadsheet throughout the week. In one of the fields (columns) the user
will enter his name to identify who the record belongs to, and in another
field is the date that record was entered. I end up with a table like the
following:
name entry_date
Joe 04/16/04
Bill 04/17/04
Joe 04/18/04
Bill 04/19/04
Joe 04/20/04
Ed 04/21/04
My problem: In another cell on another worksheet I would like to return the
latest entry date for a particular user as such:
Joe 04/20/04
I can't seem to use index(), match(), or max() functions to do the job. I
have used the formula array {=MAX((E2:E19=A4)*(F2:F19))} but I can't get
that to work for an entire column - only for a defined array.
Any suggestions?
Thanks,
Gary Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34950
Text formatting
Hi gurus...
I would like to run it by you, experts... Here is the problem: I woul like
to build a macro that format the text so that the first letter of each word
is a capital...
For Instance a1= "perform backup"
I would like the macro to transform the entry in a1= "Perform Backup"... Can
someone provide guidance as to what the macro should look like or what
function to use?
Many thanks from Brew City
Michel Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34947
Format Painter keyboard shortcut?
Hello,
Does anybody know the keyboard shortcut for Format Painter?
Thanks,
Dave Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34946
Can a workbook be used as a function
Hi,
I have an excel workbook (A) that givern three parameters, temp1, temp
and flow calculates the energy transfer for a process we conduct,
have another workbook (B) which contains the hourly logged data for th
process from which we generate monthly reports.
Is it possible to use workbook (A) like a function and pass to it th
three parameters from workbook (B) and return to workbook (B) th
answer ie. energy transfered.
Workbook (B) contain approx 750 logs so i need to repeat th
calculation 750 times
I could link the two which works for the first piece of logged data bu
how to automatically change the links for the next 749 ??
alternatively make workbook (A) a function and call it 750 time - ho
??
Any suggestions !!
D
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34945
Detecting Screen res
Is there a way Excel can auto detect the screen res of a VDU an
automatically resize thing like msg boxes so that text is centred o
both big and small screen resolutions rather than ending with the tex
all over the place ?
Cheeeeeeeeeeers
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34941
Kiviat Graph
People,
I am working with Excel 97 and I need to do a Graph named 'Kiviat'. Does
anybody know how to do it?
Thanks,
Andres Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34937
Unable to open excel file
Hi.
I have problem openning an excel file from windows explorer or from my
desktop. However, when I open the excel program and open a file
manually(File-Open----) everything works fine.
I get an error message that the file could not be located. I noticed
that it adds .xls to every word separated by space. For example:
My file is in C:/Shared/Folder/test.xls,
it tries to open: C:/Shared.xls then Folder.xls then test.xls
Please help.
Thanks.
---
Message posted from http://www.ExcelForum.com/ Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34931
Locking a Cell after It's Value is Calculated.
I have One Cell whose value is constantly changing once a week.
The results of that cell, I would like to have placed in
differents cells, once a week.
EX:
In worksheet1
Input in cell WK3, resulting calculation ends in cell M3, then
cell M3 is copied to worksheet2, A1 (=worksheet1M3) I got this!
Input in cell WL3, resulting calculation ends in cell M3, then
M3 is copied to worksheet2, A2:
The problem is that cell A1 changes to the new number
HELP!
Can I lock cell A1 after the value is copied to it?
Can I set conditions (time / date) on the cell after the value i
copied to it so it won't change?
I use the results of worksheet2, A1, A2, etc. for seperat
calculations.
If more clarification is needed I can email
a copy of the sheet.
Tom picktr@wowway.co
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34930
Copying toolbars from one PC to another
Is there a way to copy a customized Excel toolbar from one PC to another?
tia,
sh Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34925
Unable to lock scroll area or Cell selection
Hi,
I'm trying to lock the scroll area on my worksheet.
In VB I've got:
Private Sub Workbook_Open()
Worksheets("Board").EnableSelection = xlUnlockedCells
Worksheets("Board").ScrollArea = "$A$1:$u$21"
End Sub
In the sheet Properties I input:
EnableSelection 1-xlUnlockedCells
ScrollArea $A$1:$u$21
I save.
I protect the sheet.
I save again.
This works when I go into the sheet, the necessary cells cannot be
selected and the scroll area is locked the way I want. I save and
close, but upon opening the VB code is still there but EnableSelection
and ScrollArea within properties are blank, and I am once again able
to select any cell and scroll wherever I want. Any ideas?
Thanks
Paul Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34924
Formatting issue with numbers when saving as csv
Hi - I am using excel 2000. I have a spreadsheet that is an export
from ms access which contains prices of products in one column. The
number format of these cells is general.
When I save this spreadsheet as a .csv file, the prices that showed as
95.00 now show as 95 and prices that showed as 95.99 still show as
95.99 which is exactly as I want - if there are no pennies then drop
the decimal places.
I have a problem that when this .csv file is imported into a thrid
party application it is rejected.
The 3rd party application developers have taken this spreadsheet,
saved it as a .csv file and loaded it without any problems.
I have compared my .csv file against their .csv file in notepad and
found that mine displays 95.00 in the price column and theirs displays
95.
I have llooked hard and cannot see why there should be a difference.
What do I need to change to achieve the same as the 3rd party
developers? Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34922
Control Panel.
Hello again :),
I need after opennig Workbook disable all control panel a set fullscren:
Application.DisplayFullScreen = True
Is it possible?
Thanks
Tom Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34918
Is open.
Hello,
how is most easy way for finding workbook (for example data.xls) is open?
Thanks Tom Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34917
Last protect proble.
Hello,
now how can I lock all macros and forms againts editing? Its possible do
that in Workbook_open(), or I have to do it in VisualBasic Editor?
Thanks
Tom Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34909
Another protect proble.
Hello,
now I need protect macro (againts using Ctrl-Break) in Sub Auto_open(), but
this dosnt work:
With Application
.EnableCancelKey = xlDisabled
End With
Can you help me. I'd like to protect all macros at once, is it possible?
Thanks
Tom Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34906
Re - GGVT Excel To Return an Array of Values following Modification
Re - GGVT Excel To Return an Array of Values following Modification
In the beginning,
1. Look at a range of values entered into the worksheet cells A1:A10.
2. A10 contains "ZZ" (which is essentially unique within the scope of
the given range).
3. The following formula returns the given range of values following
modification :-
4. =IF(A1:A10=A10,"@",A1:A10) ; meaning to have replaced "ZZ" with "@"
and that the other values remain unchanged.
5. Note that it's the returning array being modified after the given
range ; otherwise, the physical contents of the range of cells
(located on the worksheet) remain intact.
And now,
1. Look at the given range A1:A10 again.
2. A10 has become an empty cell ; in addition, other cells within the
given range may or may not be empty.
3. The question is, how is it possible to modify and return the array
just like {A1,A2,A3,A4,A5,A6,A7,A8,A9,"@"} ? Meaning that a means is
to be devised in order to target A10 specifically for modification.
4. Note that the above expression of an array is given for the sake of
clarification. Pedantically speaking, Excel would not accept an array
containing variables expressed such as A1, A2 and etcetera.
5. Again, note that it's the returning array being modified after the
given range ; otherwise, the physical contents of the range of cells
(located on the worksheet) remain intact.
Regards. Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34904
search of a string in a cell and counting occurences using COUNTIF
i need to separate out items which are in a column with cells containing
1 or more of these items delimited by commas. i need to export them to
another worksheet within the spreadsheet which lists down the items
individually per cell and then, i need to count the occurences. i tried
to use the asterisk i.e. '*cell_contents*' in the countif formula but i
get an error. please help!
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum *** Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34897
Excel Help
I want to make a cell as a list box. How do I do this without actuall
putting a list box in that cell?
Thanks
TyeJa
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34893
Run-time error 6
Gretings,
As part of a routine to create worksheets the following macro looks at
a list and deletes any duplicates.
The routine works great unless there is only one cell occupied in
which case I get a "Run-time error "6" overflow. Is there any way of
resolving this short of starting again. As you may have guessed my VB
skills are lacking - this code was lifted off one of the posts here
but has served me well thus far.
Sub DeleteDuplicates()
Dim X, C, xMax, y As Integer
Dim S As String
Range("A1").Select
Range(ActiveCell, ActiveCell.End(xlDown)).Select
X = Selection.Cells(1).Row
xMax = Selection.Cells(Selection.Cells.Count).Row
C = Selection.Cells(1).Column
Do While X < xMax
S = ActiveSheet.Cells(X, C).Value
y = X + 1
Do While y <= xMax
If ActiveSheet.Cells(y, C).Value = S Then
ActiveSheet.Cells(y, C).Delete
xMax = xMax - 1
y = y - 1
End If
'error occurs in the following line
y = y + 1
Loop
X = X + 1
Loop
Range("A1").Select
End Sub Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34890
Problem
I have One Cell whose value is constantly changing once a week.
Input in WK3, resulting calculation ends in cell M3
M3 is copied to worksheet2, A1 (=worksheet1M3) I got this!
Input in WL3, resulting calculation ends in cell M3 (again)
M3 is copied to worksheet2, A2 (cell A1 changes to the new number)
HELP!
Can I lock a cell after the value is copied to it?
Can I set conditions (time / date) on the cell after the value i
copied to it so it won't change?
Any help is always appreciated.
Tom picktr@wowway.co
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34889
Template Wizard with Data Tracking (wztemplt.xla) Path
We moved a Excel template utilizing the Template Wizard with Data
Tracking (wztemplt.xla) add-in to a new server. We where able to
update the database path in the Excel template, but now I'm wondering
how I change the path in the Excel Spreadsheets created by this
template.
Where does the wztemplt.xla (3424.xls) store the database path
information?
Thank You! Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34883
Automatically copy input from one cell to another
After I enter a value in one cell, how can
I have it automatically enter it into another cell,
within the same worksheet, or into a different worksheet.
Thanks,
Tom picktr@wowway.co
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34874
One more question... not quite as idiotic
I've gotten the numerical problem handled, and now I have a differen
hitch in the getalong.
I have a table in Access and I need to get all the info from the Exce
spreadsheet into this table. It won't let me cut and paste the whol
thing, maybe because I don't have the same number of rows.
I can't seem to get Excel to create new rows for me unless I add the
one at a time (and I'm not doing that 2500 times), and I'm not sure ho
in the world to get this data over there.
Arrgghhh...
Any ideas?
Thanks in advance,
Wheele
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34863
can i use an autofilter in a protected worksheet
Hi there
I have created a spreadsheet and locked certain cells so that users cannot
change the information apart from one column. I then want to be able to
filter the data using the editable column. Can this be done? Even using
the Allow Users to edit ranges (with a different password) I cant get the
filter to run when the workbook is protected.
Any help would be appreciated
thanks
Jackie Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34857
Consolidate rows on susequent sheets.
Excel 2002
On sheet 1 I have data imported from an Access database. The data consists
of individual sales that are made by a number of different sales people. In
column "B" are the salesperson's names, and going accross in the subsequent
columns is related information about that particular sale.
There are quite a number of sales by each person on the sheet and so I want
to copy all the sales from each person to a seperate sheet in the same book.
I would also like to rename the Tab of that sheet with the salesperson's
name if possible.
The problem is that each time I import data to sheet 1 those names may
change.
If this makes any sense to anyone I would appreciate some direction.
Thanks in advance.
Rick Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34855
Formula or VBA help
Hi group -
I have a very simple task, but having trouble figuring how to do it. I have
values in a range of cells, let's say A1:A10. In cell A11, I have a formula
that sums that range. In cell A12, I have a value that reads =$10,000.00.
What I'm trying to accomplish is a prompt or something that will not allow
any more data to be entered when the value in A12 has been reached. In this
example, it's $10,000.
Any help is greatly appreciated. My brain is now warped from thinking too
much :-)
Thanks in advance,
Newtechie Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34854
This will sound ridiculous but...
I'm having trouble with a basic function.
I have an entire column of prices in the format $xx.xx
I need to take that entire column, say Column C, (titled "price") an
multiply each cell by a number and paste such that Column D become
those numbers plus tax.
I have cut and pasted the entire contents of the original column in
new column next to the original, so they're identical, now I need t
multiply each and every cell in Column D by 1.0825.
Any ideas how I can accomplish that?
And before you start, I'm a techno-moron. I'll need very basi
instructions.
Thanks in advance,
Wheele
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34846
counting characters within a cell
Is there a way to count the occurrences of a certain character within a
cell?
For instance cell A1 contains 1-20/2-12/3-9
I need to find how many times '-' or '/' occurs in A1
thanks in advance,
Rowland Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34844
Changing Comment font size?
Is there a way to change the default font size for the comment box t
something larger than 8? These old eyes having trouble reading th
comments, especially if the sheet is shown on the screen at less tha
100% size. It is time consuming to have to individually change th
comment size one comment at a time
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34840
getting started...
Hi,
is it possible to create a macro that receives arguments? What I mean is
without using offset, for example:
one time to run the macro with cells A1 A2 as parameters and write the
result into B2
and another time to run the macro over cells D5 E9 and write the result
into F8?
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum *** Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34826
Excel Challenge
Guys
I have been given a very difficult task and I need help.
Please!!!!!!!!!!!!!!!!!
The issue has more to do with maths than excel.
What we have is 10 Athletes who will compete in 9 different competitions.
Each athlete with complete against every other athlete only once.
So the total number of match will be 45.
A v E B v E C v E D v E
A v F B v F C v F D v F E v F
A v G B v G C v G D v G E v G F v G
A v H B v H C v H D v H E v H F v H G v H
A v I B v I C v I D v I E v I F v I G v I H v I
A v J B v J C v J D v J E v J F v J G v J H v J I v J
We will film these matchs and need to produce 5 shows. This is where the
problem arises.
Every show must show all the nine completions and must not show each athlete
more than twice. I will need to come with a list of matches that can be part
of each show so that the above two conditions are satisfied.
Can this be done or it is too challenging? Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34823
Automatic Calculation Not happening
Using Excel 2002 on XP Pro, some of my network users (2 so far) have
reported that Automatic Calculation of their spreadsheets is not happening.
This seems selective in that some spreadsheets work and some don't.
Automatic Calculation IS turned on in Optioons, but does not happen. Only
way to calculate is to F9 and perform a manual calculation.
There are no macros running anywhere .
Can anyone suggest any advice?
Thanks Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34822
Copying from Access to Excel problem
I have a large Access database (20000 records of 30 fields each) whic
has been imported from Paradox.
Periodically I need to export this to Excel and have long ago given u
on the 2 standard exporting techniques supplied: 1. File: Export and 2
Tools:OfficeLinks:AnalyzeItWithExcel since both generate errors after
long time thinking about it! If anyone has any comments on this, pleas
feel free to say!
Incidentally, I have a 2.6GHz P4 with 1Gb RAM.
I now manually transfer the data 6 cols at a time by 'copying' an
'pasting'. It is slightly tedious but it does the job in about
minutes. (Previously I could wait 15 mins or longer before it reporte
failure).
Finally to my problem. The copied version keeps formats (which i
excellent) but unfortunately also has each cell outlined in black. Whe
I try to get rid of this via Format:Cells:Borders:Remove, Excel doe
not leave the normal light grey edge to the cells. They are no
effectively not bounded as if the gridlines had been switched off
which is quite 'spooky'. How do I get rid of the black outlines t
leave the normal light-grey border
--
Message posted from http://www.ExcelForum.com Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34821
Lock workbook.
Hello everybody,
I have two workbooks, in the first I have some Forms (for me its programs
workbook) and in the second I have datas.
Is there some way how can I lock (write) the data workbook only for
Macros-Forms. I dont want still open and close this workbook
Thanks
Tom Tag: CAN ANYONE HELP??? Total Excel Novice - TimeSheet's Tag: 34820