bbuk9999
05-09-2016, 04:48 AM
Hi all,
I am trying to fill a formula in dynamic cells. I am attaching the VBA file with an example to show what I want to do. In the attached file, ("Container Yard") sheet is the dynamic table and ("Yard Map") sheet includes the cells that I want to be filled with the formula. The formula that I want to use is in the ("Yard Map") sheet. I want this formula to be generated according to the generated dynamic table. The example in the file: the dynamic table is generated with 10 rows and 15 columns in ("Container Yard") sheet with values. In ("Yard Map") sheet the formula should be generated in cells with 15 columns and 5 rows, as this formula is used to see how much percent are the cells equipped by vales. Your assistance is appreciated.
I am trying to fill a formula in dynamic cells. I am attaching the VBA file with an example to show what I want to do. In the attached file, ("Container Yard") sheet is the dynamic table and ("Yard Map") sheet includes the cells that I want to be filled with the formula. The formula that I want to use is in the ("Yard Map") sheet. I want this formula to be generated according to the generated dynamic table. The example in the file: the dynamic table is generated with 10 rows and 15 columns in ("Container Yard") sheet with values. In ("Yard Map") sheet the formula should be generated in cells with 15 columns and 5 rows, as this formula is used to see how much percent are the cells equipped by vales. Your assistance is appreciated.