ms excel vba

Hello I have 2 tables, first table contains many invoices in date order. The second table contains payments. Some payments can be for more than 1 invoice. Some payments can be for part of an invoice. Oldest Invoices are Paid first. What I want to do is to create 2 additional columns on the...

Friends, I want that when i type in excel sheet it should merge the cells automatically. For example as I start typing from cell no A1 and continue typing to cell no E1 then the range from A1 to E1 should automatically be merged. Moreover I want to assign tooltip to the new customized buttons...

I have merged two ranges in excel sheet, but it is leaving one line between the merged area of the both ranges. I wish to remove this line but could not succeed. I have adopted many ways but everything failed. I am attaching the image of excel sheet showing which line I want to remove. Please...

Hi, I'm new, and I'm not sure if this has been asked before in this forum (if it's been inquired before, please direct me to the right forum/discussion thread) or if I even chose the right forum for this (kindly direct me to the right forum). I have a project of reducing worksheets that we're...