vba .formula

Hello MrExcel forum. I'm a long time reader but first time poster. I have an issue with groups of data in a row, that I need to copy into a new row beneath the original. I need a formula or VBA that will perform this function: If any data is present in columns AG-AK, then copy that data into a...

Hi everybody, I am trying to insert formulas to my cells in different columns and then fill down the formulas as many rows as in the reference column. So far I have put my formulas in a macro but I seem to get problems with " and ' symbols. My macro looks like this: Sheets("Sold Articles...

Hey guys, I am pretty good with Excel, but am new to programming with VBA. I am trying to make a function that will only show the value of visible cells (so I can have excel calculate a slope/offset of a filtered table. I made the function below, and it seems to work pretty well. Option...

I am trying to create a macro that copies and pastes data based on two things. The datediff value I specified and the policy number. There are tons of policy number that are added and changed constantly. Also, is used for multiple rows. So if I wanted to select all the rows with the datdiff...

Hi, I have written a workbook_beforeclose code that updates another workbook and then change a cell on the workbook with the time updated and lastly opens a msgbox telling the user telling if it has been successfully updated or an error occurred. Currently, the "save changes" dialog would open...

I have a range of cells with data that i want to lock after/on save if certain criteria is met. code: Sub Workbook_AfterSave(ByVal Success As Boolean) If Sheets("JANUARY").Range("BE10").Value = "--" And Range("BF10").Value = "--" And Range("BG10").Value = "--" And Range("BH10").Value = "--"...

Apparently there are two types of Creation Dates for a File, and both of them can be viewed in the file properties. Statistical Creation Date: shows what date and time the 'original' file was created - stays the same even if the file in question is a copy of the original. General Creation Date...

I have an excel with master sheet (TAB # 1) of employee's name (master sheet data range is B1:B100 ) . When i add a new employee name in another sheet (TAB # 2 data range is C1:C50), the macro should search in TAB # 1 (data range is C1:C50) , if the name entered in the TAB # 2 doesn't exists in...

Hi, I import data from a raw cvs file and run formatting macros. However i want a unique number on each row in the A colum which will be used as a primary key in access. I have made the formula to generate a unique number, but i need a macro to drag down the formula to the last populated row...

Hello all, I am trying to write a macro and I want it to do the following: If the value in column A is empty, then copy value in G+1 column, (+ 1 meaning but one row below) and paste it to G+2. Do this for all the empty value in A column. After that delete all the empty rows. Thank you for...

Hi, The following macro copies two columns from every sheet in the workbook and pastes them into column B and C of the sheet named Journal entry. I would like to add to column A of the Journal entry worksheet the worksheet name for which the columns are being copied. Once I have the worksheet...

Hello, Today I finally taught myself a basic understanding of macros/VBA. I've made a lot of progress on my project, but am stuck at the moment...Here's what's going on: I have a sheet titled "All Trades" that contains the raw data like the example below. I have two other sheets titled "As-Of...

Hi, After looking up this amazing forum website for answers, I decided to post a question because I do not understand excel vba all the way.. So I have values in Column L3 to AH3 and I would like to use if condition to see which values are less than 10. I also have other rows where this...

Hi I wonder if someone might know this: I want to get an excel file from an IE page and open it and use it in excel. The page has a database and allows, by clicking, to “export data as excel”. I am creating an IE object using “CreateObject("InternetExplorer.Application")” I am facing two...

Hi All: I'm trying to copy data from one sheet to another. The following code is working but the problem is that it only copies the first line and it does not select any other breached or warning ticket(see attachment) If you open the sheet the code won't work because I set the Range to...

Hello. I need to create a custom function that can do the following without modifying the selected range. If I have data in a row, I need a function that can give me the following result: Original unsorted data: 79 45 23 56 1 The custom formula will not modify the selected range, and after...

Excel 2010 Windows 7 Hello, I'm at a beginner level in creating Excel formulas and using them in VBA and need to change the formula below to reflect a blank cell if there is no data to calculate rather than reflecting a 100%. [SAT_UPTIME_METRICS1] = _...

Hello Everyone, I am hoping one of you could be of assistance. I am a novice and trying to figure out how to write a code that does the following: if cell A1 = x,y, or z, then a certain cell range will be displayed automatically without using a macro button. A1 = X display cells A10:G14, or...

I'm in uncharted territory. I know nothing about macros or vba. But I watched a Mr. Excel video and figured out how to create a macro to auto sequential number electronic requisitions. I also figured out how to name, save and clear via a macro. I want to edit the "name" portion of macro as it...

I am looking to modify the following code so that only B and D are copied from sheet 2 AND the results are pasted in c and d in sheet 3. Any help will be apprecaited. Thanks Private Sub Worksheet_SelectionChange(ByVal Target As Range) Sheets("sheet2").Range("b1:d10000").Copy _...