werra2006
03-07-2013, 03:26 AM
Hi Peeps
I am a complete VBA newbie & have a challenge for you. I’m trying to automate my spreadsheet and populate the worksheet “data capture” with monthly totals from information obtained from the raw data worksheet. What I had done in the past was to build a kind of database in Raw data adding information month by month and then using formula lookups to populate “data capture” totals. In the raw data worksheet, I paste information in columns C to AC and the other columns are formula driven. However, my spreadsheet often crashed and furthermore, I also need to add more worksheets to the workbook.
What I want to do, is be able to put in raw data, a month’s data and run a VBA script to identify the month that the data belongs to & populate totals in data capture for that month. Following month put in again that month’s data & do the same again so that I don’t have to retain every month’s data in the raw data section as the spreadsheet will crash.
I have attached the spreadsheet
I am a complete VBA newbie & have a challenge for you. I’m trying to automate my spreadsheet and populate the worksheet “data capture” with monthly totals from information obtained from the raw data worksheet. What I had done in the past was to build a kind of database in Raw data adding information month by month and then using formula lookups to populate “data capture” totals. In the raw data worksheet, I paste information in columns C to AC and the other columns are formula driven. However, my spreadsheet often crashed and furthermore, I also need to add more worksheets to the workbook.
What I want to do, is be able to put in raw data, a month’s data and run a VBA script to identify the month that the data belongs to & populate totals in data capture for that month. Following month put in again that month’s data & do the same again so that I don’t have to retain every month’s data in the raw data section as the spreadsheet will crash.
I have attached the spreadsheet