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 strongm 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. wec43wec

    Excel - how to insert multiple rows at one time!

    Skip, just for the record, I agree with everything you've said, in fact, you have mentioned this to me before. However, I was helping someone else and I was not going to change their data. Thanks again !
  2. wec43wec

    Excel - how to insert multiple rows at one time!

    Yuri - excellent !!!!!!! I got it - thanks !!!!
  3. wec43wec

    Excel - how to insert multiple rows at one time!

    Yuri - your solution seems like it may what, but I am not understanding your second sentence of how to apply the new column count to 500. Please advise - thanks
  4. wec43wec

    Excel - how to insert multiple rows at one time!

    I have a spreadsheet with data in each row (as an example) from row 1 through row 500 and I want to add a blank row between each of the 500 existing rows. Is there an easy way to complete this task without having to use VBA? Thanks
  5. wec43wec

    Excel 2010 - How to extract Specific Data from a String of Text

    Skip - your timely and accurate response to my issues allow me and others to have a peaceful day. I truly appreciate your help ! Multiple STARS are coming your way. Again, thanks WEC43WEC
  6. wec43wec

    Excel 2010 - How to extract Specific Data from a String of Text

    Andy the string of text is not aligned by column heading which is why I need to find a why to pull the text with the only common factors being the forward slash and the zip code. Please help ! Thanks
  7. wec43wec

    Excel 2010 - How to extract Specific Data from a String of Text

    Sample Data = Zip Code Address Directional Donation / Land Income 123456789 123 Main Street South 100 / Bus. 10,000 987654321 12345 Oak Bar Ave Northside 10000 / Resd. 100,000 I have a PDF file of over 10,000 rows with a string of data as listed in...
  8. wec43wec

    In Power Point, how to create links to other applications?

    In Power Point, how would you go about establishing an icon or link on a ppt slide where I can click an icon or link to go to an excel or MS Word file and then return back to the same ppt slide. I want to do a presentation where I want to reference data in other applications and be able to...
  9. wec43wec

    How to change the font size of half the text in a cell formatted for time and date?

    Skip - great suggestion which I will most likely use if I can not find another option. This would require more work on my part becuase I would need to change the column setting and cells within my spreadsheet, But this would only be a one time task becuase from that point forward the spreadsheet...
  10. wec43wec

    How to change the font size of half the text in a cell formatted for time and date?

    Thanks Macropod, but can you give me an example using the time and date indicated above. All of the text in my report (spreadsheet) is set at a 12 font. I want the Date "only" to be a 10 font and if possible i want the color of the DATE ONLY to be blue. Agian, thanks for the help and the...
  11. wec43wec

    How to change the font size of half the text in a cell formatted for time and date?

    i currently have a cell that is formatted as time and date as follows: [$-4409]h:mm AM/PM - mmm dd;@ example >>> 2:30 PM - Sept 08 What I would like to do is to only change the font size of the date "Sept 8" but NOT the time. Also, is it possible to change the color of the...
  12. wec43wec

    How to extract data from 2 different cells in a large Data base for 10 different group names?

    Skip – I truly apologize for the confusion on my part for not making my request clear. If I can, please let me clarify a few items as follows: Quote: Wec43 - The rows are all "grouped/sorted" by "STATE name Skip - "WHERE is the STATE name??? Correction - the first column of the database...
  13. wec43wec

    How to extract data from 2 different cells in a large Data base for 10 different group names?

    Below is a brief sasmple of a data base that has over 5,000 rows but the same 10 columns. I only show 20 rows of data but the data base goes to row 5,000. The rows are all "grouped/sorted" by "STATE name" but different data for each of the other 9 columns. The numbber of rows may vary. I want...
  14. wec43wec

    How to extract data from 2 different cells in a large Data base for 10 different group names?

    I have a data base that containes 10 columns with over 5,000 rows. The data base has aready been sorted (when I get it) by column # 1 which has the same 10 different names in column # 1. What I am trying to do is to test data in column # 8 (i am looking for the MAX number for each of the 10...
  15. wec43wec

    How to retrieve contents from a single cells within a range w/blanks

    Using Excel. In column a, I have a number on every 10th row(i.e. 10 in cell A10, 20 in cell A20, 30 in cell A30, etc). I want to have a formula in cell B25 that says look in column A and give me or insert the first number I get to when I look at the cells above the current (formula) row...
  16. wec43wec

    "Line / Border" problem when pasting data from Excel to Power Point

    Combo - thanks for your reply, however your solution does not resolve the problem. The issue (I think) is not when I "draw a line" in PPT, the issue is when I copy data from Excel to PPT. The lines within the excel data that contains grid/border for each cell end with an arrow or point at the...
  17. wec43wec

    "Line / Border" problem when pasting data from Excel to Power Point

    I am experiencing a problem when I paste data from excel to Power Point. Data I have borders around each cell with data on / in each row and column. Issue The lines ending on each row (on the right hand side) end with an “arrow head instead of a straight line (like this “?”). The same issue...
  18. wec43wec

    How to Change Font Size in Excel

    Thanks guys, I guess I can not change it without VBA.
  19. wec43wec

    How to Change Font Size in Excel

    How do you control the font size in the Data / Validation / "List" dropdown box in Excel without changing the "zoom" percent from the menu bar and without using VBA? Note: I do not want to change the cell font size, just the display of text font size from the dropdown box.

Part and Inventory Search

Back
Top