| Thread | Last Post | Replies |
|
| Automatically updating one sheet, from another | 26 Sep 2007 19:50 GMT | 4 |
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 them | 26 Sep 2007 19:41 GMT | 1 |
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 2003 | 26 Sep 2007 19:38 GMT | 2 |
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 2008 | 26 Sep 2007 19:28 GMT | 1 |
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 workshee | 26 Sep 2007 18:36 GMT | 2 |
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 GMT | 2 |
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 Function | 26 Sep 2007 18:25 GMT | 1 |
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 dates | 26 Sep 2007 18:12 GMT | 3 |
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 Averages | 26 Sep 2007 17:41 GMT | 14 |
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 formula | 26 Sep 2007 16:50 GMT | 2 |
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 GMT | 2 |
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 worksheets | 26 Sep 2007 16:46 GMT | 2 |
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 cells | 26 Sep 2007 16:34 GMT | 1 |
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 intrest | 26 Sep 2007 16:21 GMT | 2 |
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 fly | 26 Sep 2007 16:20 GMT | 4 |
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 ...
|