Recent content by dvsdasari

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