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
Using a macro that includes 2 worksheets24 Aug 2007 22:51 GMT3
Last night, my computer was upgraded to Windows XP. I found that macros I
had recorded were no longer visible. The one I used most often was rather
simple, so I just re-recorded it...it involves copying some data from a CSV
file into an Excel spreadsheet. Before the upgrade, it ...
Hard reference in a macro24 Aug 2007 22:24 GMT1
How can I keep my macro from using a hard reference to a particular run of a
csv file that the macro exports into another worksheet?  Each time I run the
csv file (e.g. to tweak the macro, or just to test the macro to see if it's
working), the
Lookup24 Aug 2007 22:21 GMT1
I am trying to extract number (%) from a table using “lookup” however the
first column to be used is made up of a range versus merely sequential
numbers e.g. 0 >=70, >70<=80, >80<=90 and so on and then the row used is
similar e.g. 0 >= 300000, >300000 <=400000, >400000 <=500000 ...
search or find, and extract?24 Aug 2007 22:20 GMT1
I need help using Excel 2007.
I have 10 trucks driving for me. Each truck will be driving for several of
our customers. In one workbook, I have a seperate worksheet for each truck.  
That look something like this:
Worksheet to new file24 Aug 2007 22:12 GMT2
I have more than 100 worksheet in a sheet and i want to save this worksheet
as workbook at once. I can do I one by one. Please help me on this.
Jai
excel - formula to copy the cell contents and colour. Possible?24 Aug 2007 22:05 GMT3
does a formula exist so if i colour a cell on page one the contents,
including the colour, will be instantly copied onto page 2
Protection Reminder24 Aug 2007 21:04 GMT8
I have used a combination of locking certain cells and then protecting
worksheet in order to prevent accidentally overwriting cells with formulae in
them. This works fine for what I want but occasionally I need to change a
formula so have to unprotect the sheet. Again, no problem ...
Want to divide a number into groups of thousands24 Aug 2007 20:54 GMT3
I have a number, say 3,450, that I want to subdivide into groups of 1,000
like this:
1000
1000
Solver Macro24 Aug 2007 20:54 GMT2
I want to create a macro that automatically runs solver when a button is
pushed.  I went ahead and recorded it, however every time I run it a dialogue
box pops up asking me if I want to keep the solver solution.  I always want
to keep the solution and I don't want to have to hit ...
Referring to Ranges in Change-Event Macro?24 Aug 2007 20:12 GMT4
I stole the bulk of the following code from one of Dave Peterson's many
helpful postings on this site. I have  a number of named lists on the sheet
called "Feed Data." The lists are named "list1," list2," list3," etc. Each
one is defined with an OFFSET function.
How To Format Row Column Intersection24 Aug 2007 19:50 GMT3
Hello group. I have something I've been working on for some time and
I'm stuck. Let me describe the situation.
I track my fitness in a spreadsheet. One measure of fitness is the
waist / hip ratio. This is waist divided by hip. I have a range
Loan calculator with extra payments24 Aug 2007 19:38 GMT2
using the Loan Calculator template in Excel, I am trying to calculate loan
payments with optional extra payments, over 5 years.  However, every time I
input the optional extra payments, Excel shortens the loan term instead of
reducing the monthly payment amount (which is what I ...
link 2 pgs. from 2 workbooks, getting 1st line only ?24 Aug 2007 19:32 GMT6
EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get
cell A1 to come to the destination workbook.  Help.  Ema
Using Now() in a Function24 Aug 2007 19:30 GMT2
I am using the Now() function within a function, to enter a timestamp
as a spreadsheet is populated. Here's the function:
   =IF(AND(LEN(D63)<>0,MOD(B62,12)=0),NOW(),"")
The function works fine, however, the timestamp continues to update,
Excel 03 to Excel 0724 Aug 2007 19:21 GMT2
Could anyone help me?   I am taking and Excel 07 class at my college, but the
computer that I use has Excel 03 (and also is not capable of downloading any
new software or trial versions).  If I do spreadsheets in Exel 03, will it
convert correctly to 07 and vice versa?
 
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.