exccel

Hi all, I've got a table with 4 columns(B~D), Item, Store, and Time. In Column E, I want to write a function that looks up the value from "Item" and "Store", then returns the value of "Time" of the last row where both "Item" and "Store" values are matched. So for example, E3~E9 will have the...

Highlight cells in column A Green if on the same row in column G is Yes this is what I tried [=VLOOKUP(A2,A:G,7,0)="yes"] what am I doing wrong

Is there away I can but a button or something like that. That when press it will clear all content for a lot of cell but they are not all in the same row

I have a list of names in column c4:c40 the lookup list of names is G47:G86 and over 5 to v47:v86 that is the list were it says Terminated

Hi all, My skill in translating logic into a formula and especially VBA is very limited. Hopefully the below makes sense. Basically I was hoping for a VBA code that pulls through results on to a new sheet by using the reference column A (Order Ref) in Sheet 2 and comparing columns of the...

Hi, Hope you're all well! I am somewhat of a novice when it comes to VBAs/Macros. Just really know how to enter codes and run them - hopeless when it comes to understanding what is what etc. I have a long way to go :) Basically, I was hoping for a code that will compare 1000s of entries in...

I was asked to keep track of a project and need to report on its progress every month. The raw data will be names, office locations, current model assignments, new model assignments, and the date the new model was reassigned. Initially, I was going to create monthly tables based on this data...

I have a formula that works but need to put a twist on it to look at another column / Sheet. {=IF(ROWS(E$5:E5)<=$B$8,INDEX(INDIRECT(E$4),SMALL(IF(Date_Received=$A$8,ROW(Date_Received)-ROW(AuditLog!$B$2)+1),ROWS(E$5:E5))),"")} This is working. I need to add this to it...

Im trying to upload a container with boxes , so I need to tell the sheet how many boxes do I have and all the rows will be like (the first row 6,6,6,6,6,3) and I need to know in which row the product will end. Thank you.

Hi, I need help, please. I saw a few options but nothing worked so far. My problem is this: I work with two sheets on the same file, "RawData" and "FinalData" RawData is summarized data from PowerBI and it varies in the number of rows. I added a column on that sheet with a condition, with Copy...

Public Sub Move_Files_To_Matching_Folder() Dim sourceFolder As String, destMainFolder As String, destSubfolder As String Dim FSO As Object Dim FSfile As Object Dim FSsourceFolder As Object sourceFolder = Environ$("USERPROFILE") & "\Downloads\" destMainFolder =...

hello programers can you help me i need a program every 1 hour auto check email inbox outlook if the email body content write ( please file)this email is move to the 1 specific folder like "download folder'' .i hope u are understand my english is very bad english..

I found this bit of code to remove rows if it contains specific text. It runs slow on 8000 lines, would like to add more than 1 text "Dog,Cat,Chickens". would like it to be lighting fast Thanks Sub DeleteRowWithContents()...

I Have data in a column like below a set of emails and associated numbers all in a sequenced flow. I want this to be transposed somewhat with their corresponding sequence on the same row in different columns. How can this be done So, for example John E something@domain.com 50. 22 Margaret S...

Hi guys, how are you? Guys I don't know which one logic I need here to place dates by counties by months. I need place only earlier date in my Month cell. Example If I have date: 01.01.2020 , 05.01.2020 , 07.01.2020 then I need only earlier date from January = 01.01.2020 in cell Date 2020 I...

I'm trying to copy rows from one sheet to another worksheet based on a number of criteria (currently from a dropdown). I am currently able to do this for non-dynamic (non-changing) criteria using either an excel formula or VBA coda (which is much faster). However, how can I set up my macro so...

I have three columns that give in order the number of small items (column A), the number of medium items (column B) and the number of large items (column C). Each of the quantities can be anything from 0 to 999. There is a charge made for the total number of items. The charge is calculated on...

<tbody> Column A (Date Ready) Column B (Done?) 28/08/2015 Yes 28/08/2015 Yes 28/08/2015 Yes 28/08/2015 Yes No No 30/08/2015 Yes 30/08/2015 Yes 30/08/2015 Yes </tbody> Default value is a 'No' - however after a date is populated to Column A, Column B can then be made a...

Hello! I'm extremely new to VBA and need help on my code. I wanted to create a userform that was a data input form, it's for a contact list and this makes it easier for my coworkers to add the clients information. It works some of the time but other times it just freezes excel and it becomes...

Hi, i have problem with excel form. If I show Userform, then unload it and show it over and over again, i get error message. It's visible in attached example. After click on start, excel will show and unload form over and over. After count reaches ca. 102 (<2 min.), excel crash. It's...