Search results

Apologies to Mr. Azeez for thread hijacking.

Thank You Narayan for your efforts on my file.

Thanks for your efforts Narayan. In column U, all amounts greater than 180 days should appear. I have changed the formula in "U594"., but there could be a better way to do the same. Also need summary customer-wise. I have done some work, but please check in sheet named "summary" I have sent...

Part payment also possible, but that data would come from another workbook, and should be adjusted against the oldest unpaid bill. Thanks Naryan.

That is correct. all paid, and all the above are below 30 days - the days appear in column W. Assuming that the invoice dates are different, then it should appear as Ccode: 30 days : 60 days : 90 days : 120 days. 218 18901(1 bill) 11939 (2 bills) 25053 (1 bill)...

The current listing is listed bill wise. Each customer has a code in column E and there are repetitions. i.e same customer, many bills with different dates. I would require one customer per row and the total dues, 30, 60, and so on in the next columns. Hope I was able to explain it well...

sorry ! the link is https://skydrive.live.com/redir.aspx?cid=25637f1c5ce5899f&resid=25637F1C5CE5899F!124&parid=25637F1C5CE5899F!105

Hi Azeez & Narayan! here is a link to a file that I use. https://skydrive.live.com/self.aspx/.Public/creditors-debtors-age-wise-report.xlsx?cid=25637f1c5ce5899f Hope this would be useful. A date field is very important to calculate the number of days. You can modify it for your use...

={sumproduct(Hui+Luke+Narayan+Chandoo+allmembers:MerryChristmas*10000)}

Thanks Luke, Will try ! quite useful.

Hi, where do we enter this, in a module ? Thanks.

Thanks so much Vijay. Could bring it back. Thanks for teaching a new feature. Regards, Shajan.

Hi Vijay, Thanks for the info. I hid one, and now I can't unhide it. The sheet had a different name, not Sheet2

Thanks Prasad, Will try it out. Regards, Shajan.

Dear Hui and Prasad, Thanks for the reply. Tabs grouping, I tried, it works fine, but is there a way to replicate the same in another workbook ? i.e I insert 5 rows in A.xlsm, it should insert the same 5 rows at the same position in B.xlsm. I am trying to consolidate data from different...

In one work book, I constantly add rows in between Rows 8 & 14. If I add 5 rows in the raw data work book, I would like to have the same rows inserted in another work book automatically. Any ideas. Thanks.

This is a wonderful VBA code. Thanks for sharing it John. Further, if you password protect it, no one will be able to view or delete it. Am I right ?

Thanks a lot Narayan ! Your formula worked the way I wanted it. Will have to study the way this works. Thanks to Luke too. Shajan.

thanks very much for your reply, i could not get the second part of it. I have posted the file here. http://www.4shared.com/file/MsGh_xFX/test_balance_sheet-1112.html Thanks.

Hello Friends, Please help with a formula. I am trying to get the value of column C, 11th Row from top. When filtering the 11th row changes value, and I would want the changed value in another cell (C8). Sample worksheet link is given below...

Not yet, the problem seems to stem from some objects, macros, etc, Once all these are gone from the excel sheet, the problem is resolved but the functionality reduces. Hui did remove the objects, but when inserted again the problem starts. I read somewhere that we need to wait until next...

Mailed to you. Thanks.

Hi Hui, Thanks for the warm welcome. I checked the Data Connections. The Workbook connections are empty and the problem persists. Thanks.

Hi All, Could anybody help solve this issue. I am using Excel 2010. When opening a file, I get this error message : "Excel found unreadable content in 'file name.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes. and when I...