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 / General Excel Questions / September 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Automatically updating one sheet, from another26 Sep 2007 19:50 GMT4
Here's my situation, I have largely horizontal spread sheet, with vertical
info as well, we are trying to consolidate all info into 1 vertical column,
is there a way to copy each cell from sheet 2 in a range of rows i.e (8:100)
and then copy that into colum A of sheet 1?
how do I hide a set of lines and using the "+" sing show them26 Sep 2007 19:41 GMT1
I am trying to figure out an existing spread sheet that has repeating lines
hidden until you click on the "+" sing on the left. Then they appear.
My question is how do you set this up ?
Uninstall Excel 2003 not the whole Office 200326 Sep 2007 19:38 GMT2
How can I un-install Excel without un-installing the whole Office 2003? And I
will have to Re-install it after that. Or if I un-install the whole Office
2003, the data for Outlook 2003 will stay? thanks a lot.
Update 2007 calendar to 200826 Sep 2007 19:28 GMT1
I have excel 2000 and have a calendar of every month on a single spreadsheet.
When I attempt to update the days by putting January 1st in the new day it
updates but is missing days.  Particular it  skips Sundays.  Is there an easy
way to update this?
Detailed worksheet value entered automatically in Summary workshee26 Sep 2007 18:36 GMT2
I have a detailed sheet called "Receipts" that I enter employee name and
amount they spent. Another worksheet called "Summary" that has employee name,
Credit limit, how much they used, and balance. I would like to be able to
enter information in the "Receipts" worksheet and have ...
Protect just one worksheet of an excel doc?26 Sep 2007 18:28 GMT2
I have a large excel document, and one of the worksheets within the document
is very confidential.  Is there a way to password protect just that one
worksheet within the document?
Excel Search Function26 Sep 2007 18:25 GMT1
Is there a search function where I can search multiple tabs in my excel
spreadsheets for duplicate information?
I have 30+ tabs with SAP transactions codes and need to find where my
duplicates are.
Formula for # weeks between 2 dates26 Sep 2007 18:12 GMT3
I am writing a formula to calculate the number of weeks between two date
fields.  Easy enough, =(Date2-Date1)/7. Problem is that not all date fields
have a value and sometimes the two date fields are the same.  Here are the
possibilities and the desired result:
Complex Averages26 Sep 2007 17:41 GMT14
Hello, I need to design a spreadsheet that averages the last 5 and last 10
numbers in a row of up to 40 numbers. There will be various random spaces
between the entered numbers. So for example, if there are 15 numbers spread
over 40 rows, I would need to average the last 5 which ...
keeping only data in cell and not formula26 Sep 2007 16:50 GMT2
hi u r help will be appreciating
if i calulate a value in particular cell with reference to other cell and
now how can i keep only calculated data n not the formula may it be in same
cell or other cell if i copy i
Recalculate based on 3 of 4 variables.26 Sep 2007 16:46 GMT2
I have been asked to come up with a smple way to let non technical users key
in 3 values on a sheet and have the sheet calculate the 4th value.  It is a
very easy calculation, but I'm not sure how to allow for any of the three
values to be entered and calculate the fourth.  Here ...
Comparing two worksheets26 Sep 2007 16:46 GMT2
I need a formula to compare two different sheets and to copy the data in the
sheet 1 to sheet 2 only if its matching with the respective data.
To be clear let me put you in this way....
Sheet 1:
Counting cells26 Sep 2007 16:34 GMT1
Hi, I have a sheet with column "G" being the date of the last time a
customer was contacted, I need to count the number of customers that
have been contacted within the last 365 days. I do have the formula
set up on the sheet to keep track of the current date.
90000 in bank at 8.50 for 12 months whta intrest26 Sep 2007 16:21 GMT2
I have 90000 dollars in the bank at 8.50 for 12 months compounding intrest
how mutch do i get at end of year. thanks if you can help.
Shared files - read only on the fly26 Sep 2007 16:20 GMT4
Hi all!  Excel 2003 user here.  I have several files on a shared network
drive.  On occasion, I have the need to view only a file after I've opened
it.  Other times, I may be working on a file and want to manipulate data and
not accidentally save the changes once I've opened the ...
 
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.