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 / January 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Share workbook no copy or printing24 Jan 2007 04:39 GMT1
I have Excel 2000 and want to know if I can share a workbook without others
being able to modify, print, copy by Ctrl-C or clipboard or email the
workbook. Is this possible?
Thanks,
Picking specific records from a table24 Jan 2007 04:30 GMT1
I have two worksheets. The first table contains a record for each parcel of
land in town (4500 +/-) containing a lot number ID (101-001-000-000), owners
name and assessment value. The second table contains only records of parcels
that are in a particular zoning district that is ...
Rows not columns24 Jan 2007 02:48 GMT9
It almost seems to be working but I need the rows locked when entering
something in the first column rather than the columns locked. I also
need to use columns from C through O rather than A through C.  I almost
understand what you are doing but not quite. Thank you for your ...
CLick on Box to enter time of day24 Jan 2007 01:22 GMT1
I have a worksheet where payment is entered in column C. I would like to
use Column B as a time stamp. In other words as soon as data is entered
in C5 then the exact time comes up in B5. When data is entered in C6
then the exact time cones up in C5. I do not want this time to ...
NOTIFY USER ON DATES IN CELLS24 Jan 2007 01:00 GMT1
Is there a way in Excel to be notified on the date that is in a cell?
For example, several columns of text and numeric data and one column of
dates.  On each date that appears in the date column you would be notified
in some fashion to check the data corresponding to that date?
Returning a previous date & value based on the current date24 Jan 2007 00:29 GMT4
Sorry not sure if the subject describes clearly what i am after.
I have a report which is setup as follows (with data going back a few
years):
Week Beginning      Value
Macros: Pasting a value into a rename dialogue box23 Jan 2007 21:37 GMT1
I am trying to write a macro which will:
1) Make a copy of the current worksheet
2) _Copy_ the value from the D9 cell
2) Rename the copied worksheet by selecting "rename worksheet" and
[Help] Stuck with VLOOKUP23 Jan 2007 21:12 GMT3
I am setting up an Excel invoice where:
1) The user inputs a name into the D9 cells
2) Excel automatically fills in the Title, Surname, Company, Address,
Town, County and Post code in the C9, E9, C10, C11, C12 and C13 cells
COUNTIF using amount of time23 Jan 2007 21:12 GMT2
I have some data with various time intervals in mm:ss.ms and I want to
use the COUNTIF function to count how many of them fall between 1-2
minutes, 2-3 minutes, 3-4 minutes, etc., but I keep getting a count of
all the values. Am I comparing the time intervals wrong?
How in the world do you open an excel spreadsheet archived in a .ark file?23 Jan 2007 20:35 GMT1
It seems to be some legacy compression format that only works in Linux.
I'm running Windows..
No more new fonts may be applied in this workbook23 Jan 2007 20:35 GMT1
I was getting this message when I was copying or changing charts in my
workbook. After inserting the macro as outlined on this discussion board with
the same thread name, the error stopped (THANKS!).
BUT now I am trying to change part of the font colour inside a (merged) text
Excel formula23 Jan 2007 20:33 GMT5
I need help with a formula in Excel. It is a timesheet that totals the
hours.  An employee is allowed to work a max of 7 days or 70 hours, in
which case it sets back to 0, otherwise total.  I am trying to use a
nested IF formula but can't get all the arguments to work with each
shifting rows up or down23 Jan 2007 20:11 GMT8
I'm new to Excel, so please excuse a basic question.
Is there any way to shift rows without first creating blank rows
for them to land on? When I attempt to drag and drop, it asks me
if I intend on overwriting.
Value of cell Defines Range23 Jan 2007 20:07 GMT3
I am trying to set a picture to a range of cells which I can do by
setting the picture to a range like =$A$1:$C$5. My problem is that the
range can change anytime. It will always start in $A$1 and end in
column $C but the row for column $C can vary. I know what row column $C
How to make a worksheet visible23 Jan 2007 20:00 GMT1
I have about 40 worksheets in a workbook. each sheet has a name of a student
in a classroom.
how can I  programaticy make a choosen sheet to be visible
thanks
 
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.