1. J

    APA Assistance

    Hello incredible people. Below, you will see APA citations for articles I have to read. Journal articles end with a number and a parenthesis but only some have page numbers. Books have state names or abbreviation and the end of the citation. I would like a column to identify it I am citing a...
  2. J

    Index and Match error

    Hellol everyone. I have a trial balance and a list of journal entries: I am trying to retrive the values coming from the journal entries table to the trial balance by the voucher number. I using index and match with an array but i am getting #NAs . Dont know what i am doing wrong in the formula...
  3. C

    IF(AND function

    Im trying to use an IF(AND function for a set of data that ive attached a sample of below, basically what i need the function to reflect is: The expected revenue account codes (4 digits - highlighted top left) that agree with the predetermined acceptable journal entry numbers (5 digits -...
  4. B

    Multiple input values to be matched to return from a single list

    Dear All, Firstly I would like to thank Mr. Excel forum which has solved many complex queries which I had in regards to Excel. Finally I had post a thread for a solution which I didn't find. <tbody> Crank shaft Bearing journal - Main Bearing journal - Rear Intermediate bearing...
  5. C

    excel and SAP

    Hi i am using SAP at work and can post a basic journal using FB50 but need want to upload a journal i have in excel can someone show me the steps to upload. do i need a template for the jnl please help
  6. girapas

    Macro to change month and year per page

    I need a sheet to enter data monthly, one month per printing page. In the first row of each page I want to be the year (column A) and the month (column B). How can run a macro to prepare a 10 years sheet, starting from January 2011 and ending December 2020 ? Thanks in advance
  7. S

    i want to automatic daily juornal or roznamcha different sheets

    i want to automatic daily juornal or roznamcha gather current date data from different sheet to specifec sheet i am trying with advance filtering pivot table consolodating but still not solved my probem

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...