I am having trouble with making a code do what I want. I am trying to get a workbook with multiple sheets working in this way. if I have a main sheet and I add data to it I want the data I add to it to populate other sheets within that workbook based on what I type in a single column.
I have successfully made it work based off of a code provided in another thread for excel but I cannot get the same concept to work within open office calc.
Any suggestions? or code examples/solutions would be fantastic.