excal

  1. D

    Need urgent help in excel please

    In a cell that is continuously changing every second, i need to monitor that cell and detect its highest & lowest values during a day, how can i achieve this, pls help
  2. F

    Deleting Rows in multiple sheets using VBA

    Hi all, I have a workbook in which i have multiple sheets currently maxed out on line limits. Deleting the lines manually is taking forever so i wrote a macro which will delete any line in which columns B, C, D, F, G and I have a 0 in them. I'm getting an issue where the code only goes to the...
  3. R

    Fetch Value Available on Same Interval

    Hello Everyone, I have a sheet contain lots of value in rows. please find below for example: if you see , difference between Fruit and Place is equal i mean 3 rows Same Apple and America has same interval i e 3 rows I want Fruit in B1 and Place in B2 and in front of B1 it should be apple in...
  4. B

    How to sort 540 excel files based on H column by a VBA code?

    Hello all I have 540 excel files (different in file names) in D:\Mrexcel\Fluff. The inside arrangement of them all is similar. The only difference is in the position of the last cells. Some have 6 rows in total, and some have the last row in 700. I want to have a code to sort all the files by...
  5. E

    Copy and Paste from one Workbook to another if the condition is met

    I have a Folder with Excel files and one of them is the main Excel file which Looks like this: <strike> </strike> and the other file( Workbook 2 as an example) wich i want to copy from Looks like this: <strike> </strike> I got a way how to open a file Dialog and get the file that i want but i...
  6. G

    Index and Match formula to return header that contains the min value in range

    Hello i am really struggling with this. I have a macro that takes raw data into a certain form. My range is AK:CH. However, there are certain columns that I do not want to include in that range. The columns I want to evaluate contains the text "Height". Cells(PoleRow, 3).Formula =...
  7. T

    How to VBA Autofilter remove ranges so it is dynamic

    ActiveWorkbook.Worksheets("Sheet2").AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets("Sheet2").AutoFilter.Sort.SortFields.Add Key:=Range _ ("AB1:AB97515"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With...
  8. D

    VBA not picking up Formula populated cells need a new trigger?

    Hi All, i have the below code which runs when a cells is populated (but only works when manually populated). i have cells that are either manually populated (which it words fine for) and some that are populated via a formula (which is does not work for). do i need to change the trigger to...
  9. M

    How to Update an Excel file Module by using a sub routine from another workbook

    Hello, I have same file is used by my coworkers, sometimes I need to update my codes on those files, I am looking a way to send a new file with most updated codes, so they can update their files simply using a update button in my send file. I know this needs VBE coding, but I am not sure if...
  10. D

    Remove Values From Columns When Another Column Has A Value

    Hi, i have the below macro which removes values in column H when column I has a "Yes" in. is there a way to change this into an automatic VBA that runs in the background? Sub Remove_Column_H_Values()' ' Remove_Column_H_Values Macro ' ' Application.Goto Reference:="R7C9"...
  11. A

    Need to add duplicates in a format

    I have 2 sheets that i need to merge into one but the format is not as simple so it cannot be just copy pasted. But i feel there will be a way to do that with a vba. Hoping to get a solution from here. here is what I am looking to do. First column is "Source URL" and Second column is "URL"...
  12. S

    Past 2 weeks weather

    Hi I'm trying to display the last 2 weeks weather and the next weeks forecast in my worksheet. I've tried to use power query to select just the forecast. But I'm having difficulty finding a website that displays either items that i can use. I was able to find this...
  13. D

    Max Look Up with Multiple Criteria

    I have a time sheet Table that I pull from Share point and it's linked. to fill the table I have 4 criteria that must be met .Any formula I use It gives me zero result and don't show me the actual Time in the time sheet. Can you help me? Employee Name Sales Manager ClockType Date...
  14. H

    Find relation between two columns

    Hi, I have two sets of columns that I am quite sure there is a relation between them (i.e. C12=SUM(A1:A12)*5), but yet I can't find it. Any ideas?
  15. F

    Sum based on part weeks

    Hi, I'm struggling awfully with this but am unsure why... I have A1 - 3.4 - meaning 3. weeks A2 - £150 - Daily rate A3 - Week 1 A4 - Week 2 A5 - Week 3 A6 - Week 4 A7 - Week 5 the only variable is the length, this could be anything from 0.2 to 5.0, .2 denoting 1 day in the week, so .4, .6 .8...
  16. J

    Word 2010 Mail Merge to save to individual .docx files

    I'm new to VBA and have not worked with macros in word much. I have a form that is a large table covering an entire page. The form has custom margins: TopMargin = (0.5) BottomMargin = (0.19) LeftMargin = (0.6) RightMargin = (0.6) I have been attempting to do a mail merge to add assigned acct...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top