help !

hey guys i would like to create a summary of the table into the table below in which when data is entered in the general table the summary table will only show the which have defects such as the poles that are rotten will show up in the table below , also the the pole number from the above...

Hi, Please help! I have a file with multiple sheets. The same products, but from different countries so they have 70% the same names. They all have different prices but in the same currency. I need to be able to have the first row with my name of the product (the one that I set), my price in...

Hey everyone, I have struggling with this for days now...and my team is depending on me to figure this out soon. I need help with doing some sort of lookup on data that is in different columns below a merged header cell. I need a specific cell to be chosen based on the name that I input. For...

Hello All, I am trying to get a Index Match formula to work on my sheet Currently I am trying to use the following but its not working. =INDEX(NewDemand!$A$1:$CA$55,MATCH($C$1,NewDemand!$A$1:$A$55,0),MATCH($E18,NewDemand!$A$1:$CA$1,0),MATCH($O$1,NewDemand!$Q$1:$Q$55,0)) First Sheet...

Hello mates, I have a question for my code, due to the next pop up appears when I tried to send an email, I saw in a thread in this blog with the same issue but, unfortunately in my company exist a lot of boundaries for Cibber security and I cant to press the send bottom in my macro without pop...

Hey Everyone! So I am getting a bit stuck here - I have a timer that works (for the most part) the issue is when the userform is hidden and re-opened the "Continue" feature doesn't work anymore. Meaning the timer doesn't continue counting. Hope I can get some help please see my code below and a...

Hello mates, hope youre fine! When I try to run my macro in VBA, appers a pop up that says "Runtime error 440 : The object not support this method" , due to Im a newbie in this area I have not idea how to fix it, here it is the code and an screenshot of the VBA error Sub combinacioncodigo() '...

Hi all, I hope someone may be able to point me in the right direction. I have plotted data points from a pdf and created a spreadsheet, from this spreadsheet i have created an scatter graph of the pdf. The torque values are determined by the speed of an electric brake and the current output...

Hi. Can I get all the specific information I need in one master file? Here's a vague explanation of what I want to do. File 1 Name Fruit Country Phone Color James Rick Apple Korea 555 555 5555 Red Terry Williams Grapes Malaysia 444 444 4444 Blue Steph Curry Melon Philippines 333 333...

Hi everyone, I am new here. I have a table which looks like this. Team Person Period Cost Revenue A Tom 1 100 200 A Tom 2 150 100 A Jack 1 50 90 A Jack 2 75 80 B Sarah 1 300 400 B Sarah 2 150 500 Can you please help me with the achieving the following results on Power BI...

Is there a way to show skins for each hole? I have provided what I have done so far, but the final step to this sheet and will save me a whole lot of time is if it could calculate the skins for me. There are two options I wouldn't mind using that I have shown as a little bit of an example...

Hi I'm hoping someone can help me or tell me it's just not possible! I'm trying to create an automatic stock checker by entering a list from our system versus external location reports, once I've entered the data I can only seem to show if there is a match but not which item, status or where...

Hi, I want to web scrape information to an excel worksheet for multiple pages. example from page 1 to 3. I tried a code found online from googling but it sends out an error. Any help is much appreciated. Thanks in advance. :) I would like to sort the information like the example shown below...

Hello Gurus I have an excel file as an input with project data. The data shows how many departments have worked on the project. The raw data looks like this: Project name Project description Division Department Start date End date Cash accounting Companies that are not obliged to deliver...

Hello, I am seeking some help with a formula based on the inputs in the sample below. The "SHOPIFY IMAGE DATA" sheet data remains in sequential order when imported... S4,S5,S6,S7 etc. However the reference for sheet "SHOPIFY PRODUCT TITLE" only changes reference every 12 rows... S4,S16,S28...

Hello, If someone could help me, it can be vba or just formula in excel. My dilema is to make a scheduling calendar that tracks the frequency of lab test. For example, normally test should be done every three days, which will be recorded in the calendar. However, if for 20 days, the tests seems...

Hi Would like to calculate past 90days past. Employees hourly bonus start after 90days worked. Thanks. I did post this question to ExcelGURU forum as well. Currently I am working in May month So I have to go back Feb month data to verify hrs.

Hi! Do you happen to know how to take all data points from every single row and column and copy and paste it into a single line (one long column) so I can export all the emails? I have two images I upload (I did it manually but have 6,000 cells with email addresses and I need them in a straight...

Hi, I am looking for some help. At work i have a report containing product, quantity and dates. I would like to set up a formula to combine all qty's by weekly in a report listing all products. (See example of delivery report "attachment capture 1") I usually use Vlookup to extract total...

So I'm trying to do a pivot table that changes the color of the data based on wether the value reaches a certain target, green if above, red if below. I the procceed to use a method similar to the one present in the following link: Create Dynamic Target Line in Excel Bar Chart But instead I make...