Posts

Showing posts from March 10, 2019

How can I copy specific rows from several worksheets to another with Excel VBA?

Image
0 Every month end I have to copy data (say rows 4 to the last row of some worksheets (say worksheets 2 - 7, but in fact there are numerous worksheets and rows) to worksheet 1, start the pasting from row 4 of worksheet 1. I do try my very best to look out the answer from stack overflow and other website. Given I am a layman of VBA Excel, I can't really customize those code to my case. I would be very grateful if anyone could give me a hand. Thank you. Below is a fail example I do by myself Sub test1() Workbooks.Open Filename:="file location" Worksheets(2).Activate a = Cells(ActiveSheet.Rows.Count, 1).End(xlUp).Row For a1 = 3 To a Worksheets(2).Row(a1).Copy Worksheets(1).Activate Worksheets(1).Rows(a).PasteSpecial Next End Sub Thank...

Are Advaita and Karma theory completely contradictory?

Image
5 As per Karma theory, certain events of my current life are the fruits of my actions in one or more earlier births. Whose action's fruits am I facing in this birth? Given that it cannot be my current body or mind, it follows that it has to be my Atman . But according to Advaita, only Brahman exists and everything else is the product of Maya. In particular, the seemingly different people we see are all Brahman and seem different only because of Maya. Then how is it possible to determine the me from a previous birth? If one can indeed determine the me from the previous birth then does that not directly imply duality contradicting Advaita? In fact I do not see how rebirth is even possible in the context of Advaita. Who is getting reborn? There is only Atman which manifests as duality through Maya. One ca...