Need to populate cells based on other cell entry options

I have attached the file called daily action plan test

This is an example of what I need to do

If T21 = o a19 and b19 should go to ad4 and ae4 or next available line without entries

If T 21 = m a19 and b19 should go to bg4 and bh4 or next available line without entries

Basically on the first set of forms when I make an entry in col a19 and b19 I will then choose to enter an o or m in T19. This will determine which of the next set of forms the entry will get carried to and the entry should then fall to the next open line. (if that is possible I am not sure or do you have to set the formula so it goes to a specific line only?

The entire sheet of entries will go into column a19 and b19 with nothing repeated or in any specific order. Each of those line entries will need to be pulled over to one of the other 2 forms labeled ops or merch (o or m)

Thanks

Mike

I have to look at this a little closer tonight but it looks like it will work.

I don't understand your question above..If the value is O/M is it always blank? Is what always blank?

Could you help me understand how data validations / pivot table would work and would this be more effective?

Hi Vlady

I have tried to figure this out and CAN'T!!! errrr I have copied and pasted to AD & AE 53 and changed the formula where necessary however I must be missing something.


The formulas you provided seem to work and as you can see the formulas are currently in the first of 7 forms which are the ones marked for Sunday.I have tried to copy the formulas down to use on each of the following days and changed the column numbers but can't get it to work.

Monday:
AD 53>97, AE 53>97 and BG 53>97, BH 53>97 Should hold the entries from A&B 68>97

Tuesday:
AD 102>1456, AE 102>146 and BG 102>146, BH 102>146 Should hold the entries from A&B 117>146

etc

I have attached the file again.

Mike

I also need the associate columns filled out (AY4 & CB4) from the main sheet.

Hi vlady

I have been going formula crazy haha.

A couple of issues

As you can see on the copy I have attached when i type in v69 it does not populate ay54 as it should. I copies the formula and the other cells that I copied into seem to work except this specific one? can you help explain?

you can also see that when i choose an m on the main sheet on the o sheet the name populates to every cell down. How can I avoid this

Hi Vlady

I didn't quite understand how to fix the associate column based on your information however i figured since i was basically just wanting to copy this cell to the approp sheet I just copied the formula from the other cells and modified and it seems to be fine.

The projected and last year sales in V2 and V3 need to come from the first sheet "projected ly sales" and on that sheet all of the sales numbers for the year will be recorded as started with Jan and Feb.

My question is can I put a formula in V2 that will pull the projected sales number from sheet 1 based on the same date. Could it look for a match to the date within the cell range and then pull the right number from either column C G or K? or would there be a better way to set this up?

Thanks again for all your help!

Mike

Hi

I am back at my Excel application. I have attached the most recent version and one thing I have to change is in Col AY and CB. Currently if there is no entry picked in V then a 0 is populated in AY or CB. Can this formula be changed so that is an option is not chosen in V then AY or CB will stay empty.

Mike

Hi Vlady

I have a question for you in trying to figure out how to do something. This sheet I am working on has the purpose to assign work to a certain employee on a certain day and if it is not complete then to reassign it to a new day. It is this last part I am now trying to figure out how best to accomplish.

In column BB and CE I will put a drop down box with the options Yes or No. If No is chosen then in column BD and CG the employee would be required to make a selection to reassign the task to another day.

An example would be for the task on a Sunday that is being moved to Tuesday. In BD and CG could there be a drop down box with the choices Sunday through Saturday and we would choose Tuesday and when this choice is made the entire contents of BG BH and CB would be copied to A B and V on the day chosen.

If you understand what I am describing can you give me your comments on if this will work and if it is the best option.

Ok so lets look at a specific example.

If BB4 equals "NO" then this would require a date from a drop down date box in BD4 (can we put a drop down date box?). The date chosen would be 08/19/12.

Upon choosing this date the contents of AD4, AE4 and AY4 get moved to populate the next available line on the sheet for the 19th (line 116 to 145)

I have attached the up to date file. This is what I am now trying to set up

If BB4 = NO then AD4 and AE4 get copied to the next open line on the day selected in a drop down calendar in BD4

Is this possible or is there a better way?