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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Creating a Proposal14 Nov 2007 23:49 GMT4
I am trying to create a proposal for our company.  Sometimes the proposal
will be 1 page and other times it may be 2 or more pages.  On the last page
of the proposal at the bottom (however many pages) I must have some legaleze
that exceeds 255 characters which is the max for ...
Printing a workbook but not getting page set-up results14 Nov 2007 23:46 GMT1
When I print an entire workbook in Excel it prints everyting in portrait
style when I have both portrait and landscape page set-ups in the workbook.  
I have several worksheets that I have defined in page set-up to print
landscape but they always print portrait style.  If I print ...
Excel - VBA - workbook/worksheet navigation14 Nov 2007 23:18 GMT1
I'm having some basic difficulty nagivating through books and sheets.
I am in a workbook and  intending on copying and pasting a couple of pages
form another wookbook into this workbook.
Using "GetOpenFilename" I identify and subsequently open a workbook. Copy
HELP ON VLOOKUP14 Nov 2007 23:04 GMT6
I have made a form and inserted VLookups. In my list of products there is
more than one of that product name but different sizes. So it looks like this:
Product name     Item #    Discription   Unit of measure
Buccaneer Plus  #00521    2x2.5ga ju    ga
Formating Date problem14 Nov 2007 22:58 GMT2
I have Excel 2007. When I type 1/2 in a cell it turns into 2-Jan and if I
click on it, it turns into 1/2/2007. I tried to Format Cell and chose Text
and other options, but it returns into 39084. Is there any way to turn this
thing off.
Create time value from number14 Nov 2007 22:47 GMT2
I have a column of numbers that I would like to turn into a time value.  
Example the number 1520 would be 15:20.  I've been thru the functions but
can't find what I want.  Can anyone help??
Thanx
%s in XL entered as ".5" OR "50" reads as 50% if format is %age.14 Nov 2007 22:37 GMT12
I have a spreadsheet I work with every day and I use fractional percentages,
between 0-1%. If the field is formatted as Percentage, and I type in ".5", it
reads it as 50%, which it would be if it weren't a percentage. But it is.
It's a half percent. By typing in "50", I also get ...
How to generate a list from a table14 Nov 2007 22:17 GMT1
I have a table in a worksheet that looks like this.
    Yes    No
Item 1    0    8
Item 2    2    6
Excell spread sheet14 Nov 2007 22:08 GMT3
all I want is to add columns on an excell spread sheet: example
4b+5b+7b+8b=9b
Merging rows based on column value14 Nov 2007 22:03 GMT2
I have an interesting problem. I have the data in the following
format:
a1|b1|c1|d1|__|__|
a1|b1|__|__|e1|f1|
Lookup all values on next tab14 Nov 2007 21:54 GMT1
Suppose I have some data and an if function in Column A. The If function
returns a "Yes" if 4 sets of criteria are met. If on another tab I want to
import all data with Yes in the A column into the new tab and I do not want
spaces between rows.
Worksheets14 Nov 2007 21:31 GMT2
What is the maximum number of worksheets you can have in a workbook?  Thank
you.
how do i make values increase by 1 while going down a cell14 Nov 2007 21:29 GMT2
I enter in numbers in a column and i want to drag the box down and have the
number increase by one from the previous number in each cell. HELP!
Leading Zeros14 Nov 2007 21:28 GMT2
I have a list of 1300 UPC's that I need to bring into Excel. The original
list is in SQL. I know the tricks of formatting a cell as TEXT or Custom to
the # of characters in your data, but if/when I do that, and I go to SQL and
copy the data, then go to Excel and paste it in, the ...
Excel 2003 - VBA - AutoExecute14 Nov 2007 21:26 GMT2
Apologies. I seem to have lost track of a solution already in hand, so I
have to ask again.
Upon loading a prepared workbook, I would like a macro to auto execute
setting up some of the preliminaries in preperation for a session.
 
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.