• Microsoft Excel: Accumulative sum for 12 month period

    How can I add accumulative sum for 12 month started from JAN to DEC. If data in JAN is zero, then accumulative sum from FEB to JAN. If data in FEB is zero, then accumulative sum from MAR to FEB and so.

    NavinSinha19665 pointsBadges:
  • Is there a better way for material requisition from warehouse to production?

    Hi SAP expert, Now my company is using a somewhat old fashioned way for MR (material requisition) which is as per below steps: Prod raise MR using email (excel format) Warehouse receive email and check stock through LS24 Warehouse pick pack and PGI via MB1A or MB1B Is there any better way to use...

    philip574910 pointsBadges:
  • Oracle Reports 6i – Convert data in Microsoft Excel

    How do I convert Oracle Reports 6i data into a Microsoft Excel through coding on button?

    Sskhan35 pointsBadges:
  • Windows 7 cannot open Excel file

    I'm the Information Technologist for a manufacturing company and have a Dell workstation running 32-bit Windows 7 and MS Office 2007. When the user attempts to open a particular Excel file, Excel complains that the file is corrupted. Yet other employees running Excel 2007 under either Windows XP or...

    johnjam2325 pointsBadges:
  • Convert report to Microsoft Excel

    I used ole2 to convert report to Excel but Arabic fonts appear in the form :ÚÈÏÇáÑÍãä ÚÈÏÇááå ÇáÕäÚÇäí 5*967. How I can solve this problem?

    jabbary15 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Import and Export data from AS/400 using ODBC

    I imported data from AS/400 database file into an Excel sheet, using ODBC. I selected Microsoft query in order to retrieve data. How can I export data into AS/400 database file?

    Geek51180 pointsBadges:
  • How to keep font size the same when exporting Crystal Report to Excel

    How can I keep the font size the same when exporting a Crystal Report to Excel?

    Howudoin15 pointsBadges:
  • Conversion of Microsoft Excel formula to Access

    How do I convert the below given formula of MS Excel to MS Access for the following data: ID Level Session Gender Regular/Plus Shift Programme Section 13 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-4 14 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-3 15 INTERMEDIATE...

    MUHAMMADYOUSAF10 pointsBadges:
  • Open a .DBT file in Microsoft Excel

    I need to open a .DBT file in Excel. How can I do that?

    DavidPotts5 pointsBadges:
  • Save XLA files in Excel

    How do I save XLA files in Microsoft Excel?

    melrice5 pointsBadges:
  • how to save crystal report in excel format ?

    hi i wanna to save crystal reports as excel form so can anyone help me

    Romanticknight5 pointsBadges:
  • Excel data put in Oracle Forms

    Sir, how do I open Oracle Form 6i and make button? And when the button is pressed, how do I import Excel data into my Forms block?

    USAMAKHALID5 pointsBadges:
  • Paste records in OLE Unbound Excel Object in Access Form

    Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build a database with a table...

    Brianaaskew40 pointsBadges:
  • Insert a function in Microsoft Excel

    In cell f15, insert a function that will automatically display the word discontinue if the value of cell d15 if less than 1,500 or the text no change if the value in the cell d15 is greater 15000.

    senem25 pointsBadges:
  • VSTO 2013 add-in installation error

    We created add-in for excel using VS 2013 and made an MSI installer (ISLE) to make this add-in to support for Excel 2007, 2010 and 2013. When we run the setup, we are facing issue stating that "Unable to read registry value". Please help me to solve this issue.

    saravanangj5 pointsBadges:
  • Creating a daily Microsoft Excel formula

    I am trying to create a formula which will total beginning date to present date. But present date is not used in Excel work sheet. How can I set a formula, that will give me a daily count upon opening the worksheet?

    aastra5 pointsBadges:
  • Cross reference macro across worksheets in Microsoft Excel

    My end game is to copy 1st row across 12 calendar sheets starting with 1st sheet (January) and list rows on new sheet then go to next row on 1st sheet to copy across the 12 sheets and list to 2nd added sheet and continue repeating same task for total of 60 rows and total 72 sheets. each row has 10...

    krashnburn7145 pointsBadges:
  • VBA Help Needed: How to Unprotect sheet, Update Stocks on Excel sheet, Reprotect sheet

    I was trying to update some stocks and commodities links on a protected sheet by creating a button to update but before the update occurs the sheet becomes protected. If I disable the re-protection of the sheet it will updated the stocks and commodity prices but the columns width doesn’t adjust...

    abcmustafa10 pointsBadges:
  • VBA code to transfer data from iSeries to Excel

    Hi everyone, could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then transfers...

    Mblair.au25 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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