As Sam says, how does your new info get in. Do you manually insert, where???
As it now sits you can define a name
months
refers to
=offset($a$5,3,0,13,1)
and then
inside
=offset(months,0,2)
then use
=nameofile.xlsx!months
and
=nameofile.xlsx!inside
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Saturday, November 19, 2011 7:25 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Making Chart more useful to readers
To suggest a suitable solution, you will have to clearly mention how your
weekly data gets input. As of now, it is not clear how a new set of data is
added to your table.
>From the attached file, can you confirm if that is how you want the charts to
>look like
Regards,
Sam Mathai Chacko
On Sat, Nov 19, 2011 at 6:15 PM, Steve Weaver <steveweave...@comcast.net> wrote:
Hi all,
I would like to change the attached spreadsheet to allow for easier weekly
updates and to provide the readers with a little more useful information. To
accomplish this I would like to do the following:
a.. make the rolling 13 week data dynamic so that when the current weeks
information is added it will automatically use only the most recent 13 weeks of
data
a.. on the chart showing the Order Bookings ($), split each weekly total
between the inside and outside bookings
Thank you in advance for your help.
Steve
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
Sam Mathai Chacko
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
