Hi, I have a table which basically shows the tanks we have in our winery, I have another sheet that I can input Batch name, date harvested, days needed in Tank 1(T1) and days needed in Tank 2(T2) ie. so I can harvest into one tank and then rack or press into another tank. Also data about how many days in T1 and how many in T2.
I would like to automatically fill the planner table with the batch and tonnes into the appropriate cells when the tank is being used.
i tried vlookup but it comes unstuck whenthe tank gets used twice. It finds the first instance in the input table and fills the cells appropriately for Tank 1 but if I try and use the tank again it wont find it. Also havent got around to filling Tank2 data.
I am guessing I will need a macro for this If anyone can help and if they are in New Zealand I will get them a bottle of good wine for their troubles, sorry for anyone outside of NZ as it gets a bit tricky sending wine over seas.
Thanks in advance especially those that cant take me up on a free bottle of wine
Cheers
I have attached my first attempt so you can see what I am trying to achieve
I would like to automatically fill the planner table with the batch and tonnes into the appropriate cells when the tank is being used.
i tried vlookup but it comes unstuck whenthe tank gets used twice. It finds the first instance in the input table and fills the cells appropriately for Tank 1 but if I try and use the tank again it wont find it. Also havent got around to filling Tank2 data.
I am guessing I will need a macro for this If anyone can help and if they are in New Zealand I will get them a bottle of good wine for their troubles, sorry for anyone outside of NZ as it gets a bit tricky sending wine over seas.
Thanks in advance especially those that cant take me up on a free bottle of wine
Cheers
I have attached my first attempt so you can see what I am trying to achieve