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 / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Varied product list01 Apr 2008 00:48 GMT4
I need to create a price list in Excel of our product line, but I need to be
able to modify its contents to particular customer types. For example, our
line includes frozen foods, candy, condiments, produce, non-food items, etc.
Certain customers have no interest in our frozen ...
Printing problem01 Apr 2008 00:09 GMT6
Let's say I have long list of data in columns A, B and C, which in the end
makes it a long skinny table.  I would like a print to "wrap" the table so
that it can go 3 or 4 times from the top to the bottom of the page (we'll
assume it's a landscape printing or an 11x17 sheet...), ...
countif in VB31 Mar 2008 23:58 GMT1
Can this be done shorter, without using cell B1
Range("B1").Formula = "=COUNTIF(A:A,""*Stock*"")"
Stock = Range("B1").Value
Range("B1").Clear
Excel 2000 PIvot Table Borders31 Mar 2008 23:07 GMT1
When I add borders to a Pivot Table, and then refresh the data, the borders
disapper.  Is there anyway to prevent that from happening?   The "preserve
formatting" checkbox under Options is active.
how can i insert MY signature into an excel spreadsheet?31 Mar 2008 22:01 GMT1
I would like to be able to "sign" excel documents I create.  How can I put in
an authentic signature on the document?
Calculating dates31 Mar 2008 21:40 GMT2
I am trying to track perfect attendance which is defined as a full year with
no absences.  I need to be able to distinguish between employees who acheive
this for 1 year, 2 years, 3 years and so on.
The data that we use is currently set up like this:
How do I create a macro to remove path from hyperlink "address"?31 Mar 2008 18:48 GMT7
Excel 2003
Signature

May your footsteps be lost in the music of the forest.

Row shading based on criteria31 Mar 2008 18:23 GMT6
I would like to have rows shaded only if a certain number on a row changes:
So, if the data was like the following:
50772    JONE    RON    355-FT-DR
50772    JONE    RON    355-FT-DR
Data Comparison31 Mar 2008 17:33 GMT1
Is there a way to compare 2 sheets of data and gets results that lists which
records are duplicates and which records are unique?  Will this also count
the number of duplicate and unique records?
Excel 2000
Copying a Macro31 Mar 2008 17:31 GMT1
I have created a Macro and it is saved in my "Personal workbook".  How can I
copy this macro and/or save it somewhere that is it available for others at
our company to use?
Saving stripped down version of Excel Workbook31 Mar 2008 17:25 GMT1
How can I save an excel workbook with formaulas and links as values only
workbook?
Month-Year 'format'31 Mar 2008 17:20 GMT4
Hello.  I'm setting up a results summary table that calculates from a detail
tab.
In the detail tab i'm capturing date of activity (where the user inputs a
date) 3/31/08.  On the summary tab i want to calculate results by month year.
Massaging data to determine risk31 Mar 2008 17:14 GMT2
In range of data I need to find jthe largest numerical movement in one
direction without (x) retrace.   (x in this case being a specific whole
number)  Please help with a formula or direct me to where I could find this
information.
Filtering for Unique Records31 Mar 2008 16:42 GMT3
I'm working with a dataset of approx 2K records; each record has 15 fields.
The uniqueness of each record is defined by 5 fields. Is there a way to
filter for unique records given these conditions?? Thanks...
Total each item's transactions31 Mar 2008 16:41 GMT2
I'm trying to create a document we can use to track some inventory.
The first tab of the spreadsheet is simply a place where transactions are
entered.  There is a column for the part number, then a column for quantity,
and then some other columns regarding other specifics.
 
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.