Search results

Hi Team, What is this poll, what is it used for. Is there any option other than OK?

Hi Oak Ville, In that case I do not think we can propose how your company should allocate the budget based on performance

Hi Arvennis, I would use vlookup and or match/index and then copy/paste values once all the data is in place. However, if I may suggest that you structure the file so that you have the transactions one below the other in a database format, this will enable you to do more analysis on the data...

Hi Oak Ville, The problem I am having is seeing how the various Dept performance translates into the Total performance, and without this it would be difficult to allocate the Budget. I tried to split the Budget of 600,000 into a base of 570,747.66 (600,000/107*100) and the balance of 39,252 and...

Hi Ram, You can password protect your sheet, in order to make that work you must "Lock" all cells that are protected first. I notice that the Cells with formulas are locked, all you now need to do is enable the Protection for the worksheet. For the you will have to create a form, write the...

Hi Ravi, I have redone the formulas on the file, please study the forulas and let me know if it works for you, we can then progress to how you want to set up the macro. I am not sure what your inputs into the macro will be,

OK, I am in Tuban, Jawa Timur

My pleasure, btw are you in Indonesia?

This may be a problem of not finding the Workbook, remember the formula "Changes" for closed and open workbooks. If you link to an open workbook, there is no path: This is the formula when the source file is closed: ='C:\Users\xxx\Desktop\[Sum2011.xlsb]Bank_DB'!$F$1519 this is the formula...

Hi Stormania, Please look at the attached file, I have entered a calculation in the contribution column and then Pivoted the data.

It is that time of the year when we do a bit of reflection. I would like to wish the whole community of Chandoo a very safe and joyous Christmas. And would also like to thank everyone for expanding my limited knowledge of Excel. Kanti

Hi Ell, good to know it worked

Hi Krishna, Not sure what you are doing, you cannot generate an amount in a random cell, the RANDBETWEEN formula must be in a cell for that value to appear on the sheet, so if the amount of the generated is in say cell B50 and you want the amount in A1, you can either enter in A1 =B50, or you...

Hi jdppep, Look at the attached file and change to suit. kanti

Arup in A1 enter the following: =96-AGGREGATE(2,5,$D$3:$CU$64)

Hi Arup, not sure what you want counted, do you want to count the number of blank cells in the whole table, the number in a certain column. So if you put the following in D65 it will tell you there are 33 blank cells in the column D =COUNTIF($D$3:$D$64,"")

Hi Ell, Here is you file updated, you will note that I had to change the Status header on the hide sheet. Do you still require a further layer of dropdowns?, if so please send a file with an example of the end result and all the lists involved. regards kanti

Hi Ell, Have you looked at the file I sent, it has no VBA only formulas and named ranges, Have updated your file

Hi Kiran try this insert a column B and enter this formula in B1 '=INDEX(C1:G1,1,MATCH(TRUE,INDEX(ISBLANK(C1:G1),0,0),0)-1) cheers kanti

Hi Ell, Look at attached, please remember you need range names for all list, the range names in this example are not dynamic, but they can be made dynamic with the Offset and Count functions. Let mo know if this is ok

Hi Steve, Been away, what is the status on this thread, is it working, if not where do you stand with the problem? kanti

Hi Jack Are there any event driven Macros on your system, in other words, Worksheet Change? Maybe in another open workbook.

Hi, Here is a Utility that i have been using, it copies from specified files and ranges in closed workbooks to a range specified in another closed workbook. cheers kanti

Hi Jack, Attached is a file that I use to copy data from Closed files to Closed files. You give the name of the Source File, The sheet name and range and the same for the target. try it out cheers kanti

Jack, we may be able to overcome the Macro protection by creating an independent workbook with the Macro, it will then Open the Source Book, copy the data, Open the Target Book and Paste the same data into the Target workbook. cheers kanti