Dear Sir,
I wanted to Apply Conditional Formatting with comparing column to column.
I wanted to compare Column A with Column B
If the Value in Column A is greater than Column B then Up Arrow with brown Color.
If the Value in Column A is lesser than Column B then Down Arrow with Blue Color
If...
Dear Sir,
I have over 100 files and more than 10 folders in my PC.
Like Bank statement in PDF.
Accounting reports in Excel.
Bank Letters and Word.
I wanted to make a list of all documents in excel and give hyperlinks so once I click any document it should open.
Please help me.
Dear Sir,
I wanted to get the Ledger Group name in front of the ledger.
For Example, Ledger Name is “ABCD BANK” and Group Name is Bank Accounts
I want result Like Column “A” ABCD BANK and Bank Accounts in Column “B”
Please Help.
Dear sir,
Its a same sheet but I didn't get any response for mail merge so I thought better to ask for excel help only and not for word.
but if you can help me to do mail merge I will be thankful to you.
Dear Sir,
I have excel sheet where I have customer name /currency/amount/location and date.
I wanted the amount to be converted into words and do the mail merge as per attached letter format.
Can you please help.
Dear Sir,
Its great formula, I could not even think about such a big formula for solution, where can I understand how this formula is written because for me to practicing this formula some guidelines required, I can pay consultancy if required to understand this formula.
Dear Sir,
I have two sheets 1) Bank Statement 2) Bank Ledger
My data is not in a same format I wanted to reconcile both sheet and highlight the matching cells with color yellow amount difference with up to Rs 1 can be ignored.
I have been trying to solve this type of problem since years because...
Dear Sir,
My accounting software doesn't generate bank ledger into excel it generates either pdf or HTML what can be done to convert it into excel from html because I tried pdf to excel it doesn't come properly in excel lot of manual work required amount comes in below the dates in some cases...
Dear Sir,
I wanted your help to make customer collection due date reminder.
Customer name
Expected Amount
Due date
Received amount
If due date is 20-11-2022 then on 19-11-2022 that column should be orange as before due date.
If due date is 20-11-2022 then on 20-11-2022 that column should be...
Dear Sir,
output is correct but I didnt understand anysingle line of the formula, can you just help me combine the mutiple formulas like (&,countif,lookup) in single column.
Dear Sir,
I wanted to combine formulas in single formula please help.
Helper1 from column D
Countif from column E
Helper2 from column F
Lookup from column G
Instead of using multiple columns can I combine all four formulas in single column.
Dear Sir,
I have two sheets; one is tally and another one is tally1.
Tally is colored and tally1 is non colored.
I wanted to apply formula or solution to give same color for the same item is available in tally1.
For example: tally sheet has 09-08-2019 Receipt 311784 20800.00 which is colored...
Dear Sir,
I wanted to make one dashboard for my company's performance report which needs to be made from beginning.
Dashboard will include monthly performance report and vehicle report.
I can pay service fees please let me know how can you help.
Dear Sir,
I tried below VBA code but it sending selected worksheet as attachment I wanted to send as range from outlook, I am using office 365.
Please advise.
>>> use code - tags <<<
Sub Mail_Range()
'Working in Excel 2000-2016
'For Tips see...
Dear Sir,
I want an excel macro which will make list all file from a particular folder then I can click on the name of that file and get access to that particular file.
Dear Sir,
I wanted a macro for sending email like selected part of excel with customized message which will save my time to copy and paste from excel to outlook.
Dear Sir,
I wanted to highlight those which are matching with reference number and amount with color ‘YELLOW”
Difference upto Rs 2 can be ignored (excess or less)
If Voucher number is matching but amount is not matching wanted to color “BLUE”
If Voucher number is not matching then wanted to...