info

So I have a column with information like this: XC-163 0827m Timber problems 0600m failed picture cv-76 ligts out 0987m p3 etc What I need is to create a column only with the measurement info in it which goes behind the m, in this case: 0827 0600 0987 Any ideas of which functions I can use...

I am using this Excel calendar https://support.office.com/en-us/article/Excel-calendar-templates-F2E7FFE9-41FA-4CE5-8278-CF92D3B66340 and while it seems OK, it is a pity that info added to specific dates is not copied through to same dates when modifying the year and saving it as a new year...

Hello, I have such info in a table (provider, purchase order nr, date when it has to arrive , comapany inside code for this part, part numeber(providers) quantity <tbody> MOUSER ELECTRONICS ( ES) ERGR180829-1276 2018.09.17 0 12R-00548 MMSZ5246B-7-F 10 </tbody> and info from...

Goog Day, On cell C41 I want to put a formula which will calculate the total sum with the conditions below. I've created a table from B6:D40 There will be numbers from B6:B40 and C6:D40 will have the letter info as X My target is to get the total of those numbers.But if there is no info on...

Have three tables: Project, materials w/qty and material cost. Project and materials have a relationship. I want to build a query where the info from these two tables can show the info and the material used will go to the material cost table find the cost of that material multiply it with the...

Dear Forum, I need some help as I have no idea how to tackle this challenge. I have data in the following format (about 7000 records): <tbody> User Project Code Transaction Date Hours Allocation Category </tbody> and need to do some calculations on it, and present it in this...

I am looking for something if I have formula 7cells from A1 to G1 pulling info over. If one of the cell do not pull info over an it delete the row or line. like if info does not show up in cells D1,E1 and F1 Help please

I have a process where it loops and opens thousands of excel files and then copies each tab to a blank spreadsheet. At some point when it opens the file, it prompts for a sharepoint login. How can i disable it so that it does not prompt me for that info?

I have a formula that currently works correctly that is located in cell L2: =IFERROR(VLOOKUP(B2,'Site Assignments'!$A$1:$D$131,4,FALSE),"ASK JON FOR INFO") Now I want to add logic that says if cells F2 and I2 are blank, then leave L2 blank I think what I need to add to the formula above is the...

I have a cell that needs to lookup two tables to find the price. It needs to lookup the time of week (such as mon-fri, weekend or public holiday), type of service and type of location (metro, regional or remote). I have two tables to show this info but is there a formula that allows you to...

Hi, Please see below code. When I run macro, info copying to sheet1. But I need at the same time to copy same information to sheet2. Please help. Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("Sheet1") ws.Cells(iRow, 2).Value = Me.combobox_name.Value

In the "stats" tabs, I am trying to add info to each row for each employee. In the "Document" Tab I want the info from "Stats" Tab to populate but when I copy the formula down I will skip about 33 lines in the actual sheet. For Example: "Stats" A2= "document" C2 "Stats" A3= "document" C15...

Hi all, First of all many thanks for all the good stuff on this forum! I'm using this forum for a while but can't find the answer to my problem this time, thanks for your help! In my macro to protect I use: ThisWorkbook.Protect Password:="BlaBla!", structure:=True, Windows:=True To unprotect...

I am some what new to sheets but know it is a very powerful tool. I am trying to total from one sheet to another. I also am trying to separate the total by phase and month. I also need to be able to add info to other cells based on the info in one cell from data validation. I have attached a...

Hello I have a problem with the Vlookup feature, Kinda...I figured it out how to get the information in there but it is grabbing the wrong Info. I will start off by explaining the kind of information I have going on here. I work for a school bus company and we do alot of trips. I want to be...

Hi there I am looking to create a formula to pull the total amount of people in a certain department and their salaries. All this info is in my data tab but I do need it summarized on a different tab

hi everyone, trying to get this formula to work properly at the moment i have this formula - that pretty much hyperlinks a cell to open up outlook to email to cell A2 and cc cell a3 =HYPERLINK("mailto:"&A2&"?cc="&A3, "NAME" ) Issue I am having is that I'd like to be able to display "NAME" as...

I have a spreadsheet that lists all of the items I need to order. They are in numerical order but some items are not needed so they are not in the range for the vlookup (picture 1). #1051 is missing. Since #1051 is missing, it duplicates the amount in #1050 (picture 2). I get that it has...

Hello, I am trying to make this problem as easy as possible. I am trying to get the values for MCA(Maximum Circuit Ampacity) and MCOP(Maximum over current protection), this values depend on the info ask for; fan HP, electric heat(7.5kW or 15 kW) , voltage and phase. I set up a data validation...

hello, I have a a file which has info such as qty and description of items in the same column. I need to separate the info into two different columns or at minimum copy just the starting numbers to a separate column. The info is usually in this format with the info needing to be extracted or...