updated

I'm trying to use Icon Sets to indicate the 'Age' of the last update made to the file but only want to display this 'Aging' icon when the Status IS NOT certain text values. Here's some sample data: a b c 1 Date Updated Status Icon 2...

I have column with a mix of numbers, so contain zeros at the beginning but most don't. Some members have 1 or more zeros in front of the integers. I would like to remove these zeros with a formula but not quite sure how to do this. Here are some examples of the ID numbers that I have...

I have text in D1 and would like to extract the month and year - 30 days i.e the previous month and the current year Book1D1Date updated: 18/01/2018 17:07Fixed assets ReconCell FormulasCellFormulaD1="Date updated: "&TEXT(NOW(),"dd/mm/yyyy hh:mm") The month is Jan 2018 in D1 and I would...

Had a simple code to disable the F1 key that worked great in Excel 2010, got force updated to '13 over the weekend and now I get this error when I launch Excel: Run-time error '50290': Method 'OnKey' of object '_Application' failed And the code I use is this, saved into ThisWorkbook on the...

Hi All, I am sorry for my adolescence by asking something seems to be impossible for me. I am stuck up with one of primary requirement for my daily routine work. The problem is defined below: 1) The Invoice database is to be auto updated in Master database by replacing the existing content...

Good day, I am trying to create a way to capture/report the last date that a certain field in a table in my database was updated with a certain value (from a defined list in another table). Is there some way to do this? Thanks in advance,

I’m trying to create a bar chat that will always refresh to the previous month’s data, but keep the bar chart for previous year the same. My bar chat will have 4 bars: 2015 bar, which will always display data for 201512(dec 2015), 2016 bar which will display 201612(dec 2016), 2017bar which...

I'm looking to populate a field with the last date a row was updated. Currently, I have data in columns A - J and if any of those are updated for a given row, I would like column K of that row to be updated with that date. (I'm fine with date and time as well if that is easier). This is a...

Each employee (6) has an identical workbook, one of tabs contains a list of data which each employee will be adding new entries to every minute or two (Order Number / Account Number / Name / Etc). I would like to find a way for a master list to get updated with each employees new lines of data...

Hi, I'm breaking my head with the following problem I have 6 cells,(A1, A2, A3, A4, A5, A6) that should be updated with a value of a specific cell "T5" a single cell per day should be updated. in Sunday: only A1 should be updated. (with the value of "T5") in Monday: only A2 should be...

Hi. I have a database in sheet I Want to change Colour of Cell A5 and related Cell, if Any Value of Cells A5:Z5 is Changed.. i have a code which changed cell colour , if cell value or cell updated even with F2(Not Data Changed), but i want with this cell , Column A cell is also changed...

Hello, I was wondering if it would be possible to have a message box pop up after an update to a record has been made stating what field or fields have been updated. I have update 20 fields that can be possibly updated, but not all will be updated. Instead of showing a generic "Record has been...

I'm using excel query to generate a table based on JSON style online data. This table is automatically updated each time the file is loaded or "Update All" button is pressed (this is how it should work). What I want to achieve is getting the cell data from this query table and paste it in the...

I have a form that is pulling data from a worksheet, contingent upon the selection made from a combobox. I've coded other forms to update worksheets, but I'm struggling to find anything that makes sense, that guides me on how to code so that when a command button is clicked, the data sheet is...

Hi, Could you help me with writing a simple macro which does the following, please: Ask for the file location / path Get (copy) the values in cells C2 to C200 in the tab XYZ of the specified file Paste the values transposed, i.e., in a row NOTE: I would like the link to each cell to be...

Hi, I am working on a shared file which is being updated by multiple users. I am not able to track who changes what. Can we have a "Update Log" sheet which captures the following details - 1. Date & Time 2. Modified by which User 3. Sheet Name that was updated 4. Cell Reference 4. Old value 5...

I have situation where we have an ongoing survey where the survey file needs to be merged with a master member table to bring over certain fields (age, gender, ethnicity, political affiliation) in the survey table for analysis. I tried to create a one to many relationship in Access and PQ but...

Hello all, Forgive me if this has already been asked before. I can't seem to find what I need in a search, probably because of my terms. I have a row in a spreadsheet that I would like copied to a row further down. However, as more columns are edited (this is kind of like a running calendar)...

Hi all, hope someone can help. I am new to vba and looking at how to apply the following. I need data that is input into the text box to pull through to a worksheet, not to specific cell. As the user form will be updated monthly I need it to reference the month and year, that the data being...

I basically get my Data from external dashboard through Copy then paste matching source as Get data from Web function is not possible due to IE limitation. the Data however, when I paste to excel would only be on Column A, that is fine but I need to process it just like in my Example Column B...