Dear All,
I have a source workbook from which I will copy sales data from onto a template workbook to create a sales analysis. The source workbook has dropdown menus at the top of each column which allow me to filter out the blocks of data I need.
How hard would it be to write a macro that can do this for me?
I have attached an example of the source and target workbooks.
For the purpose of an example, lets as I want the macro to find all the lines in the source workbook that read "AREA 1" in column A, "SALES" in column D, and "2013 in column F. Having identified those lines I then want the data in columns B & C copies across to the target workbook entitled 'Sales Analysis Template' and pasted onto the '2013' sheet in columns A & B. And then the figures in columns G-R on the source workbook copied across to the 2013 sheet on the target workbook, and pasted into columns C-N (i.e. the sales figures for January to December copied across and pasted in the relevant columns).
I then need to repeat the process for lines that match "2014" in column F of the source workbook and copy the same information across but pasted into the respective columns in the target workbook, this time on the 2014 sheet, the column layouts are the same as with the 2013 sheet.
Finally I would like to then identify how many blank lines are left over on the 2014 sheet and delete them all the way down to line 1665, retaining the summary section that exists on the template below this.
This is a simplified example of what I am attempting to do, I am confident that I will be able to adapt appropriate examples to fit the real data, and hopefully learn something in the process.
If anyone fancies having a go at helping me out with this, I would be most grateful.
Many thanks,
Dave.
Bookmarks