| Date | Auteur du sujet | Sujet | Extrait du message |
|---|
| 08/09/2011 à 10:16 | benbenben89 | Automatically fill an Excel table via another one | Basically the 5No different files will be on a network at 5No different place (folder) . At least the number of file will increase as in reallity 1No data file = 1No project . What I would like is to have 1No sheet located in the supervisor file by project . If I do a new project , that will create... |
| 08/09/2011 à 00:28 | benbenben89 | Automatically fill an Excel table via another one | That is exacly what i wanted !! thank you so much ! Now i need to found a way to automaticlly trace a graph with the evolution of the status A , status B and not commented (vertical axe) and date (horizontal graph) i need as well now to ajust the code in order to integrate it into 5 different data f... |
| 07/09/2011 à 22:16 | benbenben89 | Automatically fill an Excel table via another one | 5No means 5 quantity , sorry for the syntax... |
| 07/09/2011 à 21:32 | benbenben89 | Automatically fill an Excel table via another one | The data located in "sheet 1" take the information of the "table sheet" .Indeed , if you change in the "table sheet " the quantity of Status A , Status B etc etc , the quantity is sent to the "sheet1" . That is the first point . Because I will have in total 5No different data file , I need what I ca... |
| 07/09/2011 à 20:55 | benbenben89 | Automatically fill an Excel table via another one | Sorry excel 2007 ! I have the VBA editor... |
| 07/09/2011 à 20:51 | benbenben89 | Automatically fill an Excel table via another one | VBA with excel 2008 ; why that is not possible ... |
| 07/09/2011 à 20:39 | benbenben89 | Automatically fill an Excel table via another one | To do the step 2 , basically I am using the "connection fonction " located in the excel "data" menu . But may be the best way is to do everything in VBA. My variable are I have not create est the supervisor .xls file , as I do not know how to fill it automaticlly "So with the datas of your pdf, if I... |
| 07/09/2011 à 09:53 | benbenben89 | Automatically fill an Excel table via another one | Good morning all ! Could you please give me some help ! I attached basically what I woould like to do on excel : step 1 : from 1No file called "data file.xls" , fill up manually information (I know how to do) step : 2 : export the information from "data file.xls" to a new file called "supervisor.xls... |