Automatic updating graphs in excel sweet dating ru
For example: If data contains 06/01/2011 in cell A1, then data needs to be pasted to "Jun" worksheet within the same workbook. I just thought that MAYBE having a big button in their face will remind them.
Basically I want to export data from excel worksheets to various places on a word document I had. I basically have 1 constant worksheet that contains all my affiliates info (Name, Address etc), which i'd like to use to populate some bookmarks in my word template, and then i have another worksheet for the previous month, indicating sales etc for that affiliate. Matt Hello, I am pretty new to excel programming/messing around so I'll refer to those who are much wiser than I am.
(I do not manually enter the data, it is a formula that I do not wish to delete.) I know I can manually move the data that the line is pulling to make it stop on the last month, but I have a graph for 36 different departments and that's a pain to have to manually adjust 36 graphs each month.
Is there a way to tell the line to stop if there is no data? Hey everyone, I'm really hoping someone can help me with this...
What I have done is copy the original sheet and am updating the sheet for another regions source data by going to the source data.
The source data is all in the same row/column format, but each regions source data has its own sheet. Perhaps a way to update all 5 charts references at the same time.