Possible to do it in excel ?
Hello, I would like to know whether the following scenario can be done in excel ?
For example, when I download some data from the accounting software to excel, the data would be as follow:
Column A :Name
Column C: Amount
Just wondering is that possible to have a VBA code to automatically insert "PP" (name of the worksheet) into column B
Attached is the example: