[
View attachment New Project Log-Moved29072011.xls
Hi Guys,
Very new to the whole VBA thing.
Wondering if someone can help.
I have built a very basic form which allows a data sheet to be populated. I want a second sheet that I can use to generate reports.
Using the week number as a reference i would like to pull all the information from the relevant rows to the second sheet
So....if it is the 29th July and therefore week 31 can i pull all the information from the rows that relate to that week? The number of rows will depend on the amount of updates and the amount of projects in play at that time
When it has been moved over can i get Excel to draw a border round it?
Thanks in advance!!
Hi Guys,
Very new to the whole VBA thing.
Wondering if someone can help.
I have built a very basic form which allows a data sheet to be populated. I want a second sheet that I can use to generate reports.
Using the week number as a reference i would like to pull all the information from the relevant rows to the second sheet
So....if it is the 29th July and therefore week 31 can i pull all the information from the rows that relate to that week? The number of rows will depend on the amount of updates and the amount of projects in play at that time
When it has been moved over can i get Excel to draw a border round it?
Thanks in advance!!