Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoUpdate cells with statistics
Hi ALL I really really hope you can help me out on this one.... I have done some heavy programming for calculating and evaluating ou logistic setup in a larger danish company. In this there are include automatic update of stock levels, sales etc. from SAP. What I would like to do, is to upload certain statistics into cells which is listed in a column by date. Example: 1. On the 26th of July I update the sheet with data from our ERP-syste SAP. 2. I push a macro button within the sheet and all datas are held int the sheet and kept as values. 3. Then I would like some statistics of these values to be kept in "value"-cell for trending values thorughout the year in charts. Today will have to copy all wanted values down to a line out from curren date, which is held in a big all dates coloumn (1st of january to 31s of December). Please see attachment for example... Your help is VERY appreciated.... :rolleyes +------------------------------------------------------------------- |Filename: Table.JPG |Download: http://www.excelforum.com/attachment.php?postid=3629 +------------------------------------------------------------------- -- Jubelna ----------------------------------------------------------------------- Jubelnar's Profile: http://www.excelforum.com/member.php...fo&userid=1051 View this thread: http://www.excelforum.com/showthread.php?threadid=39011 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoUpdate cells with statistics
No one with a solution to this problem? Or dont you understand what I need? Thanks in advance for trying... -- Jubelnar ------------------------------------------------------------------------ Jubelnar's Profile: http://www.excelforum.com/member.php...o&userid=10517 View this thread: http://www.excelforum.com/showthread...hreadid=390114 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoUpdate | Excel Discussion (Misc queries) | |||
AutoUpdate | Excel Discussion (Misc queries) | |||
Help with autoupdate.... | Excel Programming | |||
Help with autoupdate.... | Excel Programming | |||
Help with autoupdate.... | Excel Worksheet Functions |