update

I'm using the below code to check for existing records (in case the user of my UserForm clicks "add record" instead of "Update" 'Checks for existing record in case user clicks Add record instead of update. Dim reference As String reference = UserForm1.Ref_Num.Value Dim aCell As Range 'Set...

Hi there, I've racked my brain, and exhausted google searches so hoping someone can help me. I have a bunch of data in a spreadsheet that I do not want to manually update when the quarter turns over. So I'm wondering if there is a way to do a conditional formula (and I know there has to be)...

Chase Credit Card issued this announcement: Please update your browser.We'll stop supporting Internet Explorer® soon. Choosing another browser will also help protect your accounts and provide a better experience. Update your browser I would prefer to use Chrome ver. 77. Any advice?

Hi, Hoping someone can point me in the right direction with this one.........thanks in advance. So as part of the company structure individuals have different access to spreadsheets based on their username. Some can only view certain sheets, some read only, some have full access etc etc...

Hello Everyone I'm Trying to Update my records through the form i created. not sure if its VBA or not! so any idea ?!:rofl:

I have built a macro that pulls data into a master sheet. Can i have this macro sit in one excel file on a network and create a second macro that would be in the data sheets and when clicked would open the network sheet and run the macro on the data sheet? Benefit being I can update the...

Hi I want to select/highlight random cells in a table then multiply them by 20% and then update these cells value. for example A1 = A1 * 20% Then after the update, I want to be able to highlight or select or point to the cells that I just changed their values. Similar idea to the Formula...

Hello, I have a userform with some comboboxes and commendbuttons, one of the comboboxes named "cmb_Name" In Sub UserForm_Initialize, I have below peace of code to show the suppliers names in the combobox Dim rngName As Range Dim ws As Worksheet Set ws = Sheet8 For Each rngName In...

I have been experiencing a problem with Excel, although before posting here about it, I thought I'd update my version of MS Office. I configured Windows (Windows 10, Office 2016) to update all MS products, not just windows. But still, my version of Excel is v.1812, which is dated to November...

Hi, I'm creating a spreadsheet with a list of all my employees, however rather than updating their availability daily, is there a code so that their shift is updated depending on the business day within every 2 weeks? Ex: Employee A is off on the 1st and 2nd Wednesday every 2 weeks, so when...

Hi, Just want to have your opinion on how to resolve the issue, i have Text field to upload in my Table "Short Text", and i need to update the field SI_ICXX to remove spaces, however, i think it automatically converted to Numbers. Sample SI field(Short Text):12333 02 01 i need to update as...

Hi, I have a scenario where in I need to update sum of the rows dynamically. R17=A#AC_1510201000 R18=A#AC_1510203000 R19=A#AC_1510127000 R20=A#AC_1510127000 R21=A#AC_1510777000 R22=SCalc(Row(19)+Row(20)+Row(21)+Row(23)) In the above example, Row 22 is sum of R17 till R21. I reworked on the...

Hi All, I need your expert advise to solve my small query, I have an excel workbook (say WB-01) with almost 25 sheets. In each sheet data is retrieved from other excel workbook via formula (vlookup) My issue here is that, my data in WB-01 does not get update until i manually open the file and...

Hi, i have the following which works but is there an easier way if the worksheet data matches the table? ie same no of columns as with 20+ columns to update it gets tedious typing it all out. Sub updateSQL() Application.ScreenUpdating = False var1 = Sheet3.Range("A2") Set cnn =...

Hi everyone, I use a macro to update certain worksheets in a workbook across 2 computers.. The problem is that i have 4 different macros for each sheet, I know i can put them all into 1 Macro to achieve this, except upon update because both workbooks are not always containing the same data it...

Debugger brings me to this line below in red. My file activityreportdatabase.xlsx is in the correct location and is not opened. I can manually update link with this file but it goes to the debugger when I do it with this script. The cursor in the debug window in on the line with...

Hi guys need help with vba code for userform Cells formated to date dd/mm/yyyy and use the isdate etc on userform....and if not a valid date wont accept....but noticed entering 07/12/18 will go into cell as 12/07/18...frustrating Also managed to get update button to update data with addition of...

Good evening, Can some one please guide me, am stuck with the adding and updating of the list box... My userform contains a list box which is populated by a range from a current worksheet ie the last worksheet of the book, I need only three columns to be shown in the list box, column"Q", "R" and...

HI i hope you can help i need a formula to update a cell if changes are made, my range is A2:R18 , ROWS B2:R2 have dates in and columns A3:A18 have areas in, then B3:R18 have numbers in. In Cell AC3 and AC4 this is a lookup for the date and area where it crossreferences and find the number in...

ws.Range("A3:H3000").Select Selection.AutoFilter wb.ActiveSheet.Range("$A$3:$H$275").AutoFilter Field:=5, Criteria1:= _ "=*Update*", Operator:=xlAnd The following is the output after running the filter above a b c d e 1 2 3 Name Title 5 D001...