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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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(),"")

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...

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...

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]

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...

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...

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...

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...

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...