User Profile
hussein_elsayed
Brass Contributor
Joined Feb 28, 2022
User Widgets
Recent Discussions
Re: Excel help
HansVogelaar Dear Mr. Hans, Could you please help me for the attached issue as i did some modification in the master data sheet (adding culumns and rearrange some of them) but it shows error when i tried to run the macro. and sorry for send my issue in a private message. Thanks in advance2.6KViews0likes4Comments- 2.5KViews0likes0Comments
- 2.6KViews0likes0Comments
- 8.2KViews0likes0Comments
Need an assistance for formula
Dears, is that any way to make the lookup interest in the attached sheet to be easier than the exist formula (highlighted in yellow) specially when i add a new rate in the seconed sheet (rate sheet). waiting your kind assist. Thanks in advanceSolved8.3KViews0likes2CommentsRe: innovative way to display data
mathetes i put some reports in the attached file - Sheet (Dues) i need to add formulas to sum the total collected (F) from sheet collection details and settle the first dues based on earliest dues till consume the total collection, also i need to calculate the culumns from (H:L) based on the due dates and the monthly closing date lets say 31-03-2022 - Sheet aging for ar balances, i need to calculate the Ar balances (sheet dues Culumn G) and the critira range will be project culumn (A) and the due date (E) - Sheet Delayed AR balances to calculate the delayed dues (AR balance in sheet dues_G) based on the due date in sheet dues - sheet unit reprt i need to filter by unit to show all details related to the unit. I know I'm bothering you, but I need help, even with an idea Thanks You2.5KViews0likes3CommentsRe: innovative way to display data
mathetes Dear Mr. Mathetes i'm sorry for the inconvienient, let me explain more to make that issue clear. I have a list of different units’ column (B) that sold with list of amounts column (D) with different payment date column (E) my input is entering the payments only and for the first columns (A: E) without change still as it is Here under explanation of the attached sheet I hope to be clear for you 1st I have a list of dues per date per unit Unit Due Date NE04-B-1702 25/01/2019 NE04-A-0506 16/03/2019 NE04-A-0506 16/06/2019 NE04-A-0506 16/09/2019 2nd I have a list of collection in columns that covered the above dues that paid in different date Payment_1 Payment_2 COLLECTED CLEAR DATE Rec# COLLECTED CLEAR DATE Rec# 160,000 02/04/2019 5006 61,598 09/04/2019 5008 3rd calculated field (BE) that refer to the outstanding dues which = amount in column (D) - total collected in column (AW) My question is Is there any way to present the above date to be clear or understandable for anyone? I hope you got my point. Thanks2.5KViews0likes5CommentsRe: innovative way to display data
mathetes First of all i'd like to thank you for your valuable points. - i have a large data i just sent only sample and i will attach the whole data sheet - i need to make the attached data to be clear for any one to use - i need to creat some reports for aging and customer balances and any other usful reports to tracking the outstanding client dues. could you please help in this issue and thanks in advance2.6KViews0likes7Comments
Recent Blog Articles
No content to show