francri
03-21-2011, 06:33 AM
Hi All,
I am very new to excel and VBA, I can record a macro and then go to edit and generally get a good feel for the syntax, but I am coming unstuck very quickly...
I have a report in excel which is delivered from 4 people on a weekly basis. the report shows number of requirements open + various data on one worksheet (Open), and number of placements made + various other data on another worksheet (Placed).
What I need to do is collate all of this data into one on a weekly basis, then create a monthly consolidated that will show how many requirements were open in the month, how many palcements were made etc.
I have attached an example spreadsheet. The weekly report are the first 2 worksheets then the monthly summary is the rest.
I wonder if anyone is able to point me in the right direction with this.
thanks in anticipation
I am very new to excel and VBA, I can record a macro and then go to edit and generally get a good feel for the syntax, but I am coming unstuck very quickly...
I have a report in excel which is delivered from 4 people on a weekly basis. the report shows number of requirements open + various data on one worksheet (Open), and number of placements made + various other data on another worksheet (Placed).
What I need to do is collate all of this data into one on a weekly basis, then create a monthly consolidated that will show how many requirements were open in the month, how many palcements were made etc.
I have attached an example spreadsheet. The weekly report are the first 2 worksheets then the monthly summary is the rest.
I wonder if anyone is able to point me in the right direction with this.
thanks in anticipation