Search results for query: *

Hi I would like to create a toggle button which places or deletes an “X” in cell C5, but I am struggling with the syntax. Could anyone point me in the right direction please? Many Thanks

Hi I’m wanting to create a button that will hide any col which has an ‘X’ placed in it in row 1. This will be in consecutive cols, there will be no gaps in the row of ‘X’s. and will be in operation from D1 to GR1. I’m thinking the code will be along the lines of ‘Hide col if D1:GR1=’x’ but as...

From Windows File Explorer, is it possible to transfer file names held within a given Folder into a spreadsheet? Many Thanks

Hi I have a list of 5 players whos scores are constantly changing. The data in col B comes from another part of the sheet, so what Im wanting to do is have the list to be re ranked (high to low) after new data is added. Presumably by running a macro? The update can be displayed anywhere, it...

Hi I have 2 INDEX statements which extract a maximum of 2 data items from an array of 12 items. I now need to be able to extend this extraction to upto12 items from an array of 18. The current two statements are: =INDEX($CR$8:$DC$8,1,MATCH("M",$CR$9:$DC$9,0))...

Hi Is it possible to apply Conditional Formatting to a cell whose formula has returned 'Number Not Available' – ie '#N/A' It is possible for some cells on my spreadsheet to display this and I would like to blank it out visually by changing the text colour to match the background but only...

Hi Could any one show me if its possible to extract 2 cells of data from a row of 12 cells. In the example below, fisrt line is Col Number, next is staff initials, and next two are examples of the combinations of data (there are 365 rows in all). In these two examples, I am only interested in...

Hi Im using Excel 2003 whos conditional formatting only allows 3 conditions to be set. Can anyone please tell me if 2007 is any better (certianly in the number of conditions per cell)? Many Thanks

Sorry if Im being intentionally thick here, but I have a VBA problem which is proving to be a nightmare to succinctly put into words so I was hoping to attach the spreadsheet to help with the explanation. I have seen the attachments field below this panel in Step 4, but the note below says to...

Hi All Skipvought penned me a great 5 line macro a year or so ago which has worked perfectly since but now I need to adapt it to a revamped spreadsheet. (thanks again Skip) The spreadsheet has the top 23 rows frozen for a title section and below is the scrollable area of a further 365 rows...

Hi All Skipvought penned me a great 5 line macro a year or so ago which has worked perfectly since but now I need to adapt it to a revamped spreadsheet. (thanks again Skip) The spreadsheet has the top 23 rows frozen for a title section and below is the scrollable area of a further 365 rows...

Hi Could any one tell me why, when I type in a cell formula, eg something as simple as =A1+A2, that the cell calculates the correct mathematical answer but when I return the cursor to that cell, the formula bar does not show =A1+A2, just the numerals of the answer. Is there a cell format I've...

Hi Is it possible to have a nested ‘OR’ statement linked to a VLOOKUP statement? My worksheet has a row for entries between 1 Jan and 31 Dec. Each row has 18 cells of which 6 will contain an “A”,“M”, “N” or “O”. At the moment I have a nested “or” which works but only for one given date. I...

Hi Is there a way to make a positive number into a negative number ie if the value of A1 is 150, how can I make B1 = -150? Many Thanks

Hi All Is there an ‘if and’ / ‘if or’ combo that will let me do the following: In a worksheet of 365 entries, in col C, “m” ,“a” or blank can appear, and in Col D, “s” or blank can appear. If I get the combo of “m” and “s”, I’d like to use the value housed in A1. If the combo is “a” and “s”...

Hi If I have a summed value in cell A5 is there anyway to place that value into C5 but without having the formula '=A5' in C5. What Im wanting to do is to have a macro button which will make A5 and C5 be at the same value but only when the button has been pressed - otherwise with =A5, it...

HI All What Im trying to achieve is, If col C has the letters M, A, N or R, then Col E has the values 7,7,10 or 4 respectively UNLESS, col D has an ‘H’ in which case, the value in Col C jumps to Col F, and Col C becomes blank ie: Col C Col D Col E Col F M H...

Could anyone tell me if there is a setting somewhere that prevents you from either copying cell formulae or pasting them into a different workbook? I have a spreadsheet that I am rebuilding, and I'm able to cut and paste all the formatting and content but none of the formulae. All I get for a...

Hi On my spreadsheet, Cols DL to DW represent the months of this year – with a simple title of J, F, M A etc (ie there is no actual date involved but obviously can be if the solution requires it). The content of the cells is simply a red or green colour determined by Conditional formatting...

Hi Would anyone know if its possible when I move bewteen worksheets (via sheet tabs) that each time I go into a sheet, the cell pointer is in cell A1? Many Thanks