solved

Using this: Private Sub Create_CSV() Dim content As String Dim Rng As Range Set Rng = Range("A12:AS30") Dim Path As String Dim FileName1 As String Dim FileName2 As String Dim FileName3 As String Dim sWB As Workbook, _ sWS As Worksheet Dim dWB As Workbook, _ dWS As...

Sub demo() Dim myRange As Range Set myRange = Selection myRange.Cells(1, 10).Select ActiveCell.FormulaR1C1 = "=test" & "(RC[-9])" Selection.AutoFill Destination:=Range("RC[-9]:RC" & Range("Selection" & Rows.count).End(xlUp).Row), Type:=xlFillDefault End Sub A B C D E F G H I J Text1...

Hi folks! I'm just trying to write a formula in a cell. if I use Formula2Local I got a '1004' Runtime error. Worksheets("SK").Cells(ACT_row, Col_VAL).Formula2Local = Aggr_costi if I use FormulaLocal everything run smoothly Worksheets("SK").Cells(ACT_row, Col_VAL).FormulaLocal = Aggr_costi The...

Hi. I'm working on a vacation calendar for a group of teams. I have the data in a table like this: group name location TeamA Person1 S TeamA Person2 R TeamA Person3 P TeamA Person4 S TeamB Person5 R TeamB Person6 P TeamB Person7 S TeamB Person8 R TeamB Person9 P TeamB...

Hi all, Long time lurker, first time poster - let me thank you all for years of troubleshooting and learning with pro's how to be a bit better in Excel. My question is around VBA - not very well versed in it - and will try to explain as best as I can. I have a list of countries with a score...

Hi guys I'm trying to put together a countifs statement but am getting a little stuck. I want the formula to calculate how many blanks are in the corresponding C column, if the value in the B column is 5. I managed the first condition (to count how many 5s there are in B): =COUNTIF(B2:B10,5)...

Hello, New to this forum, I thank you for your help in advance. I need dependent cells to follow the decimal formatting of a one parent cell. I've done this with format painter but my parent cell decimal requirements changes from time to time and I need the dependent cells to adjust and...

Hey Group I need some Help to this formula =IF(And(D9=1;L11=1);D12) That Part Works Fine i now need a "Or function after that Working formula so it might look like that perhaps =IF(And(D9=1;L11=1);D12)or If(And(D9=1;L11=2);D11) i have try that but it wont Work and not for any thing i...

Hi. I have a problem that is driving me nuts. Am fairly new to M code but thought trial and error would have solved my problem by now. Upside is I have learned a lot on the way even if I still haven't solved my problem. I have a (text) column called EntryDate with the date of all orders...

I'm trying to calculate a simple AVERAGE based on two source tabs 'Category' and 'Score'. Stipulations: 1) No helper columns on the source tabs; data from source tabs are exports from other systems that must remain untouched 2) Average scores on 'Result' tab should be calculated using a formula...

Hi there, I´m new in the VBA world and I´m trying to learn how to use it in an efficient way and at the same time develop a feature in my spreadsheet, see bullet 4 below: #1 Copy an activated row, insert a new row below and paste the formula in column(not formula) there (Solved) #2 Highlight...

Any Help would be appreciated. I had one issue solved on here today if I can get this one I would be ecstatic! Thank you! - Jessy

SUMIFS with multiple possibilities for one criteria, can be solved using: =SUMPRODUCT(SUMIFS(G10:G100,A10:A100,A5,B10:B100,B5,C10:C100,C3:C6)) According to: https://www.mrexcel.com/board/index.php?threads/821600/ But If I need to apply SUMIFS with multiple possibilities for 2 criterias...

This is my first attempt at building a Userform. It was actually going well and everything was working until I realized that one of my boxes was not posting a result. On the form I have a series of questions with Points awarded based on the answer. For example: It the answer to question 1 is...

I have a data sheet similar to this. I would like to know what I need to do to create formulas/functions that allow this to happen while running an advanced filter. <tbody> Rank(5 Star Rating System Name(Multiple duplicate names) Tier(Typical letter grade scale) 1 Name1 A 1 Name2 B 2...

Hi there, I have an export from our zendesk helpdesk and am trying to find the average time to solve a ticket. So far, I have tried to sum the Open date and the solved dates, then average the result. that seems to get me the correct answer ( i think!) until the first "solved date" is blank...

Hi, I want to replicate the search function from excel, but without going to the cell location when there is a value found. So I started making a search function myself. It works to the point that I can find a value in a selected cell, which is pointless. This is my code Private Sub...

I can't figure out why I'm getting this error only on this one row. All my other formulas on the Revenue Summary sheet work fine. {=SUMPRODUCT((MONTH(InventoryTracking[Date Sold])='Revenue Summary'!M2)*(InventoryTracking[Sale Price (Before Tax)]))} **no problems with this one**...

I have a tabstrip named ufRooms.tsWoodRun. Trying to disable all other tabs when selecting one so you can't accidentally select another before pressing the enter key. Anyone know if theres a way to do that? Thanks, Jordan

Hello, I have been trying to create a runtime tabstrip unsuccessfully. I have 4 named ranges I need it to populate the tab names from depending on which tab on ufRooms.tsWood is selected. The 4 named ranges are named the same as the 4 tab names on tsWood ie: Doors, Windows, Trim, MiscWood...