updated

My laptop Office suite has been recently updated. Office, i.e., Excel, in my virtual workspace has not been updated yet. My ComboBoxes in identical files only function completely in my virtual workspace where Office updates have not taken place. I copied a file over to my laptop (updated Excel)...

I am working on a project for a companies payroll. What I am doing is taking payroll data and using a button to automate and organize the data to enter into our accounting software. I am moving along nicely, but the problem I am seeing is when an employee leaves or are added and their VBA code...

Is there a way to insert the names of the sheets into formulas. for example on sheet 1the formula is A30 has if(a2<a50game,if(a5>49,"***","" There are hundreds of cells with formulas, and want to know if there is a way to have the formulas updated to...

Hi, I am looking for a help to create the checkbox. In the spreadheet column A1 to E1 has to be updated manually. Once the data is updated, i am looking to have a checkbox created in F column, if i tick the check box, first requirement is 1) cell A1 To E1 should get locked 2) in cell G1...

Good Day I have a short macro to run when a cell is changed in column 2. This works, however it only executes when re-selecting the cell after any changes, rather than running when moving away from cell. How can I get this macro to run referencing the updated cell, when moving away from this...

Very complicated one here so I won't explain why I need this.. I want to create a button that when clicked a pop-up appears saying "Enter URN". When the user enters this info, the record with that URN is updated. It will update by adding a number to the 'CompNo' field which will be Maximum...

Dear Members, I would be extremely grateful if anyone could guide me in the right direction. I have appended two sheets using power query and made combined report. How can I make sure that if I make an entry and that entry is also updated in combined report ? So, I would like to enter numbers...

Hi All, I am currently using an index/match formula to bring score data from one table to another. The problem I am having is that it is assigning a zero value in fields that have no data. This is causing an issues when I am pivoting out the column using that data. We have two set of...

Hi All, I am using an Index/Match to look up value from another table, and using that data to pivot out average scores. However it is placing zeros in the filed that have no data, which is causing Excel to count that cell. What would I need to do so that a zero value is not returned and...

Hi guys, I have to following problem: in a workbook with many sheets I have to update several worksheets (Store A,B,C,D,E,F,G,H, etc). But I would like to have a overview sheet (Info) where all worksheets are named with a time stamp when the sheet was updated Overview sheet is called Info...

Hi there, I was recently updated to Windows 10 frm Windows 7 at work. My co-worker and I share a spread sheet in which we have to input info and refresh. All was well until I was updated. The problem lies in the date format. In Windows 7 the existing power query using date.to.text fuction is...

Hello Mr. Excel! You guys are always extremely helpful, so I have another question I would greatly appreciate your help with: In column P I have a list of Unit #'s that need to be updated in an online system. In column BA I mark off units that have been updated (I type the word "Yes")...

Hi! I have a macro (that works) in alla other aspects than the opening of the textfile that contains the data I'm to use. The files that should be opened (by a loop?) is updated monthly and named in sequential order. There are however some characteristics that each file have that allows me to...

hi all. i'm trying to work with live data updates on onedrive.. but can't seem to get things to work seamlessly, so i'm toying with the following; Sub TESTOPEN() Application.ScreenUpdating = False Dim wb As Workbook, sh As Worksheet Set wb = Workbooks.Open("MYFILE") wb.RefreshAll wb.Save...

Hello, I have a tab called "Control" On the "Control" tab I have a named range called "ProjectIDs" "ProjectIDs" has a range of abut 24 rows and contains the worksheet names that would like updated when I run the macro. However, I don't always have 24 worksheet in the range filled out. I may...

I am using SNAP to Excel feature for real time data from my trading terminal provided by sharekhan. The Price gets updated automatically tick by tick every second. I am wondering If I can save that data in another sheet and then can use for later analysis. here is the image of excel sheet...

hello & good evening, I use the following code:- Private Sub Worksheet_Change(ByVal Target As Range) ActiveSheet.Unprotect Dim rng As Range Dim rng2 As Range Dim cell As Range Dim r As Long Dim c As Long Set rng = Intersect(Target...

We have spreadsheets that use data connections queries from CRM software. I have updated the spreadsheet with formatting, some VBA code to sort the data, etc. When we update the CRM query, we have to export a new spreadsheet to capture whatever we updated. Anyway to copy that data connection...

I have an Index|Match formula that references a password protected sheet. I am finding if I make a correction in the referenced sheet, it is not getting updated in my original sheet that contains my lookup formula. Any ideas? Thanks!

I have pasted a sample data set below with required output format, Kindly let me know if the desired output can be generated via formula/Macro. In my dataset fields are populated with 3 Keywords - Found, Not Found, Updated. I have to consolidate the headers for output field based on the...