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 / Worksheet Functions / May 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Macro Help for Saving a file12 May 2006 17:16 GMT3
Anyone, and everyone
I have a macro to save my spreadsheet.  (I am saving it several times
with diffrent names based on the data the macro pulls)
The code is as follows:
Several worksheet tally by name12 May 2006 17:03 GMT1
I have a worksheet that has several layers:
Tardy, Absent, Jan, Feb, Mar, Apr etc., etc.
I have the employees listed on the first two with a reference of their
initials:
Adding Text from seperate columns12 May 2006 16:49 GMT2
I have delimited a column of data that had a list of peoples names
including their title to several columns. Unfortunately the format was
not uniform in the column so some included their first and middle
initials and they either separated it by a space or a period - so some
Help - Auto update from multiple spreadsheets12 May 2006 16:49 GMT5
Problem: I have multiple tabs in one spreadsheet that get updated by many
different people.
Current methodology: I send the spreadsheet out to people, they each update
their tabs and send it back to me.  I then open each spreadsheet that is
big list of values to averaged smaller list?12 May 2006 16:36 GMT3
Hi, I just can't figure out how to do this so I'm hoping someone could
give me a little help.
I have a big list of measurements taken every 10 minutes.
Column A has the date/time
Merging 2 cells together and prefixing12 May 2006 16:27 GMT7
I hope someone can please help me with a problem that I have as shown
below:-
OK, I have a telephone number which is split into two separate cells.
The first cell is the dialling code (STD code) and the second cell is
Macro command control by date12 May 2006 16:26 GMT2
I am using macro command (button) to access next worksheet or workbook. It
is possible or not if I want set command can be access by date. e.g after
this date (10 May 2006) the command not working or access denied.
TQ
Most Current Date12 May 2006 16:18 GMT4
I have a worksheet that I keep track of quotes submitted.  I have columns:
Customer, Submit Date, Award Date, Price Quoted, and Won/Lost.  I have
another worksheet that is linked that keeps a cumulative total of the quotes
that are lost.  On that worksheet I have Last Award Date, ...
excel export12 May 2006 16:08 GMT1
why can't I see the commas in my .csv file?
INDEX / MATCH problem12 May 2006 16:03 GMT9
Sheet 1 has 3 columns: grade, step, NBS
Sheet 2 has 3 columns: SM, grade, step
I want to add a column NBS to sheet 2 for that exact grade and step, from
the data on sheet 1.
How do I calculate the midpoint date between two dates.12 May 2006 15:49 GMT3
Can anyone help!
I have August 2006 (start) and August 2008 (end). I need the midpoint
between those two months and provided in QTR-YR.
Ascribing Values to Symbols12 May 2006 15:44 GMT1
Am seeking assistance. How would I go about ascribing a value to a symbol in
Excel? For example if I wished to use ticks and crosses from WingDings and
have them represent a 1 and Zero value respectively so that they could be
used with basic formulas.
Results of conditional formatting not what desired.  How do I corr12 May 2006 15:18 GMT8
My formula produces a dd-mmm-yyyy result which is correct.
Cell L55 formula results are: 17-May-2006
Conditional formatting is set to: Formula is: =L55<=TODAY()
With background pattern set to red.
How to select automaticly the last cell not empty of a area?12 May 2006 14:50 GMT1
I don't find how to find automaticly my last data (non blank cell) inside a
table
thanks
Linking 2 workbooks12 May 2006 14:48 GMT11
How do you link a cell to another cell in a different workbook?  
for example:
Book1 Sheet1 cell A1 to Book2 Sheet2 cell A2
 
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.