help !

Hello Everyone! I am looking to create a formula to do the following.. If C14="THIS" then look in table on page 2 (columns B-F) for data in Cell E23(from page 1) and return pricing listed in column 3, but if Cell C14="THAT" then look in table on page 2 (columns B-F) for data in Cell E23 and...

Hello! I am quite new to VBA, but I am trying to create a program that allows me to push a button that asks for a file name, and after entering the file name, it opens up the file I requested. I have attempted this here, ______________________________________ Sub Start() Filename =...

Hi All, this is a most excellent forum with a wealth of information and a wonderful user base! I have learned a lot from this forum, and see many thoughtful answers. I have a macro which I need help with, I'm attempting to display a list of RGB codes to the recent colors section within excel...

Hello, I'm having some difficulty with the SUBTOTAL function. I'm looking to find the sum of a range within a filtered spreadsheet. I entered =SUBTOTAL(9,[RANGE]) and it returned an answer of 7.10543E-14 (which doesn't make sense since my values on have two decimals). I calculated it manually...

I receive a large file each month which tracks staff who badge through a particular badge reader. I am trying to write a formula to tell me if each row was captured during regular business hours or not. below you see a paste of my excerpt (I cannot attach a sample excel file to this for some...

Hello, I have a data set of ~2500 rows, the data im concerned with is the description. The description has large variations within the data set, i am looking to consolidate the descriptions to a common description. For example ...

Hi, I'm currently working on a project where I have a number of statements which are rated between 1(Strongly Disagree) and 4 (Strongly Agree). For each organisation I am presenting their mean average on this statement against the combined mean average for all other organisations, and I would...

Hi all, So i have a long column of date data (01/10/2018 etc) in Column A:A and what I'm trying to do is have Column B:B return back the following criteria: Last Week (Which is the date in A:A is in the last 7 days) Last Week -1 (Date in A:A is from the week prior to last) Last Week -2 etc...

Hi all, I often have an issue where I will save and exit a workbook and then when I come back to it, all cells have been formatted to Accounting, despite being saved as General, Percentage, Date, etc. It's odd because it's different workbooks, not just the same one over and over again...

Greetings all... I'm in a pickle jar... Let's say I am looking at 4 different store locations. In those locations I have several lines of products that we sell. I have 5 pivot charts setup all associated to the same data sheet. I am using a slicer to auto filter all the pivots depending on...

Hello All, I have been searching for threads and while I can find some code for situations similar to mine, I can't seem to re-work the code to fit my specific situation. I just don't have a deep enough understanding of VB to understand how to modify the code. I have fleshed out what I am trying...

Hello All- I have searched the WWW and I can't seem to find exactly what I am looking for, so I am hoping someone here can help. I know enough about Excel to be dangerous so if you know how to help me please give me step by step details. So here is my problem: On my first sheet I have a lot of...

I have a range of dates in column A and I only need to identify the dates within the last 2 years. Is there a way to use conditional formatting to only highlight the dates that are within the last 2 years? Thanks in advance!

Hi All, I have a workbook which contains 100s of worksheets. In column A of each worksheet contains unique product ids. Then to the right of those product ids are numbers (column b). Sometimes we need to change what numbers are to the right of each product id. A2 = BLX6497 B2 = 20 At the...

9X60X11 I have variations of dimensions such as the string above in my cells. Their position is not consistent. The only consistent rule is that the word I want to be rid off in all my cells contains the letter x, but how?

Hi there! I am in need of some VBA macro magic here. I have a stream of data that represents energy usage on an hourly basis. It is in one column currently that goes Day 1 HE 1, Day 1 HE 2, etc. I would like to have a macro that takes the 24 hours and transposes it into a table that has the...

Hi All, I've built a workbook that calculates OTIF for our orders for work. The issue I have is the workbook now contains so much data, excel hangs when refreshing and unless I leave it for 30mins, it crashes. I want to know if it's possible to have a VBA that runs, so it refreshes the data...

Hi I want to make a point-based level system I'll have the data in a table displayed like this: 10 points 30 points 60 points and so on... but in the scoreboard will be displayed like this: level 1: 10/10 points level 2: 20/20 points (10 points from level 1 + 20 points of level 2) level 3...

Hello, I need help with a formula. Below is a very small sample size of data I have. Typically, I have thousands of Incident numbers (column A) with hundreds to each Shift-Station(column D). I need to get the median time (column E) for each Shift-Station. Is there an easy formula to type...

This was raised to me in IT because one user is getting rather annoyed at it. So I have an issue with excel in our company, where when you open any excel document, doesn't matter if its created by you or someone else, or even if its new or old. Each time you click on a row (Row No. 60) then...