I was looking in the references formulas and I find the formula "Direcction".
My goal it´s to create a new worksheet everytime that some cells are filled.
So I need one formula that alows me to put this reference and open automaticaly a new worksheet and this new table inside of this worksheet.
It is clair the question?
Someone can help me wiht that?
iMac (27-inch Mid 2011), iOS 5.1.1
I am not clear at all what you are asking. What localization are you using? The only formulas I find listed when I enter "Direc" in the formula search are shown below:
The only way I can think to create new sheets is by using a script as Number does not have any formulas that can do that.
Sorry in The spanish version of numbers I found this one:
The formula it´s add in the image also.
In any case, How can I do this Script to create a new work sheet from the cells that are marked with this "X" on the above image?
Thank you very much for any help
OK. I think I understand the problem you want to solve. You want to make schedules for a particular selection of days and items.
Question... are you missing one item in the image you showed? It seems that Dia 29/Fueuraz Max is not in the smaller table below
Hi Wayne, Not really, the smaller table it´s not really important, I was trying to do the new sheet with it in that case.
What I want is to use the dates in the row with the items markeds to create a new worksheet.
I made an example donw here.
I have the first table, than from it, I want to do 4 new tables
I mean, everytime that I finish with one column I want to have a new table (in a new work sheet) with that items markeds.
Do you think that script it´s possible to solve this?
How can I do it?
how can I create a new worksheet every time that one cell it´s filled
