Thanks Narayan, I can see the file.
I would like to be able to be able to show everything from B2 to L19 on the Project Two work sheet. This includes the chart. I was thinking of building a macro around cutting and pasting the different projects but was hoping there was a better way.
Hi Everyone,
I'm currently putting together a dashboard to manage my companies IT projects. We currently have between 30-50 ongoing IT projects that status updates are presented on bi-weekly basis.
I have put together a rudimentary dashboard but I'm struggling with a few things. Most...
Hi Everyone,
I'm new to Excel so please be gentle. :)
I'm trying to create a Macro that will allow me to change the values in a pivot table from quantity to net value. However, I keep getting a message that something is wrong the code below.
Macro1 Macro
'
'
Range("B7").Select...