specific

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually...

Hi Everyone I have two spreadsheets. Sheets(1) is with unknown number of columns and rows. Sheets(2) is a list of profiles and rates. I need to look up the specific rate in Sheets(2) for the specific profile in Sheets(1). In Sheets(1), there are headings for 'Profile', 'Cost' and 'Rate'...

I create a account Statement and Invoices Workbook File, First sheet is the account Statement, and after each sheet will be a new invoice. I want each time I add a new sheet as a new invoice, as Copy Paste, a specific data from a specific cells in that new invoice sheet will go automatically to...

Hi I've got a macro that searches column A for a specific text then moves across to column D to copy the data in the cell. The vb script looks like this: Range("D22").Select However, the search might not always find the specific text in row 22 but will always copy the data from column D. Is...

I'm trying to create a stopwatch with a pause function in VBA for my excel document, but I have little to no experience in VBA. The other threads I have found didn't work for me (probably because of my lack of knowledge). I just want a simple stopwatch without using user forms as I want the time...

Hey! I have two dates that is always 7 days or less. And I need every each weekday to be in a specific cell. If the weekdays between the two dates is Friday, Saturday. It should be in two specific cells. The only code I have is below and its not working properly. Its not always showing every...

Hello Excel expert people! I have a string "165 / 168 / 170 / 172 / 68" that is present in a number of cells throughout my worksheet. Dependant on certain criteria, my aim is to format the text so one or more of either 165, 168, 170, 172 or 68 within those cells are formatted with...

Afternoon all, Scoured the forum and can't find anything that meets my needs. I'm looking to create a "library" of sorts that calculates an average score, based on a number of marking definitions. We often look back through previous months and update scores so I was trying to find out if...

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. Thanks

I have a file that I was assisted on by Fluff in the past. I am looking for a little bit of help. The macro that was created works perfectly and will split one table out into several tabs based on a specific name. What I need to do now is create an additional macro to create a completely...

I have a spreadsheet with 3 columns (C,D,E). In the first column there are general labels. In the second column there are more specific labels. In the third column there is even more specific labels. Column C will have many pairings with D, which will have even more pairings with E. I need a...

Hello everyone, So im trying to do two sums of an expense report. The first one might be simple but i just cant figure it out which is adding all the values based on a specific year range. The second is the one I'm really stuck on which is summing the values a given name but now i would like...

Private Sub CommandButton1_Click() Dim path As String Dim filename1 As String path = ThisWorkbook.path filename1 = Range("K2").Text Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:=filename1 & ".txt", FileFormat:=xlOpenXMLWorkbook Application.DisplayAlerts = True End Sub...

Hello all, I would like to INDEX/MATCH while confirming a "Specific" text. If any returns differ from "Specific" text, mark final return value as "No". If all match mark as "Yes". Any help or suggestions would be greatly appreciated. Modifiable Formula: =IFERROR(INDEX('Data...

Hi to all:) I want to count mails in outlook in a specific month in specific folders (of outlook) using excel vba, I alrealdy tried a code in this thread https://www.mrexcel.com/forum/excel-questions/293671-count-emails-outlook.html but is very very slow. I tried this code in outlook-vba...

hello, i'm trying to pull specific data from a column for a graph. this column has cells that have dates in the in format dd/mm/yyyy, but also has cells with the word 'pending' in it. i want to make a chart that includes the cells with a date value (and will be pulling in corresponding data to...

I really don't understand much VBA, so be patient with me. I have a list of people assigned to a specific flight (LEGID) and I want to copy those people (Worksheet "pax") to a specific cell in another worksheet ("temp" - cell b15), but it doesn't work. This data table is a query report from...

Hello all, I am trying to copy/paste specific cells from rows that contain the word "YES" into another worksheet. Let me say that I am brand new to VBA and just starting to understand, but am far from mastering this art. So far, this is what I have; it copies the cells from column D to AA...

Hi, I have a number of date ranges and what I would like to do is find specific days of the week within the range. For example, I have the date range 6/1/19-8/1/19 and I'd like to know the dates for the Mondays and Wednesdays within that date range. I'm looking to associate the name of the day...

Good day, I have been trying to clean up my spread sheet by removing helper columns and can't figure out how o do it. I have a main log with all of my data and another sheet as a request. I am trying to populate the request based on the contents in a specific cell matching the same contents on...