help !

Not sure if this is possible - but wanted to ask. Need to calculate a "Year-to-date" balance of a savings account while using the TODAY() function as the start date (so it dynamically changes). Ex: Total Goal Amt: 5000 End Date: Dec 2026 Total # of Months till completion: 24 (*calculated...

Hi, I'll try to explain this as best I can... I can't share the sheet as it contains sensitive information. I have a table with over a thousand rows full of text, and I am interested in analyzing it based on the final 3 columns. All cells in those columns contain one word. There are only 4...

I am new to pivot tables. I am working on a general ledger summary on a worksheet. I want to edit the values in a column but when I click on a cell, it opens up on a new sheet. Is this the only way of editing information in a pivot table? I have lots of values to edit. thanks

I have a large dataset (c.75,000 rows) and I'm interested in the data from three columns. 1. Reference Number 2. Person 3. Value I want a formula to show to me who spent what on each job and return information the below Ref Reference Number Person Value 1234 Joe Bloggs 10 1234 Blog...

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...