alexnicholas
02-22-2007, 10:10 AM
Hi
I'm sure most of you will be able to do this in your sleep and have probably answered this sort of question already. I've attempted to create a macro to solve my problem but unfortunately I'm not having much luck and just end up doing it manually every time.
I have 2 worksheets with detailed financial data on, that I need to collate into one worksheet that holds a subset of the data.
So I need a macro that will do the following:
- create a blank worksheet with a set of standard column headings i.e service, category, item, year 1, year 2, etc (example of a manually completed DATA worksheet included in the xls)
- on each row starting at row 9, copy the values/text from columns, which I have highlighted in yellow/green along that row, only if column T on otherexpenses and AD on staffingplan has a value in it +- but not 0 or blank.
- then paste the data into the blank worksheet under the headings
The idea is to keep the original data the same and just copy and paste the rows and columns i need so that I can create a pivot table to analysis it.
Thanks in advance for your help
I'm sure most of you will be able to do this in your sleep and have probably answered this sort of question already. I've attempted to create a macro to solve my problem but unfortunately I'm not having much luck and just end up doing it manually every time.
I have 2 worksheets with detailed financial data on, that I need to collate into one worksheet that holds a subset of the data.
So I need a macro that will do the following:
- create a blank worksheet with a set of standard column headings i.e service, category, item, year 1, year 2, etc (example of a manually completed DATA worksheet included in the xls)
- on each row starting at row 9, copy the values/text from columns, which I have highlighted in yellow/green along that row, only if column T on otherexpenses and AD on staffingplan has a value in it +- but not 0 or blank.
- then paste the data into the blank worksheet under the headings
The idea is to keep the original data the same and just copy and paste the rows and columns i need so that I can create a pivot table to analysis it.
Thanks in advance for your help