Hello,
I need some help to complete a macro. I have been googling around to see if I could figure it out myself but with no success.
In Sheet1 I have data that contains a list of accounts and the amounts on these accounts. In Sheet1 in Column C, Cell C11 is the first line, "101300 Issued Share Capital". I want to copy only the account number into Sheet2 cell A2. I want this to be done until a cell with the text "* Accounts" appears in the same column. Next I want to copy only the characters after the account number, eg the name of the account to Sheet2 Cell B2. After that I want to copy the amounts starting from column E, C11 until a cell with the text "* Accounts" appears in column C. Sheet1 should be left intact with no changes.
Many thanks for your contributions!
I need some help to complete a macro. I have been googling around to see if I could figure it out myself but with no success.
In Sheet1 I have data that contains a list of accounts and the amounts on these accounts. In Sheet1 in Column C, Cell C11 is the first line, "101300 Issued Share Capital". I want to copy only the account number into Sheet2 cell A2. I want this to be done until a cell with the text "* Accounts" appears in the same column. Next I want to copy only the characters after the account number, eg the name of the account to Sheet2 Cell B2. After that I want to copy the amounts starting from column E, C11 until a cell with the text "* Accounts" appears in column C. Sheet1 should be left intact with no changes.
Many thanks for your contributions!
