I'm looking to rename and save my workbook to a destination file
everday at a preset time. After it saves to the destination file i need
all the data to be removed from the origional workbook.
Lets say I'm working with a workbook called Book1 everyday at lets say

I have 199 worksheets and I would like to have a summary page that displays
the sheet name in column A .  I'm looking for a script or how to reference
the worksheet name so I can have a function auto populate the table names
from A2..A200

I have a file containing resources and a resource could be listed multiple
times.  Their user ID is a key for reporting, but of course this is listed
multiple times as well.  
To handle this currently, another column was inserted with their ID’s copied

I'm trying to create a table where the list numbers dynamically update
from 1 to the end of the list.  Currently, I have the numbering so that
row one, is shown as "1", and then row two has a "=A1+1" function.  I
can then copy the row two formula for the remaining cells, and it adds

How can I use the key board to select all sheets.  I have about 91 sheets
renamed and can't get MACRO to work well.  I do change sheet names frequently
and don't want to edit a macro every time I do.

I have a spreadsheet that I am trying to sort.  The records are on two rows
with the first row, first column containing the record number.  I want to
sort the file and maintain the records.

What kind of formula should I use if trying to report "yes or "" for
cells G10, G11, G12 and G13 if the date is 4 months past todays date?

I have a quarterly time series and I always want to sum the last three
quartes of a year and the first of the next year and I can't think of a
simple way to do it.
e.g.

I need help with the following function:
if sum(P138*AC138/100)>0
then I want that sum (P138*AC138)
otherwise sum(AO138:AT138)

I'm trying to create several tables on top of each other where the
tables start at 1 and continue on until the end of the list.
Currently, I have the numbering where row one, is shown as "1", and
then row two has a "=A1+1".  I can then copy the row two formula for

I have exported a list of mp3's to excel and I would like to create a
hyperlink to each song. Is there a way to do this without going to each file?
I have over 3000 mp3's in the list I would like to link.
Please Help!!

how to install microsoft exel

I have a formula where I use multiple lookups to return several values, which
I add together.   e.g =vlookup(A) + vlookup(B) +vlookup (C)
If vlookup A = 1, B = 3, & C = 2, everything is good and the result = 7.
But in some cases the value one of them is looking up does not exist in ...

I need a formula that will, for example, if F4 on Worksheet 1 is >49999, it
will display the entire row 4 on another worksheet?

I've got a huge array of data (approx 13,000 rows X 15 columns). I'm looking
for a formula to replace the blank cells as I don't want to copy->paste
13,000 rows. I need the formula to look up the column to find the ID number.
The first column of data contains patient ID numbers.  ...