cell update

  1. F

    Count a update of a cell

    Guys, I got this problem: I have a task that is update every day with the actual date.. I mean the cell has to be update every day cause it is a daily task. What I need is a VBA code to count if this cell was update or not that day something like <tbody> Monday Tuesday Wed Thursday Friday...
  2. F

    Count a daily check up

    Guys, I have a control of daily check up ( if he did or not the acitivity in that day). It means that every day one person takes the scanner and read a barcode that update a cell in my worksheet with the current date. My problem is that in the other day i have a daily meeting and then I can...
  3. T

    Strange updating of cell behaviour

    Hi All, Ok, I have never seen this one before. I have a cell that contains a simple sum formula of the cells above. When I change the value in one of the cells above the sum cell, the new result is superimposed over the old sum value, making the result hard to read because the old value has...
  4. F

    Dynamic Formula Help

    Hello, I am trying to make a dynamic chart that will update when I put 2 columns of information in: Portfolio and Benchmark returns. I have everything worked out except one area, and it has to do with a date. I have maybe 100 different portfolio paired returns, so I made one master worksheet...
  5. R

    UDF formula not automatically updating

    I have a custom function written in VBA, and for some reason, my cells on tab 3 are not updating when I modify data on tab 1. The cells on tab 3 call the custom function which uses a date entered in a cell on tab 1. If I change the date on tab 1, the formulas do not automatically update on tab...
  6. B

    doubleclick linking

    I am using a worksheet that contains a column (e.g. Col. C) of dates (format is dd/mm). A second worksheet has one cell (Col. K, Row 3)that needs to be populated by the data from any one of the cells in Col C when I doubleclick on that specific cell. I would like to be able to jump to...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top