vba .formula

  1. H

    Need macro to move data from a cell into a new row

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

    VBA to insert formula and then fill down number of rows in reference column

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

    VBA Function for Hidden Cells

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

    VBA Code: Do Loop Based on cell values

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

    Opening Save Changes Dialog VBA

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

    vba code will not lock certain ranges after workbook save

    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 = "--"...
  7. Z

    How do I create a function to display the 'General' File Creation Date?

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

    Automatically open new sheet(Tab) and name it based on the specific value

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

    VBA Help. Drag colum to the last row with data

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

    If Cell is empty copy to other cell, HELP please

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

    VBA Macro to insert worksheet name and copy it down column

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

    VBA - Copy and paste entire row to second sheet based on cell value

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

    compare values in a range of columns in excel VBA

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

    Calling a function, click a link using VBA

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

    Paste data from One Sheet to Another

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

    VBA Custom Function to Sort and average two numbers of a range

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

    Modify Uptime formula in Excel VBA 2010

    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] = _...
  18. L

    Macro VBA Auto Detect and Change Cells

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

    new to macros- how to name and save excel document

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

    VBA copy specifc cells in sheet1 to specific cells sheet 2

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top