• Convert Microsoft Excel calendar week into date

    I apologize in advance if this doesn't make sense but, in Microsoft Excel, we have a week number and the associated year. In our Excel sheet, can we calculate the date of the Friday of the week in a cell? Is there a formula? Thank you very much.

    ITKE434,335 pointsBadges:
  • Filter Microsoft Excel table

    In Microsoft Excel, I have a large table that I need help filtering with. Furthermore, several of my users asked me to get a total row at the end of it. Here's my concern: Won't the last row be filtered as a normal row? Basically, can I sort out that last row so it's not filtered? Thanks!

    ITKE434,335 pointsBadges:
  • Store MySQL query in Microsoft Excel

    I have a MySQL query and I need to store it in Excel. Here's the query I have: SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult WHERE taskResult = 2429) How can I go about doing this? Thank you very much.

    ITKE434,335 pointsBadges:
  • Excel crashing when emailing ranges

    Hello, I have created a worksheet for my company that covers all areas of our business. I have inserted ActiveX buttons allowing me to email only certain cell ranges directly to the body of the receiving email address. I have also created a terms and conditions box as well as contact information,...

    Peanut430 pointsBadges:
  • How do I extract the top 5 from an Excel column if there are duplicates?

    I have a stats sheet and need to pull the top 5 players' names and their stat out.  The issue is that I get the first player's name (that has the stat) for each entry that has the same stat total. In the example below I get Rae for both of the "5" stats...

    mtnmaiden5 pointsBadges:
  • Convert PDF to Excel

    How to convert PDF to Excel?

    LDS5 pointsBadges:
  • Editing excel file after converting it from pdf file?

    At first I convert the pdf file to text file using acrobat reader. after that i open the file through excel.  But i didnot get proper output of my file as the pdf format. the pdf format contains picture & tables also.

    Papuli5 pointsBadges:
  • PDF format file change to Excel

    My friend got one PDF file and contain some table based data. How can we convert that file to Excel format?

    Tonycheng5 pointsBadges:
  • Critical Path

    I created a project plan and everything looks normal but when I want to view for a critical path (using Gant Wizard Chart), I don't see any critical paths. I am wondering what went wrong

    MSProject5 pointsBadges:
  • Finding the list of processes executed on a queue

    I want to generate an Excel sheet of processes executed on particular queues. Please assist.

    makxxd3564565 pointsBadges:
  • ASCII code VS. ASCII text file

    If I convert an excel spreadsheet containing hundreds of sheets in the workbook to text file format is that the same as ASCII code? Also, is there a way to convert the whole workbook or do I have to do each page one at a time?

    zoombug5 pointsBadges:
  • Analyzing an Excel spreadsheet divided by categories and subtotal

    Column B has various vendors, column F Has Totals, Row 5 has a category subtotal which totals all categories in column 250,and row 7 starts a new category. I would like to create a total of each vendor in a table, what is the best way?

    Kerrie12345 pointsBadges:
  • Reading Excel with RPG HSSF

    I set up a program to read Excel on my AS/400 using the klement examples then move to user AS/400 and cannot get it to read the Excel. Program compiles fine.

    mr400man5 pointsBadges:
  • Row of data not transferring to Microsoft Word when using mail merge

    I'm using mail merged to transfer data from Excel to Word for my job. I just had to write a bunch of code to update to Word 2013 for it to work. However, when I try to transfer everything, it works perfectly except there is a whole row of data that does not transfer to the Word document. Everything...

    SARAHCYOUNG205 pointsBadges:
  • Export / import data from Excel to SQL database

    Hi, I want to do one program in which I have one Excel sheet that some data can be stored. I want to import that data in VB.NET application and store it in a SQL database and do same thing vice versa. Which means I can fetch data from SQL database through VB.NET and store that data in Excel. Please...

    qwertyudicdi10 pointsBadges:
  • Microsoft Excel: How to find top 10 figures based on a condition like country wise

    I do have sales figures country wide and i would like to make a separate table for each country and populate top 10 sales figures in XLS. Thanks in advance.

    rangagom15 pointsBadges:
  • Load Excel with Japanese characters to iSeries DB2 file

    How do I load an Excel spreadsheet containing Japanese characters to an IBM iSeries DB2 file?

    tonycurtis135 pointsBadges:
  • MS Office 2007 Excel files not opening

    I have MS Office 2007, Windows 7. When I double click on an XLS file, Excel opens up but it is just a empty Excel program. It is similar to opening up Excel and then just closing the book1 that opens up automatically. Just a grey background. Also I can't open up XLS files by doing File > Open or...

    CharlessReynoldss5 pointsBadges:
  • Copying Outlook messages into Microsoft Excel using VBA

    I'm fairly new to Macros and VBA. So, on a daily basis, I receive roughly 50 emails with one specific subject - Task Completed. Now, I made a rule that moves them directly into a Task Completed folder. But now reading all these emails has pretty much consumed my day. Is there a way I can copy these...

    ITKE434,335 pointsBadges:
  • VBA Exporting to text file

    I am trying to make a VBA to copy multiple cells from excel to notepad in this sort of format: Interface GigabitEthernet1/0/1 Switchport access vlan 990 shut But all I seem to be doing is copying the top line over and over again. Here's the code I've been using: Sub exprtToText() Dim ff As Long,...

    Dozii35 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following