Process Automation

[Kusini]

I am looking for a way to automate this process. The table in the file marked as Actual depends on the first two tables Vol and Budget. I need an idea of how to automate the process.

Here is a sample file - https://www.box.com/files#/files/0/f/0/1/f_2514961751.

 

[Mohammad Basem]

Kindly note that the file is inaccessible. The site is requesting log in details.

 

[Kusini]

Hi thanks,

Here is the correct link to the file. https://www.box.com/s/b3ce883672eba986ad41

 

[Mohammad Basem]

For some reason the file can't be downloaded.

 

[Kusini]

The link works I just tried it

https://www.box.com/s/b3ce883672eba986ad41

 

[Mohammad Basem]

I managed to download the file using Chrome but couldn't with other browsers (IE9 and FireFox)!

There is something wrong, but don't know where.

 

[Mohammad Basem]

What kind of automation are you looking for? What is the anticipated result?

 

[Kusini]

The table called Actuals involves using a formula to multiply aspects in table Vol and table Budget. I was aiming at automation of this process.

 

[Mohammad Basem]

I can see from the table that formulae exist in the first column and few rows (bold) of the table Actuals. You can just extend (horizontal / vertical autofill) or copy and paste the formulae in the desired location.

 

[Kusini]

The formula changes for every row that is bold to make it the reference row. This is only an extract, the file I'm working on has 50,000 plus rows and the reference rows are almost 100. So to change the formula 100 times is too much and I have 15 similar files to work on and this exercise is done every quarter, thus its very labour intensive if done manually.