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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel 2003 - VBA - Vlookup generation20 Dec 2007 14:41 GMT4
Today just doesn't look like it is going to be MY Day. It seems that I am
leaning on this group heavily today, so thanks alot!
This is what I have and what I need:
Column 1 is the Key name to look up.
Changing worksheet name within a formula (automatically)20 Dec 2007 14:37 GMT5
Hello please help,
I have a summary worksheet with a formula taking data from another
worksheet. Simply ='worksheet'!G34. At certain times of year I have to change
the worksheet name to equal the current period in all of the cells in the
Checkbox to Bold Adjacent Cell20 Dec 2007 13:39 GMT2
I have 4 sets of 6 Checkboxes adjacent to text items across the page for
a total of 24 items.  When a box (A7) is checked I want the text (B7) to
become BOLD.
I have the checkbox A7 linked to itself A7 and font and background the
File path listing and analysis20 Dec 2007 13:36 GMT3
I have two main folders with many sub-folders and files, one has to be
combined into the other ensuring that the most up to date file is adopted
whenever appropriate.  In order to do this I thought the best way would be to
down load or transfer complete filepaths and certain file ...
Excel Macro20 Dec 2007 12:47 GMT10
I have written a macro that hides several rows on a spreadsheet.  The problem
is that when I insert rows above those that are to be hidden as a part of the
macro, the row numbers in Visual Basic do not change, thereby the incorrect
rows are hidden.
Sales analysis and projection for pharmaceuticals20 Dec 2007 12:42 GMT1
I have 12 months sales data, product-wise. I need to project sales at least
for the next 3 months. Is there any formula available.
K.Ganapathy
Stop UK-style dates changing to US-style dates when mailmerging.20 Dec 2007 12:35 GMT1
Using Office 2007.  When I use Excel as the database and mailmerge in Word,
all my UK-style dates (eg 25/04/2003) change to US-style (eg 04/25/2003).  
Does anyone know, please, what can I do to format the dates, either in Excel
or Word, to ensure they keep the UK format?
text with a numeric funtion20 Dec 2007 12:11 GMT2
I am very new to xl and am trying to create invoices for my business. And on
these invoices I have a terms list showing   "On Reciept, Net 30, and 2% 10
Net 30."  
I also show a Invoice date and a due date.
File name in the footer/header20 Dec 2007 12:06 GMT2
Is there a way to insert the file name in a footer/header without the ".xls"
in the name?
Basharat.
How to convert numeric(1) to alphabet (One) in Excell20 Dec 2007 10:39 GMT1
I want to connvert the numbers to alphabet form like 1 To One in excell, or
12 to twelve, what is the command for this.
Autocopy formula in tables20 Dec 2007 10:06 GMT1
How do I STOP my formula being copied down on each row when I'm using a
table?
I want to use a fill series to copy down a pattern of dates.20 Dec 2007 09:18 GMT1
I want to use fill series to copy a pattern of dates down a column. The catch
is that I want it to have a date show up three times in a row, in separate
cells. So the end products would have three of the same date in the first
three column cells, three of the next date in the ...
Importing Excel file into Outlook20 Dec 2007 08:44 GMT1
I am using Excel 2003. I am trying to import an Excel csv file (containing
contacts) into Outlook 2003. From there I will export it to a website
(point2homes.com) that will maintain these contacts for me and allow me
access. I am following their instructions: In order to preserve ...
Sorting in group20 Dec 2007 08:25 GMT3
How do sort this
b    111
    2222
    33333
extract data from multiple workbooks20 Dec 2007 08:05 GMT1
I have 293 excel files, each comprised of a number of worksheets, and each
containing statistical information on a different area (the same type of
information, but obviously each area has different values; the same naming
conventions are used for each file/worksheet). What I ...
 
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.