• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. I

    Vlookup VBA automation [SOLVED]

    Hi all respected! thank you for reading the post. i hope you are all fine. :) i am not well know about VBA code. i need your help for this. below is the link of my file. Sheet "MES" column A2 (and so on) is lookup value. table array is on sheet "COA". i have entered vlook up from Column...
  2. I

    Need Help for Adding Blank Rows after every Row (SOLVED)

    Hi all respected! hope you are fine and enjoying happy life. i have to work with a file of has 500-1000 rows. after every row i need to enter blank row. can you people guide is their any short trick VBA or Formula. Below is the link https://www.dropbox.com/s/f4kfmwdhtz8u6kb/Enter%20Row.xlsx
  3. I

    VBA Error Appears - PDF Export from Excel

    Hi all respected, i am using this article http://www.excelhero.com/blog/2010/04/excel-acrobat-pdf-form-filler.html this is the excel file. https://www.dropbox.com/s/4hggtslic73oqyt/Acrobat_FDF_Form_Fill_excelhero.com.xls problem is when i click on create pdf button "Complie Error:"...
  4. I

    Pivot Table Add % Column

    Hi Friends, I have pivot table in which i have three columns, Shop Name Count of return transaction Count of total transaction i want to calculate the % of return transaction by dividing return transaction/total transaction this all i want to do in pivot, can any one guide me how i...
  5. I

    School Trial Balance Final Accounts

    Hi firends! Can you please provide me any site link or any sample file for School accounting, maintaining >>> Ledger >>> Trial Balance >>> Final Accounts >>> Dash Board if any please >>> Or any kind of school accounts...
  6. I

    VBA to Divide Rows and Transfer to Multiple Columns

    Hi Excel Developers! I need your help. I have a data in "Data" Sheet with 3 columns (A,B,C) and 1500 rows. I 3 columns remains always same but rows changes (Range from 100 to 5,000) I want to divide rows number as total rows number divided by 5 1500/5=300 Now i want 300 rows data in...
  7. I

    Confused Ledgor Balance in Pivot

    Hi Dears Excel Greats I want to get ledger in excel using pivot. i have a sheet in which i am entering advances (Dr.) and their adjustment (Cr.) Format is Date Name Description Debit Credit in pivot i am using slicer of name that i can get the balance (due amount)of a person in...
  8. I

    Code Needed, Excel File not close untill fill the required data

    Hi Brilliants! I have two issues with my file: 1.i have used chandoo's checklist in my file, but at the time of opening its shows an error which repair the file and save as new file. 2. i want a code that someone can not close the file untill fill the required fields. The file i attached...
  9. I

    Data Duplicate

    Hi Friends! I have a file with 1 coulumn and 400,000 rows. Its bar code file. Our data base of bar codes is regularly updating. today is 400,000, data after 2 days it will be 400,200. My issues is when i use duplicate formula it works, but when i sort the data by color, it hang my system, as...
  10. I

    Data Transpose from 4 Columns to 12 Columns (from 12000 rows to 4000 rows)

    Hi All, I am in trouble at office, i am doing a very boring & repeated task on daily basis, can you people give me a VBA or any formula to make me awesome at office. I have data in 4 columns and 12000 rows, i want to divide it in 12 columns & 4000 rows. But problem is that it will be...
Back
Top