Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Macro example05 Jul 2006 08:49 GMT1
Can I get an example of a recorded macro that is useful which can't be
achieved by a copy/paste?
Thanks
Opening warning05 Jul 2006 08:15 GMT3
When I begin using EXCEL a message pops up warning that a file could not be found.  It is from a program that I had deleted and I think is no longer on my PC.  
Is there a method to check and/or a method to delete the message?
Thanks,
Mike
counting duplicates Among Many Sheets, Possible??05 Jul 2006 02:23 GMT5
:confused: Hi, I have spent countless days trying to find a formula that
will allow me to find duplicates across Multiple Sheets within a single
workbook.  All resources I have checked only allow duplicate finding
formulas for A single Sheet.
hiding formula error  #DIV/0!04 Jul 2006 23:15 GMT5
Hithere,
In a sheet, for a cell I use the formula:
=(F4/1,19-D4)/(F4/1,19)
If there is no input yet in cells F4 or D4 an error message "#DIV/0!" is
modifiying macros04 Jul 2006 22:36 GMT3
I understand how to record a macro. But if I want to modify it (to repeat
throughout the sheet), how do I access the code to mofidy?
Thanks,
KBV
Dumb Chart Question04 Jul 2006 21:52 GMT4
Hi.  I have a simple worksheet tracking and calaculating the following
information about runs:
Date | Miles | Hours / Minutes | Minutes per Mile | Marathon Pace
Runs happen roughly 4x/week, so my entries might look like:
Two columns into one row04 Jul 2006 20:03 GMT4
I have some files I need to format.  I have a list of coordinates that
are in two columns and I need to turn them into one row, keeping the
order
ie:
Get Week number from Date04 Jul 2006 19:08 GMT2
for my job I need to get week number from date (date format doesn´
matter). I know, that in excel (beggining 2003 edition) is simpl
function WEEKNUM. But unfortunetelly in our firm is used 2000 version
I´ve worked on solution for really long time (compare with anothe
Select Range to last used cell04 Jul 2006 17:14 GMT1
In a macro I need to select an Range of cells (rows and columns) for
printing
The data in the spreadsheet is brought in via a database query and so
the bottom area has lots of blank rows, and a print page ends up with
Playing with dates04 Jul 2006 17:07 GMT6
Rite here I go, I want to automatically add today’s date in a cell,
which I have not done in so long I have forgotten.
Then from using this date I want to be able to search an entire row of
dates and find out if any dates in the row are older then 2 years, if
Multiple copies of a worksheet04 Jul 2006 16:41 GMT5
I am creating a workbook with up to 30 sheets. I have created a templat
in sheet 2, and want to copy that sheet 29 times for multiple users t
them enter data into. It is rather burdensome to keep selecting an
copying (w/ move to end) sheets until I have the amount I  need.
Deleted workbook04 Jul 2006 16:08 GMT1
I copied some sheet from one workbook to a new workbook and later deleted
the first work book. Every time I open the new workbook it asked if I want
to update the other on the link. I posted a couple of days ago and was told
to go to Links and break the link but this option is ...
Linking Tables between sheets04 Jul 2006 15:56 GMT2
I want my Excel file to have 2 sheets with 2 tables.
I want the 2nd Sheet’s Table to be LINKED to the 1st (so when I update the
1st, the 2nd auto-updates).
Just FYI, I’m planning to hide some rows/columns on the 2nd sheet, but still
Converting a cell to minutes04 Jul 2006 15:53 GMT2
I need to enter a number of hours into a cell and it will work out the
amount in minutes. Obviously i could do this with a calculation in
another cell (=sum(A1*60)...
However i need it to work it out in the cell that i put the number of
Display only nonzero items in a table???04 Jul 2006 15:41 GMT3
If I have a table with 5 columns and I want to only display rows with
nonzero entries of one of the columns...
What is the best way to do this?
I want to be able to integrate this into a macro, also.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.