A spreadsheet updates information on a weekly basis.When we record the macro when can only select a particular column in excel to copy. Once the spreadsheet is updated the system automatically recognise that a new column is updated
I am recording a macro to extract data from another spreadsheet which is updated on a weekly basis. When recording the macro the system recognises which column to copy and paste, but when the spreadsheet is updated the following week the initial macro would still copy the initially specified column and does not copy the new weeks data. Please can you advice me on the process if there is one to make the macro intelligent enough to capture updated figures. Your help is greatly appreciated.
Yes, it is always the last right column which is suppose to be copied. I am sorry but I dont understand what the second part of your question means. Its row number 4 that we can look at to determine the last column updated. Thanks