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
VLookup based on two criteria28 Aug 2007 22:22 GMT2
I've read through many posts on this topic but I've not been able to
find a solution to my problem.
On one tab I have six columns of information (table_array.)  Column
"A" contains a machine name, Column "B" contains a fault name and
How do I force quote marks when exporting to a csv?28 Aug 2007 21:57 GMT1
When exporting to a csv file, Excel only places the double quote marks around
certain fields. I need it to place quotes around all fields.  Is there an
option to specify that?
Drop Down Lists28 Aug 2007 21:56 GMT1
How can I select from my Drop Down lists by starting to type in the word?  
For example, when I type in 'G', the names in the list beginning with 'G'
will be selectable, when I add 'a'; I should be getting closer to selecting
'Gate' - for instance.
Data validation: wider window on 14 columns28 Aug 2007 21:30 GMT3
I need 14 columns to temporarily expand so a data validation window can be
read.
Can the following solution from
http://www.contextures.on.ca/xlDataVal08.html#Wider be used on multiple
Error checking28 Aug 2007 21:29 GMT3
I have a file in one column we have Make and in the other column we have Model.
on a seperate work sheet there is a list of makes and models. in the make
column when you click on it there is a drop down list of all the makes on the
second work sheet and in the model column there ...
ENCREMENTAL FORMS28 Aug 2007 21:25 GMT2
Okay, this is what I want to do. There are three sheets, a Req Log a
Requisition form and a PO Form. I want to create incremental forms from the
Req Log. So that each Req number has its own Req and PO. Can this be done in
Excel? I can do it manually by creating a REQ or PO and ...
Large Database Problem-linking worksheets and printing28 Aug 2007 21:08 GMT1
I have a very large worksheet. My aim is to have Excel print automatically
the first Column and one of the Columns that follows.
For example
Page 1=Column A & B,
lookup part number in a vertical list and return the most recent .28 Aug 2007 21:07 GMT4
I need to lookup a part number in a "shipment Log" worksheet. It is laid out
with the following column headers:  "Part Number" "Aug 1" "Aug 2" "Aug 3"
etc....
If a part has been shipped, there will be a value under the appropriate date
Removing  the " [Group] " from a saved file28 Aug 2007 20:54 GMT2
I was working in an excel file, and then I noticed that [Group] had been
added to my file name.  As a result, I cannot switch tab pages, and I keep
getting different highlighted blocks in the file.
Inserting Multiple rows28 Aug 2007 20:48 GMT2
Can I insert 15 rows  one time, instead on insert row, insert row etc....
Automatic numbering28 Aug 2007 20:42 GMT1
I need automatic sequential numbering each time I open my Work Order.
Is there a way to create the sequential numbering automatically each time I
print, so I don't have to close the worksheet?
I have absolutely no idea how to write or use a macro.  Not that I'm not
retrieve items deleted from recycle bin28 Aug 2007 20:37 GMT1
I accidently deleted the main spreadsheet my desktop shortcut was connected
to. Not only did I sent it to the recycle bin, but emptied it also. Is there
any way possible I can retrieve my file or am I out of luck?
Excel Pivot Table - Sort Report Filter Values28 Aug 2007 20:26 GMT2
I'm using Excel 2007.  I have built a pivot table.  I have a field in the
Report Filter section of the pivot.  There are about  95 values in this
drop-down.
Problem:  The list isn't sorted in alphabetical order.  Or rather, for the
Populate Data w/ Multiple Drop-Downs28 Aug 2007 19:54 GMT1
I have a workbook that has a "master" worksheet with all the data (it is ever
expanding column wise). Right now it is 36 rows by like 150 columns. What I
need to do is create another worksheet in the same book that is linked to the
master worksheet. On the new worksheet, I need ...
Restricting data entry to A-Z a-z 0-928 Aug 2007 19:33 GMT10
Is there an easy way of restricting the data that can be entered into a cell
so that only characters that are in the range A to Z a to z 0 to 9 are valid.
i.e !"£$%^&*()-_ etc etc are not allowed? Might also need space to be an
allowed character, not sure yet.
 
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.