auto update

I have an excel 10 spreadsheet that I add data to 5 days a week. I use the 30 last data points to create a chart. Currently I have to change all points on the chart every time I add to keep a rolling 30 day chart. Is there a way to set up a filter or some other means to automatically use the...

Hi, I am new to excel and trying to develop a Daily Status report. I am trying to figure out how to have the date and time update automatically when I open the excell sheet in one specific cell, not a colum or row, is this possible? thank you. :confused:

hi i create the Bill of material sheet using multiple column dependent data validation (drop down list) My selection is when i select cell Value in Column A drop down list then cell Value in Column B drop down list show only range/List related with column A cell value. My problem is When I...

Hello, I was wondering if anyone is able to help me out. I am fairly new to VBA, but I have a fair amount of background in Excel. I am trying to pull data from various websites that is updated periodically. As a simple example, the US Bureau of Labor Statistics releases the unemployment rate...

Hello, We're using Excel 2007 with XP. Two workbooks are used for production scheduling. WB 1, the master, is used for bringing in orders and sorting to 6 workgroups. WB 2 is used to schedule the work. The workbooks cannot be combined. WB 2 is a copy of WB 1 with the addition of scheduling...

Hello, I've seen several similar topics here, but not applicable to my situation as I understand them. We're using Excel 2007 with XP. The workbooks are used for production scheduling. WB 1 is used for bringing in orders and sorting, it has 24 worksheets. WB 2 is used to schedule the work, it...

I'm using my Excel to grab a web query of daily temperature, but it updates more than one time per day. All I want it to do is take today's weather forecast, store it on another sheet and then do it again when the day changes. Is this even possible to do? :( Sorry if it's too complicated...

Can anyone help with the above, There is an auto update box that come up everytime i open my document and i am always clicking on dont update. Its beginning to get on my nerves actually. Soulution? Cheers Paul

Hi all, I'm pretty sure this isn't the most difficult task, but I can't quite figure it out. I need 5 or 6 single sheet workbooks all with the same 20 columns, but each with different sections of data below and of varying lengths (some to be chosen from spedific drop down lists) , all...