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!

Register Log in
  • Congratulations Mike Lewis 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: *

  1. squirtguns

    How do I "break" apart a pivot table into its original data list?

    How do I "break" apart a pivot table into its original data list? I was sent a pivot table. I would like to get rid of the pivot table and just have the raw data that the pivot table is presenting on a regular excel worksheet. Can I do this? Thanks!
  2. squirtguns

    Excel Can I shade a range based on the value of a cell outside range?

    Here is what I would like to do in excel...<br><br>Cell A1 contains a drop down box that can either be set to YES or NO<br><br>If Cell A1 equals the word NO<br>Then cells A2:A15 are shaded in grey<br><br>If Cell A1 equals the word YES<br>Then cells A2:A15 are not shaded<br><br>Any...
  3. squirtguns

    Is there a formula that will return the filename to a cell in EXCEL

    I would like to have cell A1 return the name of the current excel workbook (file).<br> <br> example= Filename is Monthlysales.xls<br> <br> I would like cell A1 = monthlysales.xls<br> <br> Thanks!
  4. squirtguns

    Concatenating date field does not work for me

    Example<br> <br> Cell A1 =2/16/2000<br> Cell A2 =John<br> Cell A3 contains the following formula=A2&&quot; &quot;&A1<br> <br> The result is displayed as john 36572<br> <br> How could I get this to display as John 2/16/2000?<br> <br> thanks<br>

Part and Inventory Search

Back
Top