hope

Hello all, hope you're doing fine.. So I made this dashboard with some data I insert every once and a while, and in the table that contains all that data I have two columns stating the some locations. It's a simple table where I insert the pickup location in one column and the delivery location...

Hi guys, I am looking for a way to match the closest value in a column without any duplicates. I used the following method : https://www.extendoffice.com/documents/excel/4279-excel-find-closest-nearest-value-greater-than-less-than.html This method worked fine : however I am looking for one...

Hi! I've been searching but had no luck to find if there is any possible way to make a chart like this automatic in Excel, do you think it is possible? If yes... how so? Hope you can help, thanks in advance!

Hi all, I have tried many ways to do this and have given up. I have a few customers and I have the spend for each month and I was trying to get the text to highlight if the spend is less than the previous month (if that makes sense). I have typed how it should look (I have manually changed the...

Hi, I'm looking for a code where i can search for a word in SAP. I can't use setfocus because the word could be in another line for another itemnnumber in the loop. Does this ring a bell with anyone? Hope to hear from you soon and thank you in advance! Kind regards, Myrna

Hello, My name is Byron and I have been given a task and I am having some trouble. I have just joined up today to ask for some help. I have had a go at searching for different posts but cant seem to find what I am looking for, so I hope what I want to achieve is even possible. I have a...

Hello, I'm using Excel now for a long time for the company I work for and of recently i started to experiment with macro's to do the tedious work of copying and pasting the first 10 rows of my sheet whenever I run out of space on my first printable area I would really like to have an automated...

Looking for help on a formula. I'm working in B2 if A2 value = Sheet name value return the most recent date (max) in that Sheet Name range A:A I hope this makes sense. You gurus are awesome by the way!

Im posting this video to better explain what Im looking for, for a CF formula, I hope someone can help me with it ? Thank you. Serge. https://youtu.be/joJU_nQyNNI

For a number 42117, it can be displayed as 42117, or 23-Apr-15, or 42,117.00 etc. I want to reference these displayed text appearance in another cell through VBA. How can I get it? I have below customized function and it uses the Text property. It still not work properly and hope someone can...

Hi I would like a formula which will return a value based on the value in another cell so if the value in a cell is gt or lt and value then multiply tha value by x so if a1 gt 0 and lt 100 then a1*5 or if a1 gt 100 or lt 200 then a1*10 or if a1 gt 200 or lt 300 then a1 *15 Hope that makes...

Hello Everyone, Happy New Year ! Hope you all had a nice time with your Family, Friends, Relatives.. Starting a New Year with a new challenges on Excel ! :) Basically I'm trying to build a 'Goods In' spreadsheet. Made the macro which gives unique ID for each delivery we are getting in...

hello, i have a serious problem, that by excel i can count how many the students -at this simple example - are duplicate as shown in result column by row , it helped me out in another tasks, is there a way to achieve same result in Access ?! i hope some one help me out <tbody> <tbody>...

Hi there, Is there a way to restrict cell input to 8,12,13,14 digits only, please? No text, only numbers. Hope to get some helpful suggestions. Thanks, Ashima

Hi good morning, hope you can help. I have the code below where if OOH is in a cell I want the whole row to change colour, but the code below is not working, hope you can help? Private Sub Highlight() Dim col As Range Dim value(0) As Integer Worksheets("Sheet1").Activate Set col =...

Hey guys, I have a row with three dates. I can use min and max to find the oldest and newest but I need to find the date that sits between them (as it is written in the cell not as an exact date between the oldest and newest). Hope that makes sense

I hope you can help me yet again. I have a code that works, however when I attach it to a button it doesn't run. I hope you can help me fix it. Sub CopyFormatting() Dim lRow As Long lRow = ActiveSheet.Cells.Find("*", LookIn:=xlValues, Searchorder:=xlByRows...

Hello all, and thank you for everyone's time in providing this valuable resource. I spend a lot of time manually sorting data that is pulled from a database and hope to be able to streamline the process, but so far I have struck out in using different combinations of VLOOKUP AND Match/Index. I'm...

Hi all, Looking to rename multiple sheets based on a list located in worksheet 'codes' from the range B3:B35... I hope someone can help! Many thanks in advance

Hi please hope you can help, I have the code below where I have a command button which I have renamed to FilterData, then I have created a macro and assigned it to the FilterData button, but it doesn't work, the 2 lines below gets highlighted in yellow, I have also attached the whole code at...