Good Monday Morning!~
Getting an early start this morning!~
I have a Pivot Table that looks like this:
Bid Manager
Doe, John
Pursuit One
Pusuit Twelve
Pursuit Gator
Smith, Jane
Pursuit Fly By
Pursuit Forty-Three
To the right of the Pivot Table I have:
2/6 2/13 2/20 2/27 3/5 3/12 3/19
So it looks like this:
Bid Manager 2/6 2/13 2/20 2/27 3/5
Doe, John
Pursuit One
Pusuit Twelve
Pursuit Gator
Smith, Jane
Pursuit Fly By
Pursuit Forty-Three
They can input high, medium and low to show their availability for each week for each pursuit.
My problem is when you refresh to add a new pursuit the rest of the sheet does not add a row, so all the other rows get thrown off.
I know this is less than ideal, I am just trying to get something to work until we get the database built. AND something that doesn't require having 20 spreadsheets and multiple data entry!~
If there is another way to accomplish, please point me in the right direction!~
Thanks so very much!~
Getting an early start this morning!~
I have a Pivot Table that looks like this:
Bid Manager
Doe, John
Pursuit One
Pusuit Twelve
Pursuit Gator
Smith, Jane
Pursuit Fly By
Pursuit Forty-Three
To the right of the Pivot Table I have:
2/6 2/13 2/20 2/27 3/5 3/12 3/19
So it looks like this:
Bid Manager 2/6 2/13 2/20 2/27 3/5
Doe, John
Pursuit One
Pusuit Twelve
Pursuit Gator
Smith, Jane
Pursuit Fly By
Pursuit Forty-Three
They can input high, medium and low to show their availability for each week for each pursuit.
My problem is when you refresh to add a new pursuit the rest of the sheet does not add a row, so all the other rows get thrown off.
I know this is less than ideal, I am just trying to get something to work until we get the database built. AND something that doesn't require having 20 spreadsheets and multiple data entry!~
If there is another way to accomplish, please point me in the right direction!~
Thanks so very much!~