Angelos Voulgarakis
New Member
Hi Guys,
I am quite new to Macros in Excel. I have been given a small project to accomplish by next week as follows.
Basically, there are a list of account codes in columns in my import worksheet and my Profit and Loss worksheet.
In my profit and loss they are sorted in a P/L format, however in my import file they are completely random as provided by the accountant.
I am in need of script, that when I click on an Active Button it will search the columns of account codes for a match between the Import and Profit and Loss summary worksheets and if successful then copy and paste the closing balance column from the import worksheet into the current months column from the Profit and Loss summary worksheet corresponding account code.
Thanks for your assistance.
AV
I am quite new to Macros in Excel. I have been given a small project to accomplish by next week as follows.
Basically, there are a list of account codes in columns in my import worksheet and my Profit and Loss worksheet.
In my profit and loss they are sorted in a P/L format, however in my import file they are completely random as provided by the accountant.
I am in need of script, that when I click on an Active Button it will search the columns of account codes for a match between the Import and Profit and Loss summary worksheets and if successful then copy and paste the closing balance column from the import worksheet into the current months column from the Profit and Loss summary worksheet corresponding account code.
Thanks for your assistance.
AV
