updated

  1. H

    Notify me if linked workbooks have not been updated

    Hi guys I have several granular data sheets all pointing to and dynamically updating a single summary sheet/dashboard. What I would like to add to this is some form of way of notifying me if any of the linking sheets have not been updated for the current day. Is this possible and if so how...
  2. P

    Excel 2007 - linking spreadsheets

    Hi I have two spreadsheets where I link information from one to the other. Each time I open I see the prompt to ''Update Links'' which I click and all is updated. Now I am starting not to see this prompt and the information is not being updated When I do see the prompt it also now advises that...
  3. N

    VBA to change color when cell updated

    I am tring to change color of a cell in a cell range("A10:F100") when ever a cell in a range is updated from previous value by formula due to change in other worksheet in earlier version of office(before 2007). Please help in this regard
  4. Z

    Record cell value before update

    I have a sheet that gets updated by a pivot table. What I'd like to do is record the previous cell value before it updates. So say in range B3:H109 are dollar values. Lets just say cell B3 has a value of $100. When the sheet gets updated cell B3 now has a value of $150. I'd like to be able...
  5. C

    compare 2 columns, in 2 worksheets, & if matched, return values from other columns

    I had to copy a worksheet from my working file (workbook), as its own single-sheet workbook, so a coworker could work on that data independently. (Not my choice, but what was required. :() So now, that stand-alone worksheet has updated values in it, but the worksheet it was copied from does not...
  6. C

    Slicer selecting deselcting

    I have a slicer called Rep I would like to walk through seletions on rep with vba. The list is not the full list in pivot field/slicer as I am only running for some of the reps. So I can set for first and plan to PDF screen deselect that rep in slicer select new rep in slicer make sure all...
  7. T

    Excel Question - Last Updated

    I am looking for a way to track the last updated version of pdf Files in another folder that I have linked to a power pivot. I saw threads about tracking last updates on sheets themselves but wasn't sure if there was anyway to track back updates/edits made on files in a different folder? Thanks...
  8. L

    macro table and chart

    Hi I started recording a macro. I created an empty table and then a chart (which is empty as well). The I stopped recording the macro. Now I went to second sheet and I ran the macro, the table and the chart was created. So far so good. But when I updated the first sheet table, the chart of...
  9. Q

    Automatically sort table based on a column when data is updated in that column (VBA)

    Hi, I have the table in the picture below. The cells D2:D26 are daily returns for stocks that are updated frequently (every 5 seconds). I want to sort the whole table A1:I26 based on cells from D2:D26 descending whenever the numbers inside cell D2:D26 are updated. I tried codes but nothing...
  10. H

    macro to copy and paste data from one workbook (which has 1 row of updated data) to an existing workbook using dates and data (which has a all the dat

    Hi, just seeing if anyone can help. so, i have the updated data in one row in an excel spreadsheet, dates start on row A6, Data to be copied is in cells C6:AV6. Dates is in Cell A6. The data and dates will get updated every workday. the cells range is the same i want the macro to copy the...
  11. K

    Running macros in Excel 2016 - screen flickering

    I've been running the same macros for years now, and it's been working perfectly in both Excel 2007 and 2010. But now my job's updated to 2016, and when I try to run the same macro the screen is flickering. When speed isn't a issue, I prefer to have "screenupdating = true", so that I can see...
  12. D

    how to get the date they updated it

    I thought this was working to give today's date when they updated the form, but then when they opened it =IF(OR($E24<>"",$F24<>0),NOW(),"")
  13. C

    need help to create a macro....

    Here is my problem... 2 excel files need to be merged. The new file has updated info i.e. calibration factors of equipment with unique serial numbers. the old file is with old calibration factors and past due dates. Also old file contains calibration factors and due dates not to be updated...
  14. E

    Copy last cell with number and Paste

    Hi, I need help in using vba to copy the last cell which contains only a number and then pasting it to the row beside. Assuming the value below the last cell in column one gets updated with a value For example, Initial <tbody> Column 1 Column 2 1 1 NA (this value would get updated) NA...
  15. M

    Formula disappears

    Hi, I am not sure if this is simple or not but I have a table that looks something like this cells A7:F7 contain formulas. the table need to be updated once in a while by inserting a new column, but when I do this, the formula disappears from the corresponding cell in row 7. [/IMG]
  16. T

    Need formula to find a value and then track its movement?

    Hi, I would like to track the movement of specific student in column B and use her value in column c, and track her updated movement in Column F, with the value in column G. Sorry if confusing, this may help: COLUMN B...............COLUMN C..........COLUMN F..........COLUMN G Lulu...
  17. R

    Getting desktop notification when a column is updated

    Hi people, I have an excel spreadsheet. It gets all data from external source, and refreshs itself in every 1-2 min. I need to get desktop notifications when a specific column updated and changed in my spreadsheet while it is running and minimized in desktop. Excel version is 2010. I have...
  18. A

    Auto-copy a new tab to an existing tab

    Hi all, I have a workbook with a sheet called "Sheet A" with formulas referencing another sheet called "Updated Report". However every time I generate that report from an internally made add-on software, it creates a new tab/sheet with a new name ("Updated Report1", "Updated Report1", and so...
  19. F

    Sumproduct for looking up and summing a range of information across multiple tabs?

    Hi everybody, I have a workbook with a summary sheet that needs to be populated by a number of info tabs onto which information is updated manually. The info tabs are in the same format as the summary tab, with item descriptions in column A, and data relating to this in columns C to N (the...
  20. L

    IF Function, if true then leave the cell unchanged

    Hi everyone! I'm making a company's stock application in VBA. I have a userform that adds orders details (including unit prices) to a sheet and I want the unit price added to be updated on another sheet (with the current stock). The updated cell would have the value added through the userform...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top