newbie post

I am going to break down how I am understanding a portion of this formula below thus will lead to my question. Formula: =IF(AND(B$13<>"",$A14<>""),SUMPRODUCT((SUBSTITUTE($A$3:$A$10,"1/","")=TRIM(SUBSTITUTE($A14,"Site","")))*($D$3:$D$10=B$13)),"") The portions of the formula...

Hello I have the follow VBA code which stacks all of column A on top of column B and so on. What I need it to do now is stack all of row 1 on top of row 2 etc. So rather than having: A1 A2 A3 B1 B2 B3... etc. It would instead be: A1 B1 A2 B2 A3 B3... etc. Any help would be appreciated, thank...

Okay so on a pivot table if you double click a search result you get a new sheet showing the results. I am wondering if there is a method to replicate this from data returned by a sumifs formula?

I'm connecting to Analysis Services; I need to represent the data in # and % columns and not sure how to accomplish this. <colgroup><col><col span="2"></colgroup><tbody> System\Region\Location\Appointment Department 7/1/2018 # % Total number of scheduled appointments 100 x% Total...

Greetings, I'm not sure exactly where to start, but I have an idea of what I'm trying to do. I tried to think of a way to import all these excel files into an Access Database.. but I am not very skilled, I can use the out of the box stuff for Access, but can't seem to get it to do what I'm...

I'm looking to populate a field with the last date a row was updated. Currently, I have data in columns A - J and if any of those are updated for a given row, I would like column K of that row to be updated with that date. (I'm fine with date and time as well if that is easier). This is a...

I have a table that tracks a bunch of info such as, person, category, department, description, due date, and priority. I have, at best, extremely weak VBA skills, so I REALLY need help. Here is what I'd like to do, if it's even possible. I would like to have a VBA code that will...

I guys so I am a bit of an excel newbie and need some help getting my head around the best way to create an excel sheet for the data that I have. I have a CS background and have done DB subjects as part of my course work however creating an SQL database isn't an option in this case. The data I...

I am trying to use the Select Case function. I'm currently running into a run-time error "9". I know I am probably missing some basic VBA info, but I cant seem to identify what it is. here is my code Sub HistoryPull() With Worksheets("Data and Forecast-Prelim") Select Case Range("I6")...

Hello Everyone, I've gotten lots of help from these forums, but I've never needed to post before. Maybe this means I'm getting 'better' at vba because I'm attempting more ambitious projects. I feel like I've "beaten the system" whenever I figure out how to cause a computer to do some of the...

Hello everyone! I am trying to create a button which cuts cells Bx to Fx if the cell Fx contains the word "outlier" and paste it to a different part of excel sheet. My code seems to work up to the "Cut" part but stops at the paste. It has an error on "ActiveSheet.Paste" part of the code. Please...

Good afternoon, I'm a total newbie and am struggling with the correct formula to use, so please forgive me. I have two sheets in a workbook. The first sheet is titled Responses and contains 3 columns: timestamp, Student ID number, and pass type. The second sheet is titled Names and also...

Hi, I am new to VB coding and deperately need help... I have racked my brain but cant find the cause of error 1004 with this particualr line (highlighted in Red). Dim X as Long Dim iRow, iCol, intMonths As Integer iRow = X * intMonths 'X is the number of rows in Sheet1 with data iCol =...

I am new to using excel and was hoping someone would be able to help. I am wondering if there is a way to scan a barcode into excel and the have excel recognise it and count how many times the same barcode had been scanned. So basically have 3 columns Barcode, Product name and Quantity.

Hi, trying to write a script to be performed in Sheet 1 if calculated value in Sheet 3 is changed. I put this piece of code in sheet 3 just a test to see if I understand how to make an if statement: Private Sub Worksheet_Calculate() Sheet1.Select If Range("O1").Value = "11"...

Hello everyone, i am new to excel so please bear with me. in excel where you can select a column and sort it from high to low, how can you get this to be done automaticly as the data changes? Many thanks

Wrote this code to copy/paste data from a input sheet to a summary sheet Sheet3.Select Range("A77").Select Range(Selection, Selection.End(xlDown)).Select Selection.SpecialCells(xlCellTypeFormulas, 7).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Copy...

Hi, I´m trying to understand how to run a macro from Sheet 1 in a workbook that changes Sheet 3. Running this code Sub Test1() Worksheets("Sheet3").Activate Range("H4").Select ActiveCell.FormulaR1C1 = "A" Range("H5").Select Worksheets("Sheet3").Activate End Sub...

I am trying without success to get a basic VBA script to run (I copied/pasted it from http://www.mrexcel.com/forum/showthread.php?t=1321). I saved code to a new module under the current workbook in the VBA Project pane, and then saved workbook as a .xlsm file. I can't get script to run...

Hi, Can anyone advise how to set up a sheet that links in the last saved date and or time of a certain spreadsheet? Regards, Andy:)