I have read a lot of the earlier posts in this website and have found it remarkably helpful. I was wondering if I could get some help here. I am absolutely new to Macros. I know Excel pretty well.
I have been assigned to evaluate a weekly trend of arrears. Unfortunately, the system in my company does not keep any past data. I have made an excel sheet based on simple formulas and all the calculations form a part of one column (lets say Column A). So with every week, the data in column A changes.
I wanted to use macros where the end-user has to click a button called copy and the data is copied to another column (Say Column C) on another worksheet (Say Sheet2). After one week, when the revised calculations are made, the end-user clicks on copy once again and the new values in Column A are copied to COLUMN D and not column C on sheet2. This keeps happening as a weekly thing.
Help will be much appreciated.