air

Hi, need help with the following. Have a workbook with 1200 lines and 4 columns. Its a list of building material for a office block split by size. For each size there are a number of different products listed. These are then replicated over the 49 floors of the building. Sample below ...

Hey everyone! Hope everybody is doing well. I've bee searching around and I've found some threads that are similar to what I'm trying to do but small differences completely change the results. I have a spreadsheet that is e-mailed to me daily. It has hundreds of lines that need to be...

Hello all... Is there a way to do this please... I need to extract the topics from my data... So in cell B7 after the word "Agenda"... I'd want the text after "1." but before "2." in C7. Then agenda 2. in D7 etc across the row... I'm assuming numbers in Agenda 1 would mess everything up but I...

Hi there, Greeting! I have keywords list. I like that keywords match with our table make and model. And show "Match" word beside of match keywords. Like column A values check in table J & K and show match word in column B <tbody> A B C D E F G H I J K Keywords Result Type Year Make...

Hi everyone, I'm trying to create a list of specific aircraft from Air Canada that have NOT been in accidents. The aircraft organization name is in my worksheet titled "RawData" (Row K), the aircraft registration #s are in my worksheet titled "RawData" (Row C), the Air Canada registration #s...

Hello, Is there any Excel tool or VBA code to the following efficiently, thank you in advance: I have a data sheet including a column of color names and a few columns of color codes in front of that. some colors have only 1 code, some 2, and some 3 codes. I need an efficient way that creates...

No of units. Price/unit. Method. R/ unit 1. 70. Ship 1 10. 60. Truck. 1.5 100. 50. Road. 2 200. 40. Rail...

Hi, I download from Microsoft a Excel Spreadsheet that would download portfolio data after editing the query. It work very well. I am now using Microsoft Excel on a Apple MacBook Air using Excel Version 16.11.1 (180319). This query doesn't work now. The query had a connection string of...

Hello, I am trying to create a spreadsheet for people who are not that familiar with excel, if at all. I am trying to create a macro that would give them a list of available selections in the filter to choose from and then action their selection. Anyone have any suggestions? THANKS in...

Hello guys, I wonder if you can help me. I have a spreadsheet that has three toggle buttons. One is called "Tool," one is called "Fluid" and one is called "Air." The idea is, if I hit "Tool" it hides fluid & air rows for each account. If I hit "Fluid" it hides tool and air, and if I hit "Air" it...

How in VBA can i fill in the blank rows and fill them...it needs to find the name after the blank and copy both fields to the above cells. Appreciate any help :) So from this..... <tbody> V00006 Action Office Machines P/L V03393 Active Sound Services V03271 Adaptalift Group Pty Ltd...

Hi everyone, it's been many years since I've posted anything to Mr. Excel and I was glad to see that the community is alive and well after all these year. I've searched through the forum and didn't find an thread that already answered this questions so I thought I would post it and see if there...