live

I'm working on a quarterly Board report which i'm trying to set up so that you don't have to amend any of the data when you open it. Currently there is a month-by-month break down of all the figures in one worksheet, then the report itself is on a different worksheet. Is there a formula that...

I'm working on a quarterly Board report which i'm trying to set up so that you don't have to amend any of the data when you open it. Currently there is a month-by-month break down of all the figures in one worksheet, then the report itself is on a different worksheet. Is there a formula that...

Hey All I've built a Query that pulls in details about certain products in our range. The problem I've got is that the details for each product live in a text file, it contains details for every product we've ever stocked including some obsolete ones. Because of this my Query is returning...

Is it possible to link data from a Excel spreadsheet into a LIVE PowerPoint slide? So if I have PowerPoint running in Slide Show mode, is it possible (without any macros or VBA) to have another person updating a shared excel spreadsheet and have that data update instantly within my live...

I have a large sheet that relies on a lot of live ranking. Is there a speed / efficiency difference between the two formulas below? (Obviously trivial for the tiny data set I used to create the image, but my sheet pulls in live stock data and is live-sorting 1,000+ cells that update nearly every...

I have a surgery opening times spreadsheet that currently displays waiting times in the "LIVE" worksheet based on the current time, pulling details from the DEFAULT worksheet. I have two additions I would like to make but am struggling with: 1) I want to add in weekends and have the LIVE tab...

I want to know 1) if it is possible, 2) how to create a spreadsheet that is always "live". I want to create a job priority list that i can update and then other employees on the network can have it open and see what was added, if they add notes or sign off completed i want to be able to see it...

Hello, Is the below example possible? I've been able to determine how many people live within a certain distance (in miles), thanks to this board (thank you!), but now I'm looking to determine how many people live "within a 30 minute drive", using lat. long. coordinates as the reference points...

I have this Public colnum As Long Sub Callcolnum() colnum = Round((Date - DateValue("12/20/2017")) / 7, 0) MsgBox colnum End Sub in a modole renamed to COLNUMDECLARATIONCODE and this Private Sub Workbook_Open() Callcolnum at the beginning of ThisWorkbook code. Everything works fine - until...

Hi All, Currently in our department with run all our live and completed works off an excel spreadsheet. The sheet holds alot of different information, which currently I have to manually look up to produce a daily, then weekly report. I'm wondering what formaula's I need to have this...

I have two worksheets - Live Projects and Dead Projects - each of which has six columns. In the sixth column (G) I have a check box. When this is checked (ticked) it denotes that the project in this row is now dead and should move to the Dead Projects sheet and move any remaining Live Projects...

Hi everyone, I don't work with Excel much so I have a beginner question here. I have a sheet that constantly pulls in live data every hour or so. There are four columns and column A contains the company name. The sheet has around 200 companies in total with many rows of timestamped data each...

Hi, My head has been pickled trying to figure this out, here's the problem (it's also on google sheets): I am trying to show a live production rate which is based on time and units completed. Start time in the morning is 8am I have a cell which shows the live time beside it Below this I need...

Hi there. I have a "live" online spreadsheet on our company intranet (shared with clients) I have a parent workbook (with dashboards) that needs a second workbook (with calculations) to open in order to update all graphs. My code is: [VBA] Private Sub Workbook_Open() MsgBox ("For up to date...

Hi Folks, Looking for some help and advice, please. Difficult one to explain, Essentially I have 2 worksheets. For simplistic sense, let's call one Raw Data that gets updated daily and the other live reporting. Raw data contains lots of information and is updated with new people every day...

I was thinking those who are skilled in excel often have a mind for math logic as well. Perhaps you can help me finish this equation? I am trying to calculate the live percentage difference between two targets in the cryptocurrency market in relation to realtime price changes. Entry: .02...

Not sure how best to word this, but I have a financial dashboard with columns that are formatted width wise for other items on my dashboard, along with graphs, but I also want to include a snap shot of a PnL. The problem is my PnL column width are formatted much different than the columns of my...

I have a set of numbers against dates. That sequence goes 0,0,0,0,0,.....,0,1,2,3,4,5,5,5,5,5..... And so on. I first wanted to extract the date at 1 and 4 only then at the next occurrence of 6 to whatever the number before repetition. But I was unsuccessful. If I could get help on this, I'd be...

Good morning everybody, After years of going to this forum as a shadow, I have decided to create an account. I am struggling to come up with a formula, which some of you are probably going to find quite simple! But for me, the struggle is real! I have tried to look around Google, but either I...

Hi, Is there a way to hide the rows with anything other than "live" in column L Many thanks