rows matching criteria

hi good day may you can help me to make a code regarding the table I need. I have a table w/ 5 columns (please see below) that I am running for now. <tbody> CODE DATE RUNNING HOURS REPAIR DONE MECHANIC FE25 29-Jan-18 5,000 CHANGE BATTERY RED FE26 30-Jan-18 4,560 CHANGE RIMS...

Hi guys, This is my first post on this forum so sorry if it's not clear but I'm hoping for some help with a formula. I'm trying to design a formula that will present people with a list of holiday destinations based upon when they'd like to go. On the sheet 'Countries' there's data with each...

Hello, I'm trying to develop a vba code to use excel as a search engine. I have created a cell which bears the input(in sheet(2)). I want excel to search for the input(which lies in the first column of Sheet(1)) , once it's found, take every column corresponding to the result and search for it...

Hello - I am having trouble with finding a value in cells in "A" (= "ethnic balance") and hiding rows in a certain range around the found value. Here is what I have started but cant get to work: Sub HideRows() Application.ScreenUpdating = False Dim i As Long Dim Lastrow As Long Dim hRow, uRow...

Hi everyone, I have a spreadsheet tracking monthly insurance payments. I want to create a list at the bottom of my spreadsheet that will populate with the individuals names that have not paid for each month. Each person spans across 4 rows. When someone loses coverage, I merge the 4 rows for...

Hi There I have a formula that is doing exactly what I want when on a set table on the same sheet where I can manually define the arrays... see below Sample Original Data: Table3 <tbody> A43 B C D E F G H I J K L M 44 45 Month Type Candidate Client TOTAL...

I have a very long list of data. Is there a way to quickly line up two rows?</SPAN> example:</SPAN> I import data into Excel 2007 and get this results:</SPAN> <COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> <TBODY> A</SPAN></SPAN> B</SPAN></SPAN> C</SPAN></SPAN>...

I'm trying to create a "find" feature for a workbook. Lets say I have a spreadsheet with 10 columns. I am looking for the word "apple" in any of the cells in those 10 columns. It may appear in the 2nd column or the 8th column, or any other column. It also most likely will not be the first...

Hello...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I need a little bit help... I think it should be easy code.. Looking to clear content in a row based on a value in a column. I am trying to clear all contents in a row based on the value of "Yes" in...

I have the following issue: Rows are populated with data based on date listed (Rows 6-20). The formula puts a " " if the date cell is blank since the range of data is not the same each time the data pull is imported. What I need is a macro that only copies and then pastes to another sheet...

HI, I am trying to compare rows of data that have the same key field identifying them. For example - EMPLID Compensation 1234 10000 1234 10000 1234 10000 1234 10000 1245 15000 1245 15000 1245 15000 For every row...

So I've started to play around with Excel a bit and stumbled on a problem which I haven't managed to find a solution for. It's a lottery game I'm making statistics of. In this lottery they draw 20 numbers out of 70 possible. I have gathered into a spreadsheet some of the winning numbers (that is...