Worksheets("Sent to Assembly").Range("a3:c100").EntireRow.Copy
Destination:=Worksheets("Parts Sent to Assembly").Range("a3:c100")
Is there a way to keep the contents on the "Parts Sent to Assembly" sheet
once the "Sent to Assembly" sheet  contents are deleted. Thanks in advance.

I did something dumb.  When i copy and paste a formula, the correct formula
copies but the original copied number is displayed.
ie cell g4  (8)  - cell g5  (4) = cell g6 is, g4-g5, displays 4.00
typical copy and paste  

In cells A1 I have Name-in cell B1 Location C1Title E1 Hire Date F1
Salary.  I then have inserted A new Collumn D1 which is called
Service.  In cell E2 I have a Hire Date of 11/24/98 and in cell F2
Salary is $29,500.  In the newly formed Collumn D in D2 I have a

I am trying to extract a model number from the title.
Brand New D-Link AirPlus G DI-524 Wireless Router;
I need to extract the DI-524.  All of the model numbers have the - charcter,
but are different lengths.  How would I use the mid function, not knowing the

Value 1    Value 2    Value 3
1    1    A
1    2    B
2    1    C

How do I cause a certain column to be always to the right no matter what else
may be entered in? Stated differently, can I set up a column to shift over to
the right so that it is always the last one on the sheet?

If column 1 has data in each of the, say, first 100 rows, and Iinsert an
adjacent column 2 and ensure that column 2 is empty, then I enter data in the
first cell of column 2, then I try to copy the new cell down all the way down
to the bottom of the row that is the same as the ...

I have four columns on my sheet but I only want to sort one of them. When I
clicked that column's header to sort it but the "sort warning" pops up,
saying that there's data next to my selection. I tried to "continue with the
current selection," but everything turns into zero in ...

How do I stop excel from displaying stings of numbers pasted or imported into
excel as a scientific equation?  Like 5.73E+08 when the real part number is
549575667.
 The data displayed in the formula bar is the correct full number but Excel

Does anyone know how to access or open a SPSS data file.

i like to create one worksheet which link to other 4 worksheet.after that i
would like to change file name.i need your help.please my be you can.

I'm trying to use a vlookup formula and refer to a range name located in an
external spreadsheet but it is not working.
Formula is as follows:
=IF(ISERROR(VLOOKUP($B13,'S:\Reporting\Monthly\[AVNWcategories.xls]fata',8,FALSE)),"",VLOOKUP($B13,'S:\Reporting\Monthly\[AVNWcategories ...

I have the formula below that counts the number of instances of the
value held in A43 that appears in the range D9:AG35, but how could I
also include the qualifier thatonly count the number of these values
that are in Black font? Is this possible?

I am trying to write a formula that returns the results of 90 Days, 60 Days,
30 Days and Current based on outstanding invoices. I have an age of invoice
cell that tells me the age of the invoice and i want to write a formula from
that cell telling me from the current date which ...

I've "inherited" a workbook, and it contains the formula
=IF(A13<>"",NETWORKDAYS(B13,G13,Holidays!$B$1:$B$28),"")
The problem is that G13 has no value but the results cell has a value of
-28053 which makes no sense.  A13 has a value.