code & formula

Hi, we have the data in sheet1 and sheet2 and using index and match formula, its working fine but we don't want to drag and drop formula from C2:C4 and again we have used formula in D2:D4, there is any formula from which we can get desired result so that don't do drop down SHEET1 125024568765...

Hi i News help to creat a code in vba in order to copy a line and paste it as values all the times needed until a condition is met, in this case =0

Hi - I am new to VBA (I just started learning last week) and is hoping someone can provide some assistance. I need to do the following: 1. Take the percentage in each row: Multiply it by the Total number cell in the top left corner Round it to 0 decimal places Put the result in their...

I need help changing a piece of code that @JoeMo came up with on this forum. Private Sub Worksheet_Activate() Dim wSheet As Worksheet Dim n As Integer Dim calcState As Long, scrUpdateState As Long calcState = Application.Calculation Application.Calculation = xlCalculationManual scrUpdateState...

Hi all, I’m looking for a formula where in i could separate numbers from a cell containing text and numbers and also find the difference between those 2 numbers. For eg: Runs scored by Mike 560 vs Richard 345 This is the actual text which i have a in a single cell however only need the...

I am new to this and trying to get each row to automatically get copied to my second sheet "Completed", then deleted off my main sheet... So - when I select "completed" from the dropdown in Column "N", that entire corresponding row essentially moves over to the second sheet labeled "Completed"...

I created this formula to filter =CONCAT(IF($A:$A=$C2,$B:$B,"")) and if working perfectly. However i'm having issues with creating a VBA for it. Basically i want to combine the text in column D based on the reference code in Column C. Been working on this for hours! any help would be much...

Hi all! Maybe this has already been asked but anyway.... Im working on an Excel sheet with all the materials from a producer. The goal is that we can make stickers with an QR-code so we can scan this for our date base. On the main sheet is the next information. On the second sheet (image 2)...

Hi Everyone, I'm looking to to use a VBA Macro to extract data in a particular fashion. The data sheet looks like below: ABCDEFG1CodeDescriptionQTYPriceGSTTotal2*Section1316875Paper 3242341234416876Paper 3242341234516877Paper 3242341234616878Paper 3242341234716879Paper 3242341234816880Paper...

Good evening, Please see the attached image or youtube video link below. I would like to know how to create multiple functions if one of the switch images is selected. For examples, if Switch 1 is off + Switch 2 is on, certain outcome happens if switch 1 is on + Switch 2 is off, a different...

Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...

Hello everybody, I have the following list of information: Is there any way in which I can alphabetically order this list with respect to column B? Would greatly appreciate any assistance I can obtain! :) Thank you very much everybody. Best regards, David

ABCDEFG8NATURALGAS20JULFUT#DIV/0!#DIV/0!9NATURALGAS20AUGFUT#DIV/0!#DIV/0!10NATURALGAS20JULFUT0011NATURALGAS20AUGFUT#NAME?#NAME?12NATURALGAS20JULFUT0013NATURALGAS20AUGFUT#NAME?#NAME?14NATURALGAS20JULFUT0015NATURALGAS20AUGFUT#NAME?#NAME?F8F8=IF(ALGO!E24>1.8,"SE ",IF(ALGO!E24<-1.8,"LE","No...

Hello, I am contacting you because I am trying to create my first VBA macro. But when I am trying to build it, I receive the following error. I am sure I am totally wrong when it comes to the code as it is the first one I am building. If any excel expert could help me to understand what is wrong...

Hello, I am trying to figure out how I can have VBA insert today's current date into a specific cell. For example in cell A28 we have our start date as 3/9/2020, cell A29 is 3/10/2020, A30 is 3/11/2020 and so on. I only need Weekdays to be included and not Weekends. I know this can be done...

Good Morning All, As always, I must start out my posts with a big thank you to everyone who contributes to this forum. So I have a bunch of data in various columns with only one column I need to convert to categorical data. Column H is what I will need the script to focus on. I have a...

Hey guys, First post here so please forgive me if I miss anything.. I am new to VBA and attempting to find some coding that will allow me to allocate the below section units between months based on course start and end dates. I have entered a couple of lines below of what I'm working with. It...

Hi guys, I've been building some code for a spreadsheet which has a whole host of individual weighted words. When a user types in a particular sentence into the (Sheet: tester) "Search_box1" field, upon clicking a button I want each word in "search_box1" to be referenced in a separate sheet...

Hi All, I have a module written to pull data from one sheet (Raw Data) and into another (Opportunities). But I am having trouble with the last piece. I THINK I need to group by Column B in Raw Data - but I still want to sum by Column C in Raw Data. Not sure if that is correct, but I was able...

Hello How are you my friends! I hope you will help me to complete this table It is a Time sheet I want you to create numbers of work time according to the following condition: in (E8) set valuein [F8:AJ8] random numbers SUM random numbers in [F8:AJ8]= SET VALUE in (E8)I want to cancel...