Posts by VbaNoExcel

    Hi , i am newbie in terms of using VBA and also here. I have a silly query which i cant seem to solve at all.

    I have 3 Tabs for 3 products which have Monthly Columns (columns are from column 3 to column 55 as it is for 3 years) and various revenue/ expense rows (rows are from row 6 to row 122). i also have a Total Tab which adds all those product tabs by column and by rows. Not sure how to write a simple code for this. I wrote this crazy lengthy code. Is there a simple code for this?

    Thank you Seniors, in advance for your kind help!