Search results for query: *

How do I create a menu option or commandbar option triggered VBA script to automatically close and re-open a spreadsheet in order to pick up changes made on this spreadsheet by a second user.

I have a spreadsheet which holds roster information that is regularly updated by an administrator. This same spreadsheet sits on a central PC (on the same network) with read only priviledges, and I would like this to automatically update to pick up any changes made by the administrator say every...

Hi, basically I have a a table of date representing durations and I can't figure out how to convert this into a decimal number. For example 260:30 would output 260.5? Any ideas? Thanks Justin

Hi a couple of problems I have with text boxes. Firstly I have a blank text box which requests a user to input a value in order that a calculation can be carried out. However once a value (say 20) is manually entered how the hell can I link this value into my formula? Also is it possible to use...

Hi, Not sure if this is simple or requires complicated VB code, but what I am wanting to do is display an up pointing arrow image if a number value is above a certain level and a down pointing arrow image if a number is below a certain level? Thanks, Justin

Sure there is a simple answer to this...... Basically I have a chart whereby a count for each month is represented by indivdual bars to represent the 12 month's Jan - Dec. However I would like to superimpose a line graph on top of this. Is it possible to represent two lots of data on the same...

Hi, I have a single spreadsheet made up of a number of sheets where each sheets contains information specific to an individual customer. Is it possible to restrict read access to certain sheets of the spreadsheets through passwords? For instance anyone can see the "header" sheet. But...

If cell A1 = "Answer_A" or "Answer_B" how do I get cell B1 to return "Answer A" or "Answer B", with the underscores removed. I guess I need to use some form of IF statement, but I'm not sure how to implement this. Can anyone help? Justin

Hi, For example I have three sheets labelled Sheet 1, sheet 2 and sheet 3. I then have a list box set up on a seperate sheet which pulls in information from the relevant sheet, depending on which sheet is picked from the list box, all well and good. However this only seems to work if the...

Hi, I am trying to concatenate two rows of data. The first contains dates in the formay dd/mm/yy the second contains times in the format hh:mm. The trouble is that when concatenated I am unable to present the result in a dd/mm/yy hh:mm format and I guess this is because concatenate only works...

Is it possible to trigger hyperlink to other pages within the same workbook by picking values from within a list box. For example clicking on Page 1 from within the List Box will jump to Page 1, clicking on Page 2 will jump to Page 2, etc. Thanks, Justin

Simple one I hope which follows on from my previous post.... I want to return a value in cell A1 based on the value in various rows in column D as follows:- A1 = D(((n-1)*18)+2) where n is the value returned from a list box, such that if the list box returns 1, using the above formula I want...

Using a List Box, dependant upon my selection of several variants I want to be able to enter values in a table from a larger table of raw data. Using the Cell link 1, 2, 3, 4 etc, I am able to populate the table values for a single returned value using a formula such as :- IF('Source Data...

Anyone know how I can easily convert a listing of time durations in the format hh:mm into integer hours (i.e. 3:15 = 3.25)? Thanks, Justin

Obviously I can represent data in a chart in a bar format or line format very easily. But how do I combine the two so that some data series are represented in a bar format but other series are represented in a line format on the SAME chart?

I am probably being very silly and there is a simple solution, but I have a graph which depicts three data columns for each month. Howe do I represent the trend from month to month for each of the data colums as a line on the same graph and moreover can I add a line which depicts the overall...

I'm sure there's a simple answer but does anyone the formula that should be used for counting differing rows. As an example if Row 1 = Blue, Row 2 = Yellow, Row 3 = Blue, Row 4 = Red and Row 5 = Blue. I would like a count value of 3 to be returned which represents the number of different values...

May be a stupid question, but is it at all possible to attach and run animated GIF's from within an Excel spreadsheet? If so how?

I'm wanting to apply a border to only to polulated rows of data. I know that if I highlight the appropriate rows and apply a border, upon printing the report the border will only be depicted around the rows with text in, but on screen I get row upon row of blank lines with borders applied at the...

I can very easily apply conditional formating to create up to three conditions, but how can I create in excess of three seperate conditions?