live

  1. H

    YTD Data from Monthly Input

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

    TYD Data from Monthly Data Input

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

    Dont' display rows based on certain columns being empty?

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

    Latest version of Excel/PowerPoint

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

    For dynamic sorting / ranking, is there a speed difference b/t the RANK and COUNTIFS methods? (And are there other faster methods?)

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

    Calculate current day and time, insert data according to a variable

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

    live spreadsheet that is visible and changeable on a net work

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

    Count function help - determining "drive time" distance

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

    Keeping a Public variable always available

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

    Formula's for Reports

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

    Transfering data from one worksheet to another base on a check box

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

    Separating records from a live feed of data

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

    Formula for reducing time if a certain time has passed

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

    VBA code to open excel file from company intranet

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

    copy data from worksheet to another worksheet without overwriting

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

    Math Logic Question (Finding the right equation for live data percentages)

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

    Create a live picture of linked cells?

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

    Get number in sequence using vlookup or match in a live table

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

    Sumproducts only taking into account certain rows identified in another column

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

    Hide rows based on Column L

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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top