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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do I convert date and time into shift worked?27 Aug 2007 15:59 GMT12
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 Macro27 Aug 2007 15:56 GMT2
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 data27 Aug 2007 15:50 GMT2
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 table27 Aug 2007 15:42 GMT1
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 editer27 Aug 2007 15:34 GMT1
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 Visible27 Aug 2007 15:29 GMT1
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 Lookup27 Aug 2007 14:41 GMT6
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 macro27 Aug 2007 13:49 GMT1
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 GMT4
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 criteria27 Aug 2007 13:10 GMT5
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 work27 Aug 2007 13:00 GMT4
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 GMT7
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 pages27 Aug 2007 11:22 GMT1
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 Formats27 Aug 2007 09:39 GMT2
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 not27 Aug 2007 05:16 GMT1
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.