Excel Automation

[yatindatta]

Hi I am a newbie at excel and just joined an advertising firm. I have been a given a project to complete in excel and it's a bit difficult for me given my experience with excel and based on whatever I know I am pretty sure the task I am trying to automate using excel formulas is not easy. I have attached a screen shot and the excel of the tables below and I will explain what I am trying to achieve
Capture.JPG


We have a series of campaigns which we give a number ( 1, 2, 3, 4....... 100). Based on clients interest we start running the campaigns and our systems capture the hits. So we start investing as soon as we get the second hit for a particular campaign in a focused way. In the snapshot you can see I have started capturing the campaign hit numbers for the territories in column M. As soon as a particular territory hits we increase the Double by 1. The count in each row is previous count - the previous double ( eg Count J19 = J18-K18 ( Double ) ).


Depending on the count we invest units in the campaign which have got double hits which is depicted between columns A2:A12 and C2:C12. We will invest in the territories till the time a territory campaign hits a third time which is depicted in column M by Orange filled cells.

Generally we get our return on investment as soon as a campaign territory hits the third time we check for the ROI in columns P:S. So in the screen shot you will see that territory 11 hits for the third time in C26. So if this happens we will check for the count between column P:S and invest again on the campaigns according to this table until we reach the goal in columns. A2:A12 and C2:C12. As soon as we hit the goal, the double hit of the campaign campaign which has hit for the 3rd time becomes the first number of the array and the 3rd hit becomes the last campaign in the array and we will start entering the next campaigns thereafter.

Basically I want to create an excel where everything is automatic. I just have to put in the campaign numbers one by one s they are initiated in a cell for input( Eg in this case 11,67,56, 75..... ). I just have to input the campaigns in one cell one by one and the excel automatically tells me in which campaign to invest and how many units.

I have attached the excel which I use to do my job manually.

Requesting help of expert forum users for automating the excel. Thanking you in anticipation

[AliGW]

You already have a thread running on this here: https://www.excelforum.com/excel-pro...tion-help.html

Please read our forum rules, to which you agreed when you joined. They apply to us all. No duplicate threads, please. This thread is closed.