receiving

I have a worksheet that will most likely be used by two people (a couple) but could also be used by a 'single' (unmarried) individual. I'll try to explain my conundrum. Here goes... The worksheet contains a cell with the following formula and it works as intended but I would like to modify it...

Regarding this formula: If there are dates in E8 (September 23, 1953) and H8 (April 1, 2017) the formula is returning "Started pension at 63 years and 6 months of age.". This is good. If both cells are blank, the formula is returning "Started pension at 0 years and 0 months of age." which is...

Hello, can anyone spot the obvious error in this code that is the reason for it not running please? Private Sub Worksheet_Calculate() Sheets("Data").Range("C" & Sheets("Data").Range("AD2")).AutoFill Destination:=Range("C" & Sheets("Data").Range("AD2") & ":C" &...

I cannot figure out why I am receiving the error on the last statement =IF(AND(A9=""),"", IF(OR($A$3={"D","DT","SR","V","X"}), IF(AND($D$3="YES"),(J9*5%+125)), IF(OR($A$3={"GE","SR","VP"}), IF(AND($D$3="YES"),VLOOKUP($A$3,'Company Info'!$A$1:$L$25,8,FALSE)*D9))...

I understand why I am receiving the error, is there a way to do error handling for the below code when "A3" is blank and "I3" = "YES" =IF(OR(C3="",C3="WG"),IF(AND(I3="YES"),"",""), IF(OR(C3="GE"),IF(AND(I3="YES"),(F3/A3),""), IF(OR(C3="H",C3="SR"),IF(AND(I3="YES"),(F3/1.05/A3),"")...

Hello, I have an excel sheet, that has several hyperlinks to file that are stored in a cloud (doc, xlsx, pdf ..etc). when I click the hyperlink is shows the file path, plus the below error message: some files can contain viruses or otherwise be harmful to your computer. it is important to be...

Greetings, I am having trouble with the last line. I would like to use a variable "a" to define the last row in the Destination range but am receiving an error. a = Cells(Rows.Count, "A").End(xlUp).Row Range("J2:BC2").Select Selection.AutoFill Destination:=Range("Cells(2...

I have a Macro code that runs smoothly on my first sheet "RA LOG" once the info is copied and pasted to "RECEIVING LOG" im having trouble getting the macro to cut and paste to "TROUBLESHOOT" sheet. Below is the code i currently have for my "RA log" Option Explicit Public Sub ra_log_execute() '...

I am in need of formatting this macro to my other sheets in my workbook. However, the problem i am encountering is that the second sheet "receiving" that the row data is pasted to has different columns and i need this to cut and paste to the third sheet "troubleshoot" not copy and paste. Option...

I want to look at one excel sheet called "shipping and receiving log", I want it to find a "serial number" ex. W-111, then go to another excel sheet called "Serial Numbers" and find the correct instrument type ex. Worker. I want it to find the matching serial number from the first excel sheet...