Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: shytott
  • Content: Threads
  • Order by date
  1. shytott

    Excel - Toggle Button Code

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

    Hide if 'x'

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

    File Explorer into Excel

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

    Ranking Data

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

    Excel: Amending INDEX Statements

    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))...
  6. shytott

    Excel - Conditional Formatting and #N/A

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

    Excel - Extracting Data

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

    Excel 2007 Conditional Formatting

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

    Thread Attachments

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

    Excel - Selecting a row by Date

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

    Excel - Selecting a Row by Date

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

    Excel 2003 - Disappereaing Formulas

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

    VLOOKUP and Nested "OR" Statements

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

    Making a Positive Number into Negative

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

    If or, If And

    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”...
  16. shytott

    Excel - Plading a value in a cell

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

    Excel: Are Nested Statements the answer?

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

    Excel - Unable to copy cell formula to new workbook

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

    Hiding a Column Depending on Date

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

    Cell Addressing when selecting a Different Worksheet

    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

Part and Inventory Search

Back
Top