help in need

Hi , My name is Kristen I work for Tucson Subaru in Arizona. I have created a spread sheet to keep track of cars we are selling at auction. With as many cars we sell at auction we are anticpating this list to become very long, fairly quick! What I want is for rows to auto-hide after a car has...

I am trying to combine a vlookup and a countifs but no success =COUNTIFS('BAC-HELOC'!E:E,VLOOKUP('BAC-HELOC'!E:E,P:Q,2,FALSE)="MN",'BAC-HELOC'!J:J,"L") Maybe I am not writing it correctly. I am using the vlookup on a key that takes a bunch of different data and groups them So if E:E Finds a...

Hey guys, Literally had no idea of what to put for the title of this one but here it goes. So in a separate column say column E I want a formula that returns "true" when the following condition is met: B1 occurs for the first time in a unit but not any other time unless the unit changes. Units...

Hi, Example: I have created document in excel which is a map of an heat map of a area of London. The cells that make up that area change colour when the area becomes occupied. What I want to do is click the cells so it opens a pop up window of the data. Currently I have a hyperlink that takes...

Hi All, Issue: I am having issues with the following code to reach the desired outcome. I have had only some success with it in what I want it to do; Maybe I have misunderstood something :eeek: Dim LR As Long, i As Long, X As Variant LR = Range("H" & Rows.Count).End(xlUp).Row For i = 1 To LR...

Gday All :-) I am hoping if anyone could kindly please assist. Trying to achieve: VBA to delete all rows in a specific column i.e "A", where the value begins with "," Example Data: <tbody> Column A Bloggs, Joe Doe, John , Sam , Matt </tbody> Hopefully that does make...

Hi, I'm having trouble copying data from Access into excel. I have the following code: Option Explicit Dim RecordSet2 As ADODB.RecordSet, ExternalAccessTable2 As ADODB.Connection Sub testcode() Set ExternalAccessTable2 = New ADODB.Connection Set RecordSet2 = New...

I'm new to this forum and very new to excel as well. There are some things I can do but this i need is over my head. I've gotten a template from the microsoft template site to use for my employees taxes etc to calculate and add into a paystub. The spreadsheet works wonderful and is just...

The following code provides the srot of thing i am looking for However, this is comparing cell by cell, and where certain items are removed/added on the newer list it knocks everything out. Sub RunCompare() Call compareSheets("A", "B") End Sub Sub compareSheets(shtBefore As String, shtAfter...

Hello everyone! I am a new VBA coder and I'm trying to figure out this error. Basically, I am trying to create a macro that takes the value of one entry in the column, switches sheets and searches for that value, then copies the data in the columns next to it and pastes them back on the first...

Hey all, I am currently a student who is partaking in compiling my survey results. I want to pair the variables up in a row so that i am able to see a person's data more properly as shown by the table below. Ideally this is what i want to achieve. <colgroup><col><col><col></colgroup><tbody>...

I would like to add D5:D32 if E5:E32 contains the letter L. The entries won't just be the letter L, they will be L-133, L-145, etc. Can I use a SUMIF equation to do so? I can only seem to get it to add if only the letter L is in the cell, rather than if the cell contains L.

<tbody> 33 K 60 L K 77 L 68 J </tbody> HI everyone i am using this formula =IF(D4>70; "J"; IF(D4<50;"K";"L")). Do you have any suggestions what to do with the empty shell?i have the letter K appear when what i want is to jump the empty cell.

Hi Guys, having a little trouble with an if(or formula. It isn't returning anything, just the dreaded #VALUE!. Is it something wrong with the formula? Am I writing it incorrectly? =IF(OR(A2="CUSTOMER REQUESTED REVIEW",A2="ACCEPTED",A2="ASSIGNED TO PROVIDER",A2="PROVIDER ACCEPTS WITH...

I have a large table that holds cashflow values for every month from 6/2014 to 6/2035. I do not want to use a pivotchart because this is a template which will change often. I was hoping there is a way to aggregate the data so for example one column will be the aggregate amount for Principal the...

Hi there, I am looking for a formula that will tell me the start and end date in excel based off whether the cells are populated. so in row 1 I have the dates Below I have filled in 1's where there will be work for that week. I want to know when the 1's start and when the 1's finish based off...

Hi guys, I recently just started using excel and this forum and wanted to know how to make a spreadsheet that has automated subtraction in it. So when I enter a number in the subtraction box, it will automatically take away from the whole number in another cell. Then disappear so I could then...

Hey I am trying to run a macro that fill complete a v-lookup. The v-lookup is being ran in column C and its lookup value is coming from column A. The table array is coming from another workbook. I am wanting the v-lookup to run until it finds an empty cell in column A since the number of values...

Ok so.. I'm absolutely terrible at doing formulas on excel! I'm trying to work out what formula I would need to count up commission earned in a month so... When someone has passed 200 leads they earn £50 (as seen below) <tbody> 200 £50 245 £100 290 £150 335 £200 380 £250 425 £300...

Hello All! I am looking for some assistance. I am looking to do an average for travel times based on a certain day of the week. For example I keep the number of travel days in range AI2:AI100. My days are indicated in column AM2:AM100...