using excel as a database for movies and cd collection help
hi, ive been using excel to maintain a list for my cd's and moves etc just
wanted to make it more functional but as im a noob im not sure what i can do,
as it stands i have a workbook with a sheet for each catagory cd's movies tv
shows etc, with a cell comment giving details of the item like the list of
episode titles in a tv series. im using ctrl + f to search and using a red
cell for stuff ive lent to friends, i would really like to enhance this
workbook maybe add a stats page, see if there is some way to list the number
of red cells etc, improve the searching, count the no. o...export excell into outlook calender
Does anyone know how to export or insert an Excell 2002
spreadsheet (representing a calender) into outlook 2002
calender? Much appreciated.
...Excel formatting #4
I am trying to sort a spreadsheet. I want it to sort like this:
It will only sort:
How do I fix this?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
If you put an apostrophe in front of each number, it will allow you t
treat it as either text or a number when you sort (Excel will ask yo
how you want it treated)
~~ Message posted from http://www.ExcelTip.com
~~View and po...Parsing excel field help !
Does any know how can I check all the characters of a field and check
that there is not an alphanumeric character (a-z) and if there is one
changing to zero.
Ex. 5J00 = would like to change it to 5000.
20A5 = would like to change it to 2005.
For Each c In Selection
For i = 1 To Len(c)
If Not IsNumeric(Mid(c, i, 1)) Then c.Replace Mid(c, i, 1), "0"
<email@example.com> wrote in message
news:firstname.lastname@example.org...Pasting values not formulas in Excel 2002
How does one copy and paste values rather than formulas in Excel 2002?
I have Excel 97 and Excel 2000 and in both one can do this through
Edit -> Paste Special
But Paste Special does not give you this option in Excel 2002 and I
cannot find any help in the online Help with about how to paste values.
I use XL2002 and I can Copy --> Paste Special --> Values with n
Values is in the Paste Section in "Paste Special" and is the thir
option on the left.
I hope this helps you.
Message posted from http://ww...Excel 97 worksheet with macros won't open in Excel 2000
I've got a workbook saved in Excel 97 that has some
embedded macros (not sure where-we don't really need
them). When trying to open from Excel 2000, get error
message "An error occurred while initializing the VBA
libraries (126)" and the workbook won't open. Any ideas on
how to make this work in 2000? Or maybe even find where
the macros are and get rid of them?
...Disable format painter in excel 2003
The format painter icon keeps appearing when I add or delete columns and rows
- it keeps blocking me from seeing what is in the cell and is a general
nuisance. I do not need the format painter, but I cant seem to find a way to
deactivate it, permanently if possible. Anyone have any ideas?
Actually it is probably not the Format Painter, but the Insert Options button
that is bothering you.
Uncheck the Insert Options and for me, also the Paste Options button.
Gord Dibben Excel MVP
On Mon, 7 Feb 2005 15:43:04 -0800, tenchsama
<email@example.com...Excel 2007 Bar and Line chart on 2 Axes
I used Excel 2003 to create a "bar and line chart on 2 axes" and now have
2007. I can't find where or how to create these charts using Excel 2007.
Can someone tell me how to do it?
Then Google "Excel 2007 chart"; look at a few sites
Then come back here with specific questions and we will help you get it
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Nancy" <Nancy@discussions.microsoft.com> wrote in message...mail store size
I am looking to obtain the full mail store size of my exchange server.
Server 2003 / Exchange 2003
What is the best solution to do this?
Add up the values of the stm and edb files.
"Mr. Backup" <firstname.lastname@example.org> wrote in message
>I am looking to obtain the full mail store size of my exchange server.
> Server 2003 / Exchange 2003
> What is the best solution to do this?
That's what I did, and then matched up with my backups.
I just thought t...In Excel 2000, How can I change the order in a pivot table?
I am having problems changing the order of my pivot table. The "Drop Column
Fields here" is date related and I grouped that area by month. I can change
the chart data series order, save the file, close the file, then reopen it
and the changes go back to the default view before the series order in the
chart changed. I have another co-worker that has Office 2003 and it does not
happen to her. It retains the information as she saved it. Is it a glitch in
...Recover excel file
Can I get an autorecover file, if I closed Excel without saving changes?
If you closed without saving, it's gone.
Did you happen to E-Mail it to someone before you closed ??
Because it would be in sent email.
Otherwise, it's start again I'm afraid.
> Can I get an autorecover file, if I closed Excel without saving changes?
...Column, Row Font Size
For some reason the column letters and the row numbers - at the very top and
far left on any worksheet - have become so small on a particular worksheet
as to be illegible. What have I done, and how do I undo it?
If it only happens on one worksheet, maybe you've set the zoom too small.
From the menu bar: View|Zoom... (and resize to look nice)
There's a Zoom icon on the Standard toolbar that you could use, too. (My icon
is at the far right of that toolbar.)
Old Red One wrote:
> For some reason the column letters and the row numbers - at the very top and
> far left ...PDF'ing in MS Excel 2003
I'm noticing this while trying to PDF in MS Excel (2003). When I try
to send the pages I'm interested in PDF'ing to the printer to create
an Adobe document, the tabs are all saved as separate files. I have
up to 200 pages that I need to PDF, and many of these documents are in
fairly complex Excel models in different tabs.
Is there any way to bypass this - in other words, have all the tabs
that I've selected to print, save as a single Adobe file, so that I
don't have to combine them later into one, consolidated document?
By the way, I noticed that when I do this at ho...Excel / VBA
I am trying to find how to add or remove the description displayed on
the "Macro" pop-up menu (Alt-F8). Generally macros recorded have a
banale description giving the time/date & username, others that I write
directly in the VBE have none.
Can anyone point how to add/modify this description?
Message posted from http://www.ExcelForum.com/
When the macro recorder fires up, the first dialog allows you to put
whatever description you want in, including none if so desired.
The value gets saved as comments, but changing the comments does not chang...excel
I experimented with Text to Voice and now I CANNOT TURN IT
OFF! It operates in every spreadsheet and in every cell -
it is driving me nuts! Please - how do you stop it! - the
toolbar does not work - it stops it if I am quick enough
for the one cell but carries on in all the rest!*!
Go 'View' > 'Toolbars' > check 'Text to speech' and the toolbar will appear
Toggle the icon on the right, 'Speech on enter' to off
"ally" <email@example.com> wrote in message
Can someone tell me if Excel can round up to the nearest ten?
Yes. One way:
In article <DC37A92F-F3A2-4246-BBBB-68F4F2A1D368@microsoft.com>,
Warren <Warren@discussions.microsoft.com> wrote:
> Can someone tell me if Excel can round up to the nearest ten?
use ceiling(number, significance) or if u wanna have the other wa
round go for
m_anoob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1989
View this thread: http:...File Size #6
I am using a file in which i copied the IF formulas till row# 900, an
columns are covered till "BL" and most of them contain IF formulas.
The problem is that file is very huge around 4.000KB.
Because of this i am unable to mail it most of the times.
How can i reduce file size?
Message posted from http://www.ExcelForum.com
WinZip will take the file down to about 1 tenth of size
Message posted from http://www.ExcelForum.com
You might reduce the size by ensuring an efficient used range
Go to the first empty row after your data:
Hold down Shift then p...Excel Football Prediction competition
I am running a small competition at work (30-40 players)
for the forthcoming 2004-2005 English Football Premier League. Basically the
entrants have to predict the scores of each game and they receive points for
correctly guessing an Away Win (1 point), Home Win (2 points), Score Draw (1
point), No Score Draw (2 points) and then extra points (5 points) if the
score is completely correct.
I have a sheet for each player (Player Name) where their prediction is
posted and an identical sheet (Results) where the actual results are entered
as they happen. I have i...how do I increase drop list font and box size I created
Font is small and you have to scroll through list due to box size
If the dropdown was created using Data Validation.............Font size is set
Dropdown box height cannot be changed.
For workarounds like using a ComboBox and using Zoom see Debra Dalgleish's site
on DV Lists.
Gord Dibben MS Excel MVP
On Fri, 4 Apr 2008 11:36:02 -0700, cdietz1 <firstname.lastname@example.org>
>Font is small and you have to scroll through list due to box size
...Excel files are 'read only' when accessed over network.
How do I make them accessible please.
Also I cannot get access to Windows folder via network. Ideally I
would like to get access to everything over the network if I need to.
I have ticked sharing and security boxes.
Since these are network drives, you may want to have your IT folks look at it
and see if you have access to the drives/folders you need.
> How do I make them accessible please.
> Also I cannot get access to Windows folder via network. Ideally I
> would like to get access to everything over the network if I need to.
> I have ticked sharing...Previous Excel Files
You know how Excel lists the four most recently used
workbooks under the "File" menu for easy access. Well I
have lost this feature everytime I closed down Excel and
open it again. Is there a way of switching this feature on
& off? Would appreciate anyone's help.
Yes there is a way to switch it off and on...
Go to Tools>Options>General tab. There is a checkbox for Recently Used
File List and a box for number of files to list.
Please note that when you switch it back on it will only list the files
you open/save from now on so it will not list recent files op...Excell Formula
I have a list of over 1000 Product in column A and in column B over 30
Supplies and in column C the price of each product from different Supplies.
Each Supplier may offer same product but with different prices ( e.g. Table
below ). All the information is in sheet 1.
A B C
1 Product 1 Supplier 2 £10.00
2 Product 2 Supplier 1 £8.00
3 Product 3 Supplier 2 £8.00
4 Product 2 Supplier 2 £6.00
5 Product 1 Supplier 3 £11.00
6 Product 3 Supplier 1 £7.00
I have created sheet 2 ( e.g. table below ) I need formula which updates
I have a spread sheet and in it i have data validation tables when i finish
picking from them and email the sheet i then want to clear the info in the
tables but not the data validation table and not usr macro
I'm not exactly sure about what you want to do, Is the whole range filled in
with data validation in the cells to create your table or only part. If you
can select all the cells with data validation then you can press delete on
the keyboard to clear all the contents, but the data validation remains. Or
if this is difficult because the data validation is dotted about the...dates in excel #2
need help with the date function
this is the situation
i use excel daily to create a report. as this report is
printed out i just save changes made.
except at the weekend when i also make backups so that my
boss can send the report by email on monday mornings.
in the report we use the NOW function to display the date.
when we used to open the backups the date never used to
change ie if saturdays backup was opened on monday morning
it used to still display saturdays date.
now for some reason the date is automatically updating.
anybody know how to prevent this happening
You probabl...lookup and match from another excel file
Curious if someone can help. I have a dispatch log that I made for m
company, I would like to set up a payroll system that will automaticl
pull all rows that meet a certain name and date range. and put it o
another new sheet for that weeks payroll if anyone has some ideas le
me know, I can post an example of my dispatch log if needed.
Sorry Sort of newb to this.
Actually here is the file, I have macros on it for sorting
Attachment filename: new daily log.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63792
Message posted from ht...