| Thread | Last Post | Replies |
|
| How do I convert date and time into shift worked? | 27 Aug 2007 15:59 GMT | 12 |
I need to convert a date and time into a specific letter. I have the date is in one column and the time is in another, and need a letter output in a third column. I need the conversion to look something like this: Every Sunday,Monday,Tuesday from 07:00 to 19:00= A
|
| Delete Macros Macro | 27 Aug 2007 15:56 GMT | 2 |
I have some xl files that have many macros in them. For example 20 xl files with 10 macros in each file. I have the following macro in it's own xl file that I use to delete the macros in the other files before I save the
|
| pivot table data | 27 Aug 2007 15:50 GMT | 2 |
I have a spreadsheet that I am creating a pivot table to condense down some information to make it easier to read. The spread sheet is an inventory and has more columns than are needed and it does not show a total for each item. The pivot table seems like what I need to show this ...
|
| Protect part of pivot table | 27 Aug 2007 15:42 GMT | 1 |
I want to protect the Page field in a pivot table and have tried leaving the Page field cells status as locked and unlocking the other fields within the pivot table and then protecting the sheet, but it seems to protect the entire pivot table.
|
| I cant figure out how to get back to the web site editer | 27 Aug 2007 15:34 GMT | 1 |
I hade worked on my web site. Then i turned comp of and came back and i came here and i cant find where to keep editing my site. and im getting kinda mad
|
| Excel 2007 Workbook Not Visible | 27 Aug 2007 15:29 GMT | 1 |
After my machine has been running for awhile, when I open Excel 2007, no workbook is visible. I just see the blue background. Yet the default 3-page workbook is there, I can see it and the sheets listed in the VBA IDE. When I open one of my own workbooks, it creates a new window ...
|
| Complex Lookup | 27 Aug 2007 14:41 GMT | 6 |
I have to following inventory data: Pool Part # Final Discrepancies Actions FG11 286692-001 -1 FG13 286692-001 1 Move 1 to FG11
|
| Please Help sums in a macro | 27 Aug 2007 13:49 GMT | 1 |
I am posting again, hoping someone can help... I have a spreadsheet that does not have a continuous line of data (poor spreadsheet planning). What I need is a macro that will look in column M for a "1" and then move over to column T and sum the numbers below, then look for
|
| How to assign a short cut key for user defined word? | 27 Aug 2007 13:20 GMT | 4 |
Please inform me how to assign a single desired key, when pressed to input long data. For eg: Assign key "A" to input 377.88998774, instead of typing in the cells several
|
| CountIf for a range with multiple criteria | 27 Aug 2007 13:10 GMT | 5 |
Hello. I want to make a count concerning two columns A and B. The column A has text such as TT and TP the column B has numbers. example A B
|
| I can't get sort to work | 27 Aug 2007 13:00 GMT | 4 |
The worksheet is not protected. "Sort" is faded. I created the worksheet and never protected it at all. All cells are unlocked. Can anyone help
|
| how do I remove dotted page break lines from my workbook pages? | 27 Aug 2007 11:44 GMT | 7 |
I have been maintaining an excel workbook for years - it is a log - that never gets printed. Suddenly, out of the blue, I have page break dotted lines on the pages/sheets. How do I get rid of them?
|
| Creating shortcuts for a database between two pages | 27 Aug 2007 11:22 GMT | 1 |
I'm not a pro at Excel, but I know this can be done (I had someone create something similar at work a couple years ago). I want to create a document for weight management. I have all the food items on a second spreadsheet with information such as protein, carbs,
|
| Number Formats | 27 Aug 2007 09:39 GMT | 2 |
2003 Excel - I have imported data into a file and want to create a lookup formulae that will return a description when matching two numbers. The numbers do not appear to be in the same format and therefore the lookup formulae is not working. I have tried changing formats but ...
|
| Worksheet acts like its protected but it's not | 27 Aug 2007 05:16 GMT | 1 |
hyperlink, sort, chart, etc. are all faded. Same in the pulldown menus. The worksheet is not protected nor is acess limited. I created this spreadsheet. It is very simple. I've never seen this problem before.
|