I have a workbook where I enter the same data each time I have a client show up for a session. I have to fill in the same 10 values based on what they say to me each time. I like to leave their values from the last session so I can remember what they were talking about. I am wondering if there...
Hi guys, i googled and forumed many solution for progressbars. Some are way above my head (with kernel inputs, hardware keys, so on), so i try to made one for myself which easily readable and understandable.
I made a simple userform with 3 label. First is just for sub title, third is for text...
I need to print a set of user-defined sheets form a workbook and I want them in ONE print job, not individual print jobs. Reason being, I want to create a PDF file with 1-10 pages, not ten pdf files.
I can gather the sheet names the user chooses and put them in a place in the...
Complete macro noob and not sure what to do. I have borrowed a macro from this forum to select a tab based on the worksheet name
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Name Like "* Apple" Then
Hi all, Need some formula help (i think)
I need a RAG dashboard lookup formula, its based on a list of text. Ive tried a few things including custom number & index match but it doesnt seem to work.
Any idea on how i can do this? I have this list of data:
I have some script below in which I am trying to extract the information listed in the red box into an Excel file using VBA. Ideally, I would really love to get everything under the <div class="kioskDockDoor blueBg" line but I'll take any help I can get. I've tried multiple variations of...
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, _
Dim myRange As Range
Set myRange = Selection
ActiveCell.FormulaR1C1 = "=test" & "(RC[-9])"
Selection.AutoFill Destination:=Range("RC[-9]:RC" & Range("Selection" & Rows.count).End(xlUp).Row), Type:=xlFillDefault
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
I'm working on a vacation calendar for a group of teams.
I have the data in a table like this:
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...
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):
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...
I need some Help to this formula
That Part Works Fine
i now need a "Or function after that Working formula so it might look like that perhaps
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...
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)
SUMIFS with multiple possibilities for one criteria, can be solved using:
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...