excal

Hello Guys, I m trying to make sumproduct formula working and i m stuck with it because it seems that it count as well my empty cells. I have data in column A and column B and i m trying to compare both columns and count when value from column A = column B. This is the formula...

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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