live

I hope that someone has an elegant solution to solve my "situation", as follows: Via keywords, I make a pre-qualification of ledger entries. This works very well via the following statement in a ledger table...

Before I go bananas trying to figure out how to do this, can this be done? I have to maintain a live link to a file that my co-worker names with a version number frequently. Is there anyway to link for a look up to this file with maybe a wild card to account for the versioning? or to...

Hi all, I'm not much of an Excel guru but I'm trying to build a replica of Google Finance Portfolios now that the Portfolios portion is being axed. I've managed to replicate everything into a live spreadsheet but the line graph. I would like to build a line graph that plots the value of my...

Hi, I feel like this should be really easy with an if statement and a concatenate but the max on the date is throwing me off. I'm looking to add a formula to column F that determines the line is "LIVE" or "INACTIVE" So If "Customer & Code & Product & Status" appear in the list of data...

Hello, Sorry if the title doesn't make make sense. I'm pricing a project which split into blocks, with many of the same specifications repeated by block. I have used V-lookup (on a different sheet) to generate the same rates for materials and labour, but is there any way to total up the...

The title is perhaps not very clear and not sure if this can be done - BUT any idea how I allocate something a reference number but meeting certain criteria. What i'm trying to do is to say if the product (col B) is live (status col A) and has a certain code (col C) allocate the first...

How do I have a live date in a cell in excel that whenever I open up the workbook the date updates itself automatically to the current date? Thanks:confused:

I have been working on a search form that is starting to take shape, the goal will be to allow people in production to quickly search inventory from partial matches to identification tags. I would like them to be able to search a live connection but I dont want them to be able to make any...

I'm new to VBA and am trying to figure out a way to do the following. I have 3 spreadsheets (Live, Control, Compare). Live & Control have a list of names in D8:D99 and Compare has a list in A7:A98 with a number field in B7:B98. I want to create a toggle button that will hide rows based on the...

Hi All, By default, the camera tool takes a 'live' picture that changes whenever the original linked cells change. I'd like to save this live image as a static image, i.e. when the original cells change, the image does not. I've tried to copy and paste the image, but with each option...

I wish to transfer live data from charts to Excel They are bar charts & if I click on any bar in the chart it displays open-high-low-close values Is it possible to place these values into an excel page & if so how do I achieve that? The values are. of course, updated frequently & I wish the...

I am curious to know if one could create a "management overview" workbook containing live links to various other workbooks. As such, the values on the single management workbook would change immediately after values were changed in any linked supporting workbooks. The tricky part would be that...

Hi, Just wondering what the easiest way to import a live, self refreshing stock quote would be. I want it to be just the quote ie 62.10 so that it can tidily fit into one little cell. Thanks

I wanted to know how to download live data (stock data from a a website) through VBA. Can anyone help? Thanks.

Hello I have a spreadsheet with a long list of prices in GBP that need to be converted to USD, HKD and RMB, they need to be marked up for retail pricing, pull live currency exchange rates and then rounded. I have done this manually but need an embedded solution pulling live exchange rates that...

Hello, so kind of two questions: I have a 'data' sheet (table) hidden, and to optimise speed at run-time I load the thing in an array... Global RecDict As Object, Database() As Variant, Sub Startup() Dim RecStore As Range Database() = Sheets("Data").Range("A2:Z" &...