AutoUpdate cells with statistics

  • Thread starter Thread starter Jubelnar
  • Start date Start date
J

Jubelnar

Hi ALL
I really really hope you can help me out on this one.... :confused:

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
+-------------------------------------------------------------------
 
No one with a solution to this problem? Or dont you understand what I
need? :rolleyes:

Thanks in advance for trying...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading data from a list box 6
calling cells from other sheets and listing 3
Pasting to an address specified in a cell 4
Assigning cell values with VB 3
Problem with spreadsheet 1
Loop thru lines of text in a cell and extract specific values: please help? 2
if cell value matches then copy another cell 8
search for cell value and return row values 1

Back
Top