Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Worksheets("Sent to Assembly").Range("a3:c100").EntireRow.Copy
Destination:=Worksheets("Parts Sent to Assembly").Range("a3:c100")
End Sub

For some reason the error #N/A is showing up throughout my worksheet.  What
is most confusing about this is the formula(s) being used in different cells
is correct.  Cells above or below the cell with #N/A are computing correctly.
This just started and I can't seem to find the ...

I have a spreadsheet for payroll that needs to calculate federal income tax
to withhold. How do I set up the spreadsheet to calculate the tax?

Is there a function to see if the value of a cell appears in a range of cells?
I want to see if the value of cell A1 appears in any cell B1:B5. In other
words, if my sheet is such:
351 | 219

I am trying to work a problem for a random number generator.  Essentially,
the random number is being generated by using two random number generators (X
= 1 to 100 and Y = 1 to 100) and then dividing X by Y to get a seed for the
random nujber.

This If-Then will only return "0" or "3.4" depending upon the contents of H8.
How do I modify it to give me the number I want based upon the contents of
H8?
=IF(H8<=10,3.4,IF(H8>=10<=20,2.7,IF(H8>20<=30,2.3,IF(H8>30<=40,2,IF(H8>40<=80,1.8,IF(H8>80,1.5,))))))

I have an XLS which is updated throughout the day with new rows of data
I want to capture the time each row is input. Ideally when a specifi
cell is input I want to put the associated time at the end of the ro
soI can calculate the time between each row. I have tried the obviou

If you are referencing a cell in a formula and you want it to remain the same
when you copy and paste the formula into another cell, how do you enter it?
Susan

I would like this formula to work only if the value in O188 is a number. If
it is not a number, return 0 (zero).
=IF(O188>=$E188;1;0)
Thank you in advance.

i have aproblem in giving offset reference
                 I               J
 3    500    600
 4    1.2    0    0

I recently had a problem when I was viewing a website and a number of things
happened to my PC.  Most I have fixed, but one remains.
I have many Excel spreaksheets with hyperlinks to .jpg files for many years
with no problems.  The links are ok in the spreadsheets.  I use to click ...

I have this formula in cell A2
=LOOKUP(B2,{" ",19,50},{" ","1","2"})+A1
if I enter a value in B2 it works fine but if I leave it blank I get an
error that a value is not available.

I need to add alternate cells in a single column. The cells contain a formula
result summing values in rows to the left of the result cell.
The cells to be summed in the column are formatted to display results in
currency format.

How do I keep the array absolute in my formula when data is added to the list
that it refers to? "A$1$:E$40$" does not work. When data is moved in the
list, ie; when sorted, the array referenced in Vlookup moves with the
original data.

I have been using a formula provided by Bob Phillips here to determine who
would the total number of t-shirts by size based on monies raised. In the
past, it has been the same amount of monies for everyone. Now, we are using
one amount for adults and one amount for kids.