cell value

Hi, Im trying to figure out how to revert the value of a cell to a previous value after it have been changed, when an error occurs. for example, if I have a cell where I only want numbers to be inputted, but someone inputs letters, it would want the value in the cell to revert back to the...

Hi all, I really need help with calculating the SUM of 3 different values. I've got a spreadsheet for my finances, and my bills/outgoings. In Column A is simply the name of the bill i.e. debtor/company In Column B I have the date that the bill is due. In Column C I have the amount of the...

Hey all, l’m new here and hope I can get some help with a macro. I have a workbook that tracks data from employees and what I need is an automatic email sent to HR when either of two columns (column AE and AF) reach a certain cell value. It will also need to send another email with any increases...

I wrote a code that allows me to sort a long worksheet of data that consists of lists of objects that contain other objects onto individual worksheets based on the main objects name. The code works well but I am trying to simplify it. It is dependent on me knowing exactly what the object name is...

<colgroup><col><col><col></colgroup><tbody> A column B column C Column Name orders Quantity David Food order 100 David Friuts order 50 William Food order 10 William Friuts order 5 William material order 100 Rita Food order 30 Rita stock order 40 Rita material order 50 Rita...

Hi there, I am a teacher at a high school and am currently creating an Excel workbook to record students who need learning adjustments made. On the table I have various columns of data, with student names listed in column B with their CURRENT year level in column A. I’m not sure this...

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Value Result $A1 $A2 $B3 $B4 $G4 SG5 $D4 $D5 </tbody> </tbody> I have the values in the "Value" Column...

I have an order number such as 012, 013 in a separate sheet with details like <colgroup><col><col><col></colgroup><tbody> Order No 012 Status UserName Action Process Tom Await Approval Process Richard Await Approval Process Swetha Await Approval Process Michael Rejected Process...

In this code, if the cell value is having some special characters like "/" etc, it showing error. I need to exclude that error and remove the special character in the particular cell and rename as it is. Example : B1 cell is having " ABC/ DCF" While renaming the sheet, it should come as " ABC...

I have an order number as (o12) in a separate sheet with details as <tbody> Status UserName Action Process Process Process Process Marimuthu Rejected Process Gopi Approved Process Gopi Approved Process Process Process Process Gopi Approved Process Gopi...

So I know this is a really basic thing, but I'm kind of lost.. I have a worksheet named CAPA, and another named comp.norm. I need for cell D2 from comp.norm. to always have the same value of CAPA's cell C3, which will be changed constantly.. thanks for any help!

Hi, I have four buttons in my excel that show sheets using macro. The button works in the below way: D1 - Shows Sheet1, Sheet 3, Sheet 7 D2 - Shows Sheet2, Sheet 4, Sheet 6 D3 - Shows Sheet5, Sheet 8, D4 - Shows Sheet D9 For now we have hard-coded the values in the code about which...

Is there any way to make the value of a cell reflect the hyperlink location? I have a single workbook with several worksheets. I'm trying to create a hyperlink that will not only take you to another worksheet, but for the cell value (where the hyperlink is located) to reflect the worksheet...

Hi, I have created an employee schedule with 26 pay periods. Each pay period has its' own worksheet for scheduling employees. To help navigate to the worksheets I created a home page on one of the worksheets and would like to create an AutoShape for navigating with a hyperlink based on the pay...

Hi All Iv'e searched extensively and can't seem to find how to do this. I know how to filter based on cell value, and how to auto filter "does not contain", but is it possible to combine these? i.e. Filter OUT the value of a cell from a range? Appreciate your help in advance.

Hello Excel Folks, I'm trying to tell Excel to select sheets that are named in a cell—e.g. cell A1's value is: "Sheet1", "Sheet2", "Sheet4" I want Excel to do the equivalent of me clicking Sheet1 and holding ctrl while clicking Sheet2 and Sheet4. I can't do something as simple as Sub...

Hello,can someone help on this issue: I have two Sheets: 1. contains samples with number assigned for each sample 2. contains boxes with range of numbers for each box (start/end number) I need to assign box number to each sample based on sample number and box number range See attached...

Hello, I’ve really appreciated the support this board has given me as I learn VBA. I have three columns – Q, R, and S. I only need to see columns R and S if the cell values don’t equal those in column Q or each other. So if I have cell values like the ones listed in the example below, then I...

Hi I have a repetitive task that i am trying to slove by a macro. I have a cell with a number - lets say cell N4 = 5782.3 Now i would like to change the B4 Cell content to =IF($K4<>0,5728.3,0) How do i do it? I have tried the following: Dim a As Double a = ActiveCell.Value...

I've got a spreadsheet I need to average data in. I'm using links to pull my data from other sheets to this one. If there is no data, my other sheets display "NoData" in the cells. I did this because some of my data may contain zeros. I need to average the values of the cells that contain actual...