#46
|
|||
|
|||
Guess what?
I figured out how to get the Pivot Tables to auto-refresh by adding a couple lines of code..... right-click on the tab and added the code and now it refreshes! nice. Okay, so one last time I would like to thank you for all your help and for educating me. I am about to release the new spreadsheet on my co-worker and hopefully it works well for him. Thanks so much! |
#47
|
|||
|
|||
You know what, there is one last......... one final question that maybe you can help with.
The last thing I am looking to do is make the Pivot Table display every other row as an alternate color so it is easier to follow the data across. I'm working on this now, I'm guessing it can't be too hard. |
#48
|
|||
|
|||
Disregard, I got it all.
Thanks again for everything. I owe you. |
#49
|
|||
|
|||
Quote:
Quote:
Quote:
Next step...charting! |
#50
|
|||
|
|||
Not even a problem. Good clean fun.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel, transfer data from Master Sheet to sub sheets, using key word from column | anvqui | Excel Programming | 9 | 06-16-2015 01:35 PM |
Need help in automating data from multiple sheets into a single sheet | veedee | Excel Programming | 8 | 06-12-2014 10:04 PM |
Need help in automating data from multiple sheets into a single sheet | veedee | Excel | 1 | 06-11-2014 04:01 AM |
Combine Data From 2 Sheets into a new sheet | bremen22 | Excel | 1 | 09-11-2013 12:59 PM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |