Search results

Thanks for Sharing, it is really helpful. I have one more question related to this. If we have referred more then once a cell (i.e., in cell A1, b1+b2+b3 (or) sheet!c1+sheet!c2+sheet!c3) to a formula, how to select all those multiple cells with a shortcut key. Thanks-Sekhar

Hi, I have data in two sheets and i put some formulas in sheet1 by refering some cells in sheet2. Can i select all those referred cells in Sheet2 (where the cell i got result by refering cells in sheet2) with any keybord shortcut or is there any tip for this. Thanks-Sekhar

Hi SirJB7, Please download the file in the following link and run the two macros, so that you can easily understand what he actual requirement is. Please run the macro as per below sr.no: 1. Transfer data 2. Copydatawithout headers...

Hi SirJB7, I have just provided the macro which i'm using right now to finish my work, but it is not the benchmark. You can do what ever the easy way you feel to get the output as you shown in consolidationNEW sheet. Thanks-Sekhar

Hi SirJB7, I'm very thankful for your effort and time. It is perfectly fine which you prepare with help of formulas. Please check that there is any other way to do it with easy way like macros or any other procedures. I've one macro which i'm using (got it from chandoo.org), please look at...

Hi Hui, Thanks for your fast reply. We cann't change any data in Data sheet of the attached file. We need to convert data like format showing in the consolidated sheet (i.e., Particulars+410 cost centre including debit,credit and Closing balance. Below 410 cost centre - Particulars+513 cost...

Hi, I'm trying solve this problem since five days but i didn't get correct solutions for this. Here we have two sheets, one is the data which i downloaded from software. Second one is format which we need to convert the data in the first sheet. I need to convert the data in the first sheet...

Hi, Thanks for all experts to the above info. I just need small changes in the macro of Mr. Luke The macro is coping one specified range. Please modify little bit and add some loop for me as per the following info. I have one worksheet (sheet name: data) contains 100 columns. I need to...

Hi Gurus, Thanks for lot of help and sharing your thoughts through this website. I have a problem that whenenver i am trying to open a existing workbook, it is opening along with a new workbook. I don't know what is reason behing this. I am using excel 2007 on Windows7. Please help me...

Hi, Thanks for the all help i got from here. I have uploaded a workbook, which contains data downloaded from my accounting package, formulas and final output. Following is the link........ https://dl.dropbox.com/u/86812629/test1..xls Please check column H,I,J,K in test worksheet and...

HI, We got lot of help form this website. We should thankful to all experts who are delivering their valuable ideas here. I have just posting some data here, can any body please try to develop some process. If it is possible, it' very useful to me. Please check attached file in the...

Hi, I have a worksheet containing 1000 columns with lot of data. The data in worksheet as follows.. AB (columns) (1,2,3,4 is rows) 1 Voucher No Narration 2 001 testing for excel 3 4 5 002 sales in south division 6 7 8 9 10 003 sales in north...

Hi, I have data in on worksheet as following.. columnA columnB 1 11 test1 2 test2 3 13 test3 4 5 6 7 14 The result should be following manner.. columnA columnB 1 11 test1 2 test1 3 13 test2 4 test2 5...

Hi Narayan, You are right, each and every file has started with the unique ID of the vendor ( as mentioned in the previous post). Thanks-Sekhar

Hi, I can give you the file names as ........... AAACB2894G_FORM16A_2012-13_Q1 AAACC4175D_FORM16A_2012-13_Q1 AAACD2145G_FORM16A_2012-13_Q1 and so on...... Thanks-Sekhar

Hi Asa, Thanks for reply. The problem here is, there is no way to find out the file of a particular vendor. The file names are saved with a unique ID of Vendor. For example, I have a vendor called ABC Company. If we want to save the above vendor file into a seperate folder, we need to...

Hi, I have 750 pdf documents of my company's barnches. I need to seperate all those pdf documents branch wise. For that we need to open those pdf files through excel hyperlinks and save in folder (opened files). Please help me out on this. Thanks-Sekhar

COL A COL B COL C COL E COL E COL F 1 dept a/c code Apr-11 May-11 Jun-11 2 123 500123 10 10 10 3 456 500124 11 11 11 4 789 500123 12 12 12

Hi Narayan, Thanks for your quick reply....... There is no date in column A, it's just row number for ref. in cell C2 is matcing criteria of headers (here it is Apr1-11). the overall creiteria here is.... We need to match with dep and a/c code for apr-11. The result should be 10...

Hi, Can any one help me out in this formula. COL B COL C COL E COL E COL F 1 dept a/c code Apr-11 May-11 Jun-11 2 123 500123 10 10 10 3 456 500124 11 11 11 4 789 500123 12 12 12 =INDEX(B2:F5,MATCH(B3&C3,B2:B5&C2:C5,),MATCH(C2,B2:F2)) Here, we need to match A3 and b3 in col a and...

Hi Narayan, Thanks for your reply. As you said abouve 1&2 points are OK. Third point is #of Months (no of months is calculation from satart date - end date, which is entered manually) Start date and end date should enter. The criteria is-- I have paid an amount of Rs.1000 to MR. A in...

Hi, I am working on the same thing since two days, bur i cann't find a solution for this. Here my requirement is to distributr the amount based on the START DATE AND END DATE. Following is the example....... paid exp payable #of Mon START END 01/01/11 01/02/11 01/03/11 01/04/11...

10399 Result 10400 1ADVANCECOMP10399/10400/10401/10405/10624/10625/10626/10627/106 30/10631/10657/10658 10401 1AIRCON 11240 10405 1AMSTAR 10145/10689 10624 10625 10626 10627 10630 10631 10657 10658 1ADVANCECOMP 11240 1AIRCON 10145 10689 1AMSTAR 1APIICL 11014 1BHARTI31...

Hi, I have problem with sumif,index and match formula. My data is as follows V.No. Particulars Debit Credit Category 1 test1 55 AP OFFICE 2 test2 60,000,000 CONTRA 3 test3 5,126 AP OFFICE 4 test4 120,603 TDS 100000 TDS Here we are using the sumif,index and match formula...

Hi Luke, Thanks for your reply. Sorry for the confussion. 1. Each employee comes under different dep (like 115,181,191). We need to get unique depts from the list. Finally..... We need Basic for all depts Like.... Dept Basic BasicCode 115 10 511001 115 10 115 10 181...