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 / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Macro or Formula?20 Sep 2006 17:26 GMT1
 I assume this needs a macro, but here is what I am trying to do:
Sample Data:
AB    93    OK    93    AB   
ABC    9370    OK    9370    ALL   
object behind text and gridlines20 Sep 2006 17:25 GMT2
How can I order a text box or other drawing object to the back, and behind
the text and gridlines of the spreadsheet?
Create a formula to calculate when info. was last updated20 Sep 2006 17:23 GMT5
I'm not sure if this is the appropriate forum, but I'd creating a file that
includes multiple lines and I'd like a cell for each line to act as a status
cell and note the last update to that line.  Is there a way to do that?
I cannot see some columns and some menu items are grayed out20 Sep 2006 17:10 GMT3
we are missing some colums from our spreadsheet and we cant unhide them
beacuse the button is grayed out the information is still there because i can
do a mail merge and put in to a word document from that spreadsheet.
Input color and formula color20 Sep 2006 16:59 GMT5
Is it possible that on a spreadsheet, whenever you have cell with a formula
in it, the font color is black and if you have another cell where it is a
simple input field the cell font color is blue.
I do want to goto each cell and select black or blue. I do not want to use
Excel 2003: Print Area20 Sep 2006 16:59 GMT4
I have a workbook with 12 worksheets in it.  They are all basically the same
so when I set the print area for one it could be the same for all 12
worksheets. Is there a way to do this all at once rather than 12 times?
Trying to add a drop down list of all worksheets for the user20 Sep 2006 16:59 GMT2
We have 50 worksheets in an Excel file.  I would like to provide a drop down
box or something of that nature for the user to select and automatically take
them to the worksheet.  Is there a way to do that?  Is there also a way for
the user to get back?
Excel - How to compare two spreadsheets20 Sep 2006 16:59 GMT1
Need to compare two long complex spreadsheets with primarily text entries in
the spreadsheets.  Wanting to cull out a report on how they are different
How do I get rid of an external link which I can't find?20 Sep 2006 16:54 GMT1
I have a spreadsheet that *somewhere* has an external link.
I want to get rid of it, but I need to find the link first to check that I
am not hard-coding over a formula that does actually need to change.
However Excel 2002 is too stupid to show me the actual link. I can "Break
Cleaning Up Data20 Sep 2006 16:40 GMT3
Ok i have close to 10000 records and they look like bg1234 and i need
to add 00000 after the bg but i also have to make the bg capital
letters.  How do i set up a marco to just look for the bg because i
have other records that begin with other letters.  Another problem is
sumproduct for month and year20 Sep 2006 16:29 GMT1
I am trying use sumproduct to add totals for a month when the criteria or
date column is in the date format mm/dd/yyyy.
For example the month column could have the following dates
06/04/2006
Macro help please20 Sep 2006 16:22 GMT3
I have two macros I'll put in order below after I explain, can I join
them into one, or can I make another macro that runs the first, then
the second?  Each works fine, but second one loops, so combining them
is beyond me, unless there is a way to benchmark loops in code?
VLOOKUP error in VBA20 Sep 2006 15:57 GMT1
I am doing some VLookups in visual basic and am running into an issue.
Basically, I am running 7 vlookups on the same value in different
columns.  If the vlookup does not return an error, I want to report the
number in column 3 of the range; if it is an error (ie, the lookup
print preview20 Sep 2006 15:54 GMT4
Print preview has suddenly dissappeared - how can I get it back.  Why has
this happened?
Looking for Mortgage Calculation Spreadsheet20 Sep 2006 15:24 GMT2
I am looking for a Mortgage Calculation Spreadsheet which calculates the
following:
Term
Loan Amount
 
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.